Hi!
I am new to Jet Reports (just did level 1 training last month). I need to create a report that will give me sales by customer, by item #. It would look something like this:
Customer Name
Item # Quantity Sold Sales Amount
3565 10 $1,000
4578 25 $4,500
Total $5,500
I can get the information but I can't sort it first by customer and then by item #.
I have tried starting with the sales invoice header table, pulling customers with sales that month, and then linking to the sales invoice line table to get the detail. This gets me the data, but it is sorted by customer, sales invoice, and then by item #.
So I tried to start with the item ledger file, pulled all sales documents for the month. Then linked the shipment doc # to the customer table to get the customer #. I can get this to sort by item#, but not by Customer.
I think I tried starting with the customer ledger entry, but I couldn't get to sort like a want there either.
Any ideas? I'm hoping that it is simple, and I'm just to green to figure it out!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi there,
You'll want to split it in two separate NL's, one for the customers and one for the items.
The basic idea would be:
Row 1 NL(Rows=3, +Customer Name, etc.)
Row 2 NL(Rows, Item, etc.)
Row 3 blank row to space the customer blocks
The main point here is the NL("Rows=3"; …) this duplicates this row plus the next two. That way you can split it in easier chunks.
Please sign in to leave a comment.