Create a UDT with a column that just has numbers counting up beyond the highest quantity you ever want to print.  1, 2, 3, 4...

The do a <= join of that UDT to your quantity column.  Put a UDT field on the report but suppress it (something from the UDT has to be in the report for it to be effective) and your lines should repeat as you wish.

Hi Kevin,

My apologies for taking so long to reply, it's been hectic. And thank you for your suggestion! 

I have a very basic college level understanding of SQL, so if I may sort of rehash what you are explaining.

The value in the quantity column would be used to look up anything <= in the UDT column.

Adding the UDT field into the report would make the report print for every value that is matched ( UDT <= quantity). This is why the column needs have numbers exceeding the possible max quantity, so that all values can be matched.

Question:

The report consists of a group header with the sales order information, and a group footer with a subreport. The subreport contains the item information.

I have a beginner's understanding of Crystal Reports, but I would think the UDF field should be inserted into the group header so the report is forced to to generate again for the next value?

Hi Kevin,

My apologies for taking so long to reply, it's been hectic. And thank you for your suggestion! 

I have a very basic college level understanding of SQL, so if I may sort of rehash what you are explaining.

The value in the quantity column would be used to look up anything <= in the UDT column.

Adding the UDT field into the report would make the report print for every value that is matched ( UDT <= quantity). This is why the column needs have numbers exceeding the possible max quantity, so that all values can be matched.

Question:

The report consists of a group header with the sales order information, and a group footer with a subreport. The subreport contains the item information.

I have a beginner's understanding of Crystal Reports, but I would think the UDF field should be inserted into the group header so the report is forced to to generate again for the next value?

The UDT strategy works to duplicate the line data, where you'd print one line per page, not the whole report duplicated multiple times.  To duplicate the entire report multiple times, you'd have to move those contents into a sub-report, with appropriate linking parameters... which is not easy to set up properly.