Working with Label
Reports
Create new report.

Select your ODBC and Table or View. More than 4 rows are NOT recommended. You may have printing issues with your labels.

When adding your line data keep in mind if the returned value is “Empty” it will be skipped to save space. This comes in handy when Address2 is empty and you don’t want a spare line being printed.

The label type is generated from the /reports/ folder within the main web directory. You can copy the originals and paste with your own file name in order customizes label size or styles.


Getting rid of duplicates can be done in the Coldfusion Report Builder. Using your own unique copy of the CFR file open within Coldfusion Report Builder. Then select the main area and go to properties.

Under the Print Control Tab “Uncheck” the Print Repeated Values.

Changing the font sizes are the same concept as above. Using your own unique copy of the CFR you can change the Font Styles or anything else you would like within the Coldfusion Report Builder.

Using custom logos can be done by editing the path using Coldfusion Report Builder.

References
http://www.adobe.com/devnet/coldfusion/articles/averylabels.html
http://www.adobe.com/devnet/coldfusion/articles/subreport.html
http://www.adobe.com/support/coldfusion/downloads.html