Hello -
What you would want to do is create a grouping report.
More information on that can be found in the Grouping and Subtotaling article in the online knowledgebase.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello Everyone,
I am trying to do something different that no one else in my company has done and having a little difficulty. I am trying to write a report that pulls all archived versions of records posted in a set period of time (say order posted on Friday, I want all records for that order that can be found in the system)
I believe I am almost there with the formula below but it is only pulling in data for the first record it finds and wont pull for everything posted that day.
=NL("Rows","Sales Header Archive",,"No.",NL(,"Sales Shipment Header","No.","Posting date",$B$3))
I had originally tried it with out the sales order number (,"No.",) in the formula but it error's out every time I try anything else.
any help at all would be very appreciated. thank you -
Jet Reports Historic Posts Thank you,
this was what I was looking for.
Please sign in to leave a comment.