Sage 100

Happy Tuesday!
I have a new client who currently utilizes Avery Design Pro to generate on-demand labels for showroom inventory items, which allows them to select the desired label starting position on the 30 label sheet. They want to bring the label generation into Sage 100 but can't use a label printer because of needing various color coding on labels, so we're stuck for now with the Avery 5960 sheets, I believe. Has anyone else ever been able to get Crystal to somehow insert a desired number of blank records for a  need like this? My research has pulled up a lot of instructions related to "Commands" but I can't get them to work with the SOTAMAS90 DSN, plus I also will need to bring in a subreport to the label for IM_PriceCode detail. Please let me know if anyone has any suggestions. Thanks in advance!
#crystal

​

------------------------------
Amber Prayfrock, Blytheco
------------------------------

(Untested idea).
Set up a UDT with numbers as the key value (01,02,03,04,05...29). 
Set your report with an exclusive outer join (assuming this is possible in CR?), with a filter on UDT results equal to the number of spaces you want (parameter?).
Sort the UDT results first (somehow).
Suppress your sub-report (and any text fields, lines...) when the UDT value is not NULL.
...

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Thank you, Kevin! I'm on that path right now. So far, I can get the records to print as many times as the specified UDT value...i.e. 3 labels for each item (so that is a new way to perform that trick) but still working on blanks.

------------------------------
Amber Prayfrock, Blytheco
------------------------------

Original Message:
Sent: 04-23-2019 18:35
From: Kevin Moyes
Subject: Control starting label with Crystal Reports

(Untested idea).
Set up a UDT with numbers as the key value (01,02,03,04,05...29).
Set your report with an exclusive outer join (assuming this is possible in CR?), with a filter on UDT results equal to the number of spaces you want (parameter?).
Sort the UDT results first (somehow).
Suppress your sub-report (and any text fields, lines...) when the UDT value is not NULL.
...

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------