locked
Suppressing blank lines while working with reports in SQL Server Data Tools? RRS feed

  • Question

  • I have a report project in SQL Server Data Tools/ VS 2010 and I'm trying to suppress blank lines in the following manner:

    AddressLine1

    AddressLine2

    AddressLine3

    City, State, Zip

    I don't want address line 2 or 3 to have a line if they're blank. So I want it like this:

    123 Main St.

    Anywheresville, NY, 10001

    I can't find an easy way to do this. Can anyone point me in the right direction?

    Wednesday, April 16, 2014 8:11 PM

All replies

  • you can build dynamic expression in SSRS report to include new line VbCrLf  only in certain condition as per your requirement.

    please refer following link for this..

    http://www.mssqltips.com/sqlservertip/3011/sql-server-reporting-services-expressions-tips-and-tricks/


    MayankP
    My Blog
    Follow Me on Twitter

    Wednesday, April 16, 2014 8:31 PM
    Answerer