I don't believe there is any way of doing this with Crystal Reports itself.  I was never able to get a page or section to repeat based on the quantity, or any number field in the report.  For our client who needed 1 label for each unit instead of one label for each item line, we had to create a SQL process where we pull the Sage data into SQL tables, then run a stored procedure with a loop to turn the results into multiple lines that are then printed by the Crystal Report.  

Hi Hyanaga.

Thank you for the information and for replying! Is creating an SQL process something that is easily done, or is it better to reach out to a professional? Also, if you don't mind me asking, are there any documents or Sage Knowledge articles that can guide me in creating this process?

Setting it up in SQL does require SQL knowledge.  You have to install the free version of SQL if you don't already have an instance, create the connection to the Sage database, create the tables to store the data, and the actual procedure to produce the results to print.  I do not know of a KB article that explains this, sorry.  I am a consultant myself, and I have a full client list so I don't usually say this on this forum, but this is a bit specialized so if you are looking for professional help with it, feel free to connect with me.

Setting it up in SQL does require SQL knowledge.  You have to install the free version of SQL if you don't already have an instance, create the connection to the Sage database, create the tables to store the data, and the actual procedure to produce the results to print.  I do not know of a KB article that explains this, sorry.  I am a consultant myself, and I have a full client list so I don't usually say this on this forum, but this is a bit specialized so if you are looking for professional help with it, feel free to connect with me.

Hi Hyanaga,

Thank you again for your help!