Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • May 20, 2018 at 12:33 PM

    Create a "REPEATER" table with a single column (How_Many) that looks like this:



    Now, in your report, add the Repeater Table and add a join condition of: Order.quantity >= Repeater.How_Many.
    If the ">=" join option is not available, apply the same condition to the Record Selection condition.

    If you are not allowed to add a table to the database, you can use similar logic to conditionally suppress detail sections (e.g. show only Detail a and detail b if the quantity is 2).

    Add comment
    10|10000 characters needed characters exceeded