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!

Regards

Pierre Joubert

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 20 at 12:33 PM

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

    How_Many

    1
    2
    3
    4
    5
    etc.

    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

    • Thank you for your reply!

      I am not allowed to add a table but you gave good idea that I think would work.

      Appreciate your trouble!

      Regards!