Maililng Labels

  • 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.

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

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