decker587
asked on
Print multiple copies based on parent quantity
I need assistance with printing multiple copies of a "work ticket label".
Now when I say label, I have modified a sales order and reduced it to 2" x 4" and I have created groups to print specific detail information in a specific order.
As is, the labels print one of each work ticket.
How can I get it to print multiple "labels" if the work ticket/ order quantity is more than one?
I have tried linking an external "repeater" table, but have been unsuccessful.
I am attaching the modified crystal report.
Label-Sample.rpt
Now when I say label, I have modified a sales order and reduced it to 2" x 4" and I have created groups to print specific detail information in a specific order.
As is, the labels print one of each work ticket.
How can I get it to print multiple "labels" if the work ticket/ order quantity is more than one?
I have tried linking an external "repeater" table, but have been unsuccessful.
I am attaching the modified crystal report.
Label-Sample.rpt
ASKER
Yes, How can we get the group to print X times quantity ordered?
I am at a loss right now.
I am at a loss right now.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am still getting the same results. So, I still have something wrong.
I am attaching a screen shot of the database linking expert and a copy of the repeater table.
Do I have something wrong with those?
Database-Linking.jpg
RepeaterTable.xls
I am attaching a screen shot of the database linking expert and a copy of the repeater table.
Do I have something wrong with those?
Database-Linking.jpg
RepeaterTable.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just to add a little explanation to mlmcc's last post, when you include multiple tables in a report, when CR builds the query to read the data for the report, it will normally leave out any tables that you're not actually using in the report. So, if you link tableA to tableB, but don't actually use any fields from tableB, CR decides that you don't really need tableB and doesn't include it in the query.
If you put a field from the spreadsheet on the report (or use one in a formula somewhere, I think), that should make sure that CR actually uses the spreadsheet. Or, the Enforce option in the link screen tells CR to include a table, even if you're not actually using any fields in that table.
James
If you put a field from the spreadsheet on the report (or use one in a formula somewhere, I think), that should make sure that CR actually uses the spreadsheet. Or, the Enforce option in the link screen tells CR to include a table, even if you're not actually using any fields in that table.
James
ASKER
Linking the table and adding the How_Many field worked, but I had to add a group for How_Many and add 'Print New Page' command to the group in order for the report to run correctly. Thanks for the assistance. Some times it's a lot of trial and error.
The group header only prints once per group. You need the label to print X times per group
mlmcc