Hi all,
I have developed a report that pulls all the "Sales Shipment Line" type "Item" which "Posting Date" on the "Sales Shipment Header" is within a range.
This is the NL funtions I created:
=NL("Rows";"Sales Shipment Line";;"+Document No.";NL("Filter";"Sales Shipment Header";"No.";"Posting Date";Options!$D$5);"+Line No.";"*";"Type";"Item")
My current report is pulling fields from "Sales Shipment Line" only. Now I want to show for each row, the "Posting Date" (that is on the "Sales Shipment Header" table) too.
What should I do?
Thank you!
Marco
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Luckily for me, we have the posting date on the line due to a customsation, so I'm making this up as I go.
Here is something to get you started. Seeing how to do this you will be able to come up with better and more efficient ways in the future.
If we presume your formula below is in cell B2.
I would putC2: nf(B2,"Document No.") D2: nl("Rows","Sales Shipment Header",,"No.",C2) E2: nf(D2,"Posting Date")
That way you can access all fields on the header. However for each line, you will have the header information repeated. I would be inclinded to write the report differently.
Firstly, start with a formlua that lists all the headers. then, under that line, use a formula to retrieve the line. Modify the "Rows" in your NL for the header to be "Rows=3". With a bit of work with your absolute cell references, you'll get a nice report grouped by header.
Obviously that depends on how you intend to use the resulting report. -
Jet Reports Historic Posts Thank you for your answer. I applied the 1st suggest and it works great (in terms of performance too).
As soon I'll have time, I'll try to implement your 2nd solution (to pull all the header 1st and them match them with the lines), and I'll let you know the results.
Thanks again for your support.
Marco
Please sign in to leave a comment.