Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maililng Labels Expand / Collapse
Author
Message
Posted Friday, September 18, 2009 7:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 11:16 AM
Points: 6, Visits: 52
Hello ,
I am working on a Mailing Labels Report using SSRS 2008.

As per advise, first I placed three list boxes then placed a rectangle inside the list boxes to all three and set the visibility by expression


=iif(rownumber(nothing) mod 3 = 1, false, true)
=iif(rownumber(nothing) mod 3 = 2, false, true)
=iif(rownumber(nothing) mod 3 = 0, false, true)

Report was shown with line feeds on list boxes 2 and 3.

Some one advised me recently to place the rectangle first to fit to page, then place three list boxes there inside and set the visibility... I tried this way around too..
Still the report is displaying labels with line feeds.

My dataset has three columns, and I am concatenating into a single column in Report (like Last Name, FirstName, addresss - as =Fields!LastName.Value +" "+ Fields!FirstName.Value + vbCrLf + Fields!Address.Value


Should I use any custom code to fit the three list box values on same line..? Please give your suggestions..

Thanks
Joe.
Post #790738
Posted Tuesday, November 05, 2013 2:47 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 6:12 PM
Points: 827, Visits: 342
I'm sorry but what do you mean by Line Feed? Is it that the labels appear in a single column? If yes, try exporting the report to pdf and see the output.
Post #1511647
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse