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 havejoined 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 boxandthe 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 tabfor the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, Iadjusted the body of the report itselfby 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 tabfor the report itself I inserted a rectangle and sized it to fit within what would be the actual margins of a label. Then, Iadjusted the body of the report itselfby 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 theBody 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. Pls help........ thanks for ur guidance

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.

Has anyone been able to generate the labels across?I have a query that generates 3 labels per person--first two labels the licensee information then the third label is the address information. the query has 3 rows per person the first 2 with licensee information and the 3rd row is the address info.Anyway to make it do:Jim Smith Jim Smith Jim Smithcred #11 cred #11 100 west highwayinstead of:Jim Smithcred #11Jim Smithcred #11Jim Smith100 west highwaythank you

did you ever get a reply on this? I am having the same problem - the issue is that the number of rows for my addresses can vary between 2-4. Consequently, I set the properties on the address field "Can grow" and "Can Shrink" to true. This creates a nicer looking label. Herein lies the problem - when my address "grows" or "shrinks" it throws off the alignment for the label. I've tried using rectangles. I must be overlooking something???? How can I keep the labels looking nice (with the can grow and can shrink) - without seeing them "creep" off of the physical labels? Thanks!!

I came across with the same problem above that I can't print the address labels across (vertical). Is there a way the List control will generate the data across? Then that would solve the problem unless there are some magic that I don't know about.

Hi, can anyone share with me an avery 5160, 3 columns label, rdl that is working? I already read all the follows about this but anything work for me. Regards, 123tito

I have a demo at http://www.reportdemos.com. It demo's the templates I sell at http://www.reportpax.com.Let me know if you have any questions, Jim

Jcw81 - looks like no one answered your original question... I think what will work for you is to use a Table data region instead of a list. then put a Rectangle in the table cell. Then layout the label inside the rectangle. This should preserve the size of each label.Hope that helps,-LukaszThis posting is provided "AS IS" with no warranties, and confers no rights.

There's an alternate solution to the multiple column bug ('cause yeah, that's what it seems to be) that's detailed over here:http://forums.asp.net/p/1373432/3037934.aspxIn effect:1. Add Three List Controls To your Report Layout.2. Place them side by side.3. Add the 8 TextBoxes in the each List (as in your case) and Enter the Values asEmolyee Number Fields!Employee NumberFullName Fileds!FullNameso on4. Set the Visibility condition for the lists asFor the First 'List' as =iif(RowNumber(Nothing)mod3 = 1,false,true)For the second list as =iif(RowNumber(Nothing)mod3 =2,false,true)For the Third List as =iif(RowNumber(Nothing)mod3 = 0,false,true)5. Run the Report.And that worked for me, though I'm still trying to figure out why. Still working to see if I can get this basic solution working with a table to standardize the vertical layout problem that was jcw81's original issue.Ken Smith

After playing with this for a while, I was able to get it. I had to nest the TextBoxes inside a Rectangle inside a Table inside a List, I then repeated that same list three times horizontally (side-by-side), and then I had to specify the visibility rules for the Lists as mentioned in my previous post. The Rectangle allowed me to get mutiple Textboxes inside a given table cell. The Table cell allowed me to specify an absolute height. The List allowed me to get multiple columns (since the normal way to specify multiple columns sure appears to be broken, if my experience and other folks' experience on this thread is any indication). And the funky visibility rules allowed me to get the Lists to show up in the right places. Uggh. It sure as heck seems like there ought to be a better way to do this -- perhaps someone from MSFT can help?If anyone is interested, I've placed the RDLC for the report I got working here. It won't work out-of-the-box for anybody else (since it's linked to a specific strongly-typed DataSet), but it'll give you an idea about how to get it working. Ken Smith

Excellent Ken. Your solution is as crazy and convoluted as the MSFTSSRS development team - but in a good way. Useful.ow. that hurt.

Ken, Your link to your sample doesn't work. Can you re-post? Thanks. lunchroom

Sorry, for some reason my website is filtering out any file with the .rdlc extension. What I get for using GoDaddy, I expect. At any rate, I renamed it to have a ".xml" extension, and it's reachable now. http://wouldbetheologian.com/MailingLabels.xml Download it, and rename it to MailingLabels.rdlc. Sorry for the mix-up. Ken Ken Smith

Thanks so much for posting your struggles and your solution with this problem. I downloaded your sample and modified it for my application. However I get three pages with a single column instead of 3 columns on a single page. Does your DataSet have 30 rows with the same data repeated or are you doing something else? Any suggestions are greatly appreciated.Shane

@shane If possible, do yourself a favor and use a dymo for labels instead of page of labels for many reasons. If interested, I posted a solution here: http://staceyw.spaces.live.com/blog/cns!F4A38E96E598161E!1570.entry

