Hi,
I have a report that pulls the production order number and some detail from the Prod Order Line table. I need to link this to the Prod Order Component table, but I need each of the Item No and Descriptions from the Prod Order Component table to be placed in seperate columns. In the Prod Order Component table each production order# may show up 20 times. I would like to limit this to 10 Item Nos and 10 Descriptions.
This what I need it to look like:
Production order#, Item No1, Description1, Item No2, Description2, Item No3, Description3, ect.
I attached my Jet report: APPFJ CUST.xls
I also attached a report that we do in Crystal it is APPFJCUST_OLD.xls (this will show how I need this laid out).
Thanks for any help and all help!!
Date
Votes
2 comments
-
Jet Reports Historic Posts as a Filter set
"Limit=","10"
So your formula would go something like
NL("Rows","Table Name","Field Name","Limit=","10","Rest of Filters") -
Jet Reports Historic Posts See attached report the red marked cell on Options and Report tab
Please sign in to leave a comment.