Hey Guys, I am fairly new to Jet and looking for some assistance. I am trying to create a grouped report that is similar to below :
Line 1 - Item Number (All items scheduled to be produced from manufacturing for the day)
Line 2 - Components of Item Number listing from the Production BOM Line table
Line 3 - Lot Numbers of available inventory that match each component item number from Item Ledger Entry table
Therefore I would expect this
Part01
PartA
Lot123
Lot234
Lot345
PartB
Lot456
Part02
etc
I have a Rows=2 setup on the both the top level and the middle level to replicate itself and the row below it but I cant seem to get the Lot number part to be under the component item number. Any assistance would be much appreciated.
Thanks
Mike
Date
Votes
2 comments
-
Jet Reports Historic Posts You need to include the nested rows in the rows=* statement of the surrounding item.
In your case I would say you need rows=3 for line 1, rows=2 for line 2 and rows=1 (or just rows) for line 3.
You have to toy a bit with how many rows you want to replicate, to get empty lines between the items.
Further I would suggest you give the Report Wizard a try.
Build a grouped report of customers, grouped by country, salesperson and city for example, and see how the rows=* trick is played.
Be aware of the 'copy sideways and down' trick to get the item on the line you need it to use it in a filter.
HTH
rmw -
Jet Reports Historic Posts Thanks for the reply I will try that out
Please sign in to leave a comment.