I found a tutorial on tech net that provided a workable solution for me. It does use the columns feature and is very similar to what Ken Smith suggested except using columns instead of the code in the hidden property.http://technet.microsoft.com/en-us/library/ms155816(SQL.90).aspx

Hey.I am running with the Mailing Label issue.I have a single column, that I am concantinating the report fileds (Name and Address.)The list boxes are notshowing the mailing list proper..My Report margins are .15 left and right & .4 for top and bottomList boxs size 2.4*1I placed the List box first, then kept a rectangle inside the list box and set the visiblity to the list boxes as=iif(RowNumber(Nothing) mod 3 = 1, false, true) =iif(RowNumber(Nothing) mod 3 = 2, false, true)=iif(RowNumber(Nothing) mod 3 = 3, false, true)Can you give your suggestion, how to make it work for the three list boxes to show the labels horizantally..ThanksJoe.

Hi..I have an issue with Mailing Labels using SSRS 2008.As I do have 2 columns(concantination Fistname & Last name and concantination of Address1, Address2, City, Zip) .. In the design view, i set the report layout properties .. Left and right as .15 and top and bottom as .5Created the dataset, added three list controls to the report layout.. Then placed a rectangle objects inside the list boxes, then assigned the column value with the concantination of all fields in one column.Then set the visibility for the first List box asiif(rownumber(nothing) mod3=1, false, true as well as the rest 2I want the three list boxes to disply the labels horizantally and while running my report, I am not able to see the labels properly on the three list boxes .. and I am confused...Can anyone give your suggestions..Thanks in Advance..Joe.

Hi..I have an issue with Mailing Labels using SSRS 2008.As I do have 2 columns(concantination Fistname & Last name and concantination of Address1, Address2, City, Zip) .. In the design view, i set the report layout properties .. Left and right as .15 and top and bottom as .5Created the dataset, added three list controls to the report layout.. Then placed a rectangle objects inside the list boxes, then assigned the column value with the concantination of all fields in one column.Then set the visibility for the first List box asiif(rownumber(nothing) mod3=1, false, true as well as the rest 2I want the three list boxes to disply the labels horizantally and while running my report, I can only see two list box values and the third one is pushed out to next page...I am not able to see the labels properly on the three list boxes .. and I am confused...Can anyone give your suggestions..Thanks in Advance..Joe.

Hey, did u get it work? Can you give the suggestions how to print the labels horizantally?ThanksJoe

For ssrs 2008, I tried the solution with 3 separate lists and doing the invisibility option and still got line feeds for the first page.If you create columns on your report and use 1 list, this will work fine. when you render the report you will see one column, but look at print preview or a pdf export. It will look fine.monikhr

This is NOT working for me. The 'label' just displays AND prints as one column every time. I'm setting the Column prop. to 2 or 3 and just trying to get one field to display using a table->list->field.Can't believe this is so difficult for RS.

Sorry - multi-column support is working just fine in SSRS 2008 - I'm the one with the problem. I was expecting labels to print across, but they print down and my sample report didn't have enough data to show this. All you have to do in 08 is set the column number and spacing in the Report object.

If Anyone is still interested in doing Horizontal labels. I have an example on Simple-Talk for a Calendar Report which displays information horizontally. http://www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/#hr The same concept will work for labels. Let me know if you want me to make an update to show how to do it for labels. I did a label version a while back just need to find it and post it.

I wanted to thank Ken Smith for rdlc file, but I also want to point something out that I didn't understand when I used the report to build a 2 column report instead of the 3 column report. The formatting was great, but it was skipping every 3rd vendor. The cause of the issue ended up being an expression that was placed on each textbox in the visibility properties. Here is what it looked like, and what it should be: What Textbox1 was: =IIF(RowNumber(Nothing) mod 3 = 1, True,False) What Textbox1 should be: =IIF(RowNumber(Nothing) mod 2 = 0, True,False) What Textbox2 was: =IIF(RowNumber(Nothing) mod 3 = 2, True,False) What Textbox2 should be: =IIF(RowNumber(Nothing) mod 2 = 1, True,False) From what I read I think the code in textbox 1 means to suppress the even numbered value, while textbox2 means to suppress the odd numbered value. Once I changed this the report works great! Thanks again, Ken Smith!

I am creating a mutlicolumn report with the grouping. It has 2 columns in it. I am trying to put each group in new page using page break. But the report put the new group in the next column rather than the next page. page break is acting like a column break. I also tried to put two page breaks but the number of rows in each group is unknown so if number of rows in the group is ending in 1st column then it works fine and put the next group in next page but if the data in the group is ending in 2nd column then the next group data starts from second column of next page. Ideally it should start from the 1st column. Anyone has solution for this problem? Thanks in advance

please tell me how to create 1"X 2 5/8" Labels in rdlc... please give the step by step process.......

if i use the conditions only the third list is displayed what to do.....