Hi,
I want to create a sales report that produces all the items, sales amt and Qty under each customer for the month.
Something like
]
and more
How do i create this report?
I can only create report with all the the information in unsorted manner. Nut i want a report that does look like above.
Please help
Thanks you
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Derrick,
It sounds like you will need to create a grouping report to get this. Start by making a list of the customers (using a Rows=4). Then you can create the list of items they purchased (using and NL(Rows) function). If you haven't created a grouping report before you can check out the tutorial KB from Jet: http://kb.jetreports.com/article/AA-00519 It starts by listing the secondary list (in your case ITEMS) first then the primary list (in your case CUSTOMERS). I usually do things the other way - start with the primary list and then do the secondary list.
Hope this helps!
Please sign in to leave a comment.