3-up Mailing Labels?

Question

3-up Mailing Labels?

Bret Miller

SSC-Addicted

Points: 473
More actions
April 16, 2004 at 2:09 pm

#107515

I'm trying to convert a Crystal report to SQL Reporting Services, but can't seem to figure out how to make it do 3-up mailing labels. Anyone have a clue?
April 19, 2004 at 8:00 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Bret Miller SSC-Addicted Points: 473 More actions · Answer 1

Is there a better forum for posting questions like this? I'll be happy to re-post somewhere else if there's a chance it might get answered and then re-post the answer here when I find it.

Thanks

Bret Miller SSC-Addicted Points: 473 More actions · Answer 2

How to feel stupid? Try making 3-up labels with SQL Reporting Services. Seems this is easier than you might think. The multiple column support works, but not for the preview or report manager views. Once you export to PDF, you get 3 columns.

Set the report layout so it had three columns. I used a "list" format so I could free-format the label. In preview, you can basically only tell that it is formatting each label correctly. Deploy, pull up the report and export it to PDF to get what it's supposed to look like.

Spacing is a bit more tricky since it inserts some vertical space between lines. Reducing the size vertically by one default grid unit seemed to fix the spacing so it fit on standard Avery laser-printer labels.

And now you know how to do it too...

Brandon Danner-206793 Grasshopper Points: 19 More actions · Answer 3

Thank you for the tip! You just saved me a lot of work.

Stacie Loving SSC Rookie Points: 43 More actions · Answer 4

I've managed to create labels and even have the spacing come out correctly . . . IF I don't allow the textboxes in the list control to grow or shrink. However, my boss finds the empty fields unacceptable and wants them to shrink if they are empty. Anyone have any thoughts on this?

melissa baney-469855 SSC Rookie Points: 39 More actions · Answer 5

HI Stacie,

Were you able to figure out printing mailing labels where they will print from left to right, rather than down the page.

Like this:

1 2 3 4

rather than

1

2

3

4

Any help would be greatly appreciated!!!

Thanks

SqlNewbie

Chris Quinn-821458 Hall of Fame Points: 3192 More actions · Answer 6

Stacie Loving (3/17/2005)
I've managed to create labels and even have the spacing come out correctly . . . IF I don't allow the textboxes in the list control to grow or shrink. However, my boss finds the empty fields unacceptable and wants them to shrink if they are empty. Anyone have any thoughts on this?

I do something like this with name and address fields - create one large text box to hold the complete address, and set the contents to something like this:

= IIF(Fields!add_1.Value = "","",Fields!add_1.Value & vbcrlf) & IIF(Fields!add_2.Value = "","",Fields!add_2.Value & vbcrlf) & IIF(Fields!add_3.Value="","",Fields!add_3.Value & vbcrlf) & iif(Fields!add_4.Value="", "",Fields!add_4.Value + vbcrlf) & IIF(Fields!add_5.Value="","",Fields!add_5.Value + vbcrlf) & Fields!post_code.Value

If the field is blank it is ignored (the IIF returns an empty string), but if there is something there, it is concatenated and a CrLf tagged on