I have written a SQL query extracting a few fields from our ERP system's Purchase Order Database.
I use a parameter to enter the Purshase order number and can then get data for 1 or more lines, depending of the number of lines on the order. What I want to do is write a Crystal report to print a label for each line of the Purchase Order. How do I get Crystal to "Duplicate" the report for me, just updating the item details for each item?
For example: My Purchase Order have four lines. When I run the report it asks for the Purchase order number. It must then generate four labels, one for each line.
Any help will be appreciated!
Regards
Pierre Joubert