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.

Hi Joe, Did you try select the 3 lists and set their keepTogether property to True? As we know, the property KeepTogether can keep all selections of the data region on one page. Hope this help, Thanks, Jerry

Joe,I was looking at other threads and you had said that you set visibility of the list to be these:=iif(RowNumber(Nothing) mod 3 = 1, false, true)=iif(RowNumber(Nothing) mod 3 = 2, false, true)=iif(RowNumber(Nothing) mod 3 = 3, false, true)Try changing the most right list visibility hidden properties to read:=iif(RowNumber(Nothing) mod 3 = 0, false, true)Chicagoan ...

Sorry, that was my mistake...actually I have as =iif(RowNumber(Nothing) mod 3 = 0, false, true)..Still the address lables are not displaying proper...ThanksJoe

Hey, I am sorry.. I am not able to select three listboxes.... is that something missing on?Thanks

After reading your post again, I noticed you mentioned you put rectangle inside list. Try revising it this way. At the body layout, add one big rectangle that span enough to the width of your page. Then add 3 list control object into this rectangle. At each list, bind it to the appropriate dataset, and set visibility hidden expression as follows:Left: =iif(rownumber(nothing) mod 3 = 1, false, true)Middle: =iif(rownumber(nothing) mod 3 = 2, false, true)Right: =iif(rownumber(nothing) mod 3 = 0, false, true)Then add fields you want to these lists. As long as your rectangle does not exceed your page width, then these labels will not goes to next page. hth.Chicagoan ...

Hey thanks for your post.I tried that Rectangle, then three list boxes in side, and set the visibilities too... Still I have the same issue.My problem is, the list box values are not not showing proper..Single Line feed is coming on List box 2 and double line feed is there on Listbox 3, while preview or render and publishing thereport.My dataset has three field values, and I am concantinating into a single column in Report(like Last Name, FirstName, addresss - as =Fields!LastName.Value + " "+ Fields!FirstName.Value + vbCrLf + Fields!Address.Value Bayless John 6235 Burlingame #105, Clayon John 43 East burnside, Cytrus Max 762 Natalis Dr Hope you can see my issuenow, and looking for suggestions.Do I have to use any custom code functions to fit the three list box values onsame line..?Please let me knowJoe.

Just curious if this is how your layout setup is: List Rectangle Textbox Textbox Textbox Chicagoan ...

check this link outhttp://blogs.msdn.com/chrishays/archive/2004/07/23/HorizontalTables.aspxhope it helpsthanks,Karen

Yes, that's what someone asked me to do recently..One big rectangle, then place three list boxes there in side the triangle..I kept the other way earlier, as three list boxes, and inserted rectangle inside of the list box each and set the visibliity to the list boxes by setting the expression.But both ways, the line feed is coming, while publish on server or even export to word too..Hope you could understand ..ThanksJoe.

Is the keepTogether property setto True? Ryan P. Casey www.R-P-C-Group.com

Oh, that was already suggested.SorryRyan P. Casey www.R-P-C-Group.com

You can try: http://www.reportpax.com

Do you think you can beat me in sports betting? It’s a free game with very nice prizes. This round it’s a free ticket to any Premier League soccer match of your choice. You can register HERE to beat me! www.wsob.com