hi, i have a very simple question, though i dont know how to do it:
a)i have to create a very simple report(eg: iterating over SalesHeader+Lines), but prior spitting something out i have to do some lookups etc. therefore i need to know which SO-Numbers the user punched in.
b) how would i access those values punched in into a request form?
>> i dont not have a programming license, i can only create "regular" reports
thx for any pointer!
0
Comments
The "No." field in your reports request form doesn't give you the assist lookup.
If you go to the sales header table & view the properties of field 3 "No."
If you change the Table relation to
"Sales Header".No. WHERE (Document Type=FIELD(Document Type))
Save & complile - now go to your report you will see the lookup now works as long as you specify the Type on the request form too. "Order", "Credit memo", etc...
http://www.BiloBeauty.com
http://www.autismspeaks.org
After further thinking - this will probably effect the Sales Order List. When you click on the number it wont go to the order.
Line->Card or Shift-F5 - does solve that issue tho :-k
http://www.BiloBeauty.com
http://www.autismspeaks.org
thx
*edit: it's better to put the value in a variable in order to calculate it one time only and then show the variable...if you want further instructions, just ask them
@Savatage: :-k and what about the bottom left lookup?maybe the lookupformID is the key of this problem...otherwise, i didn't understand clearly what you told :whistle:
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
if i run report ID: 206 : Sales _ Invoice, Nav4Sp1, as attached in the pictures, i need to know what the users keys into the fields, espcially the No.-field.
Lets say, the users enter "A" | "B" | "C", (see attachemnt), HOW do i access those values within the report -code>?
thx 4 ur time
tom
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
is that possible?
thx again
you should tell us what preprocessing you want to do.
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog