Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


Changing Mailing Label Size in Crystal Reports
It's easy to create mailing labels using the Mailing Label Wizard in Crystal Reports. (8.5+, at least).
But when you realize that you needed 1 inch instead of 2, how do you fix it without starting all over?
It's simple enough, but certainly not intuitive. Open the Page Setup and enter the margins for your label sheet. Then, go to the Section Expert for the Detail section and choose the Layout Tab. Here you can change x, y, x-margin, y-margin, and the Across/Down order. Verify that the number of rows and columns are correct. You may need to delete extra whitespace around the detail section to get everything to add up.
And that's it! : )

Created By: amos 3/20/2006 12:13:00 AM
Updated: 3/14/2023 7:26:30 PM

 > Guest 10/20/2008 3:30:25 AM
Thanks a lot..... small post, but usefull.
 > Guest 6/19/2009 11:18:54 AM
Geez! Unbelievable what it took for me to finally find out how to edit an existing label format. Thanks so much!
 > Guest 6/26/2009 9:04:32 AM

 > Guest 7/12/2009 5:28:56 PM
Perfect - can't thank you enough. When I think of how many times I started completely over...
 > Guest 11/9/2009 10:23:42 PM
Tks. that's all I need!
 > Guest 11/16/2009 12:14:46 PM
This is fantastic - sorted within seconds - and yet it took me a while to find this answer - thankyou!!!
 > Guest 1/25/2010 9:53:16 PM
god plese you
 > Guest 5/6/2010 9:42:21 PM
Thank you so much - been wanting to change a label size for a long time but never knew how to do it!
 > Guest 6/30/2010 9:24:38 AM
thank you very much
 > Guest 7/24/2010 9:51:07 AM
i am not getting layout tab in section expert of detail section , please specify steps
 > Guest 8/4/2010 2:08:56 AM
Tnx to this post..
 > Guest 9/17/2010 11:24:07 AM
To the guest who posted that you aren't getting a Layout Tab, in the Section Expert make sure you are sitting on the line that says DETAILS (not Details a, etc). The Layout Tab doesn't appear unless you are sitting on the upper most DETAILS line. It then appears over on the right side of the screen (next to the Common Tab).

I use Crystal Reports 11, so this post may only applies to that version :)
 > Guest 1/6/2011 6:26:47 AM
thank you so much
 > Guest 1/20/2011 10:54:47 PM
Thank you very much, saves lots of time!
 > Guest 3/5/2011 10:47:00 AM
 > Guest 6/22/2011 6:32:47 AM
 > Guest 8/3/2011 8:48:02 AM
Thanks a LOT!
 > Guest 10/24/2011 9:23:15 PM
Thank you. very helpful.
 > Guest 11/3/2011 7:19:25 PM
This is a FANTASTIC tip.
Finally, one Crystal Reports frustration solved.
thank you so much.
 > Guest 5/9/2012 4:29:22 PM
You think you know Crystal, then BAM!
Thank you for the VERY useful post!
 > Guest 5/16/2012 2:22:35 AM
Thanks So much for giving valuable tip which saves lot of time.
 > Guest 11/20/2012 8:06:37 PM
Short and to the point. Love it! Saved me heaps of time stumbling around this product. Thanks also to the guest who pointed out that you need to select Details, not Details a, b, c, etc.
 > Guest 1/16/2013 11:07:59 AM
Hi this still isn't working for me, I am sitting on Details only line and only seeing Common and Paging tabs ?
 > Guest 2/21/2013 5:37:07 AM
Knew it was hidden somewhere, thank you so much!
 > Guest 2/21/2013 5:37:10 AM
Knew it was hidden somewhere, thank you so much!
 > Guest 10/31/2013 9:33:43 AM
Thanks. I wasted 1 hour pondering over the problem.
Thanks again for the Solution. It was of great help.
 > Guest 12/10/2014 1:04:41 AM
Thank You for the useful post.