Skip to Content
May 17, 2018 at 08:26 AM

Good Morning. Can I please ask some help with a lable report that I am writing?


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!


Pierre Joubert