Crystal Reports 9 and Avery Mailing Label Tricks
I recently had to design some Mailing Label reports, and of course, needed to use a Label format which Crystal had no listing for, Avery 7159.
After searching the BusinessObjects web site I found only the one link here, explaining how to add items to the drop down list of Label Formats, but I wasn't expecting to have to edit a text file called Labels.txt! The article is old (relating to Crystal 7, and no mention of Windows XP), and even when I found the text file, added my label (after converting all my label measurements to pica's, it still would not show up in the listing. I then renamed the text file to something else, and Crystal 9 still continued to include the standard set of labels - thanks KB article for wasting my time.
I ended up typing in the dimensions of the label, spacing etc, and no doubt will need to do this every time I write a new report.
If you ever need to adjust the Label spacing, size, borders etc, after initially creating the report, here's how (I had a hard time working this out):
Change the dimensions of the mailing label through the Layout tab of the Section Expert.
Report > Section Expert > Details > Layout tab (The Layout tab is only available when the Details section is highlighted in the Section Expert.)
You need to do this because the Mailing Label Report Creation Wizard dialog box cannot be re-entered, which means it is not possible to modify the 'Mailing Label Type' of the report any other way.
You can also adjust the Page margins in the usual manner, File > Page Setup.
After searching the BusinessObjects web site I found only the one link here, explaining how to add items to the drop down list of Label Formats, but I wasn't expecting to have to edit a text file called Labels.txt! The article is old (relating to Crystal 7, and no mention of Windows XP), and even when I found the text file, added my label (after converting all my label measurements to pica's, it still would not show up in the listing. I then renamed the text file to something else, and Crystal 9 still continued to include the standard set of labels - thanks KB article for wasting my time.
I ended up typing in the dimensions of the label, spacing etc, and no doubt will need to do this every time I write a new report.
If you ever need to adjust the Label spacing, size, borders etc, after initially creating the report, here's how (I had a hard time working this out):
Change the dimensions of the mailing label through the Layout tab of the Section Expert.
Report > Section Expert > Details > Layout tab (The Layout tab is only available when the Details section is highlighted in the Section Expert.)
You need to do this because the Mailing Label Report Creation Wizard dialog box cannot be re-entered, which means it is not possible to modify the 'Mailing Label Type' of the report any other way.
You can also adjust the Page margins in the usual manner, File > Page Setup.
posted by Cod at
10:33 am
6 Comments:
Thank you...thank you...
You gave me exactly what I needed. I cannot tell you how many label 'reports' I have had redo as new because I could not figure out how to edit the dimensions! You have saved me so much time!
By
Anonymous, at 10:56 pm
Hi
Thanks for pointing me in the right direction. You probably know by now that the file you needed was Labels_en.txt for the English version and that works just fine where Labels.txt doesn't. For the benefit of anyone new reading this, you can get the Avery dimensions at this link http://www.ucap.biz/manuals/Australian_Avery_Labels.htm
By
Anonymous, at 9:48 pm
Thank you so much, you saved my life from wasting time in re-create report each time I want to change the dimension.
By
Anonymous, at 1:11 pm
Thank you for this tip. You saved me a lot of time
By
Anonymous, at 2:43 am
Your solution is great. I looked and looked and never would have found it so deep....
By
Anonymous, at 9:35 am
Great thank you! This is perfect for what I am looking for. Just trying to identify what labels were used in creation.
By
Neil, at 3:18 am
Post a Comment
<< Home