To Print the Text continously in word file Using SSRS 2008

  • Hi,

    I want to print the Address on letter,which exported in Word format using SSRS 2008.

    CorrAdd1 CorrAdd2 CorrArea CorrCityCorrStateCorrCountry

    NULL JAYAFHREE 75 9820077455WORLISEAFACE MUMBAIMAHARASHTRAINDIA

    I want to print

    Address as

    CorrAdd1,

    CorrAdd2,

    CorrArea + CorrCity + CorrCountry

    But problem is this are prints in three lines.

    When if any one line is empty then it should be continued by next field.

    I don'tt want to leave any blank line in adress.

    Please help me as it is urgent !

    Thanks in Advance.

  • I would use an expression to create the output you want. In this example this checks for a value in Fields!CorrAdd2.Value. If there is something there, then add it on the next row after the carriage return/line feed, then add another carriage return/line feed then the area, city and country. If there is no value there then add a carriage return/line feed then the area, city & country.

    =Fields!CorrAdd1.Value + IIF(Len(Fields!CorrAdd2.Value > 0, VbCRLF + Fields!CorrAdd2.Value + VbCRLF, VbCRLF) + Fields!CorrArea.value + " " + Fields!CorrCity.value + Fields!CorrCountry.value

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

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