February 14, 2013 at 12:03 am
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.
February 14, 2013 at 10:43 am
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