mailing labels in SQL Server Reporting Services

I am creating a report to be used to print mailing labels. Size 1" x 2 5/8" (3 columns of 10 labels). I seem to have everything but the vertical spacing working properly. I have used a rectangle set to the size of the labels which contains a list box containing text boxes containing expressions to pull in the fields. Some of the street addresses are two lines with the majority being only one line.

I have joined the two fields containing the street addresses and inserted a new line command so each field will print on its own line but yet be contained within the same text box. Everything except the text box containing the street addresses are set to not increase or decrease. My problem is that on the pages of the report where labels vary between the one and two line street addresses the labels tend to creep down which in some cases causes data to be printed over two labels. Any ideas on what I can do to format these to print properly?

Thanks

How did you create 3 columns mailing labels? Is there a way in reporting services to display the data in 3 columns?

Thanks

|||

Report Properties menu on the Layout Tab the first section lets you specify the number of columns and spacing for your report. I then set up a rectangle the size of the label, added a list box and the fields for the data to be shown.

|||

I changed the layout, and added 2 columns to my report, my fields are in a list control, when i preview the report it just shows in one column, the other column is not even displayed, do you know what I could be doing wrong, I am sure it is something silly?

Thanks again

Espy

|||In preview I also only see one column but if you use the print preview you should see all columns. (Took me a few tries to get all this figured out too!). Hope that helps.|||

I did the print layout and get a black screen with nothing in it

When I printed the report it just printed one column

I am not sure what I am doing wrong

Any other suggestions?

thanks for your help

|||

Sorry, I may not be much help in explaining your results; but, below are the Layout settings I have used and I have walked back through the steps: I started a blank report; went to Report - Report Properties - Layout and set the following

Columns: 3; Spacing 0.125 in

Page Width: 8.5in; Page Height: 11 in

Left margin: 0.25in; right margin: 0.125in

Top margin: 0.4in; Bottom margin: 0.5in

Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck.

|||

I was able to make it work

Thanks for your help

|||

Hi

am new to reporting service. I need to do label printing in two columns. that is coming in one column. I changed the layout-columns -2.Is it needed to change anything else ? Its showing in one column. .Please suggest anything. Your earlier conversation helped alot. Thank You very much........

|||

The following may be what you need next, repeating part of my reply posted earlier:

"Then back on the Layout tab for the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, I adjusted the body of the report itself by dragging the right side towards the left to match the right edge of the rectangle. The actual columns began to show on my report page when I pulled the right side of the body over towards the left is when (sorry, I may not be explaining this very well). Hope this helps.

Good luck."

|||

I tried that. now its comin in 2 column, but value that came in the first column is repeating in second column. But in print preview only the second column is showing. adjusted the rectangle. Some silly mistakes will be there. Then, I need 8 labels in 1 column, but only 6 is coming. I increased the report size. but no use. Please help

|||Sorry for the delay in responding to you. Did you get your question resolved? If not, I reviewed the previous posts and then recreated a label. Make sure that in your report properties (menu choice Report - Report Properties - Layout) you have specified the number of columns (8 in your case), your page width and height to match the sheet of labels, and the margins to match the sheet of labels. I then refined the Body of the report; inserted a list box linked to the data source - and sized to match the size of the label; inserted a rectangle sized to match the size of the label and then inserted text boxes with the fields I want to show. From there its just fine-tuning the margins, padding, etc. Please note that I never did get a response addressing my original question though. Hope this helps to answer your question.|||

I am very thankful to you. I got it in a nice maaner by increasing the page width. But I integrated to the program it is not showing that alignment. I am thinking font mismatch will b there . But its not working for me. If u hav any idea pls suggest that. That will help me very much. I am Sure. Thanks alot for ur proper guidings........

|||

Hi

My reports are coming correctly. But the pbms am facing is that,

If am giving page range in print preview(1-2) then 1st page 'll be showing and 2nd page's 1st column [ If 1-3 then 1st,2nd and 3rd page's 1st col; 1-1 means 1st page's ist column]

if it is coming row wise it 'll be helpful.

|||We encountered the same problem - our "fix" was to render in PDF when wanting to print only certain pages. Once entire report is in pdf then you can print specified pages.