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

To Print the Text continously in word file Using SSRS 2008 Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 12:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 25, 2014 12:01 AM
Points: 132, Visits: 254
Hi,
I want to print the Address on letter,which exported in Word format using SSRS 2008.


CorrAdd1 CorrAdd2 CorrArea CorrCity CorrState CorrCountry
NULL JAYAFHREE 75 9820077455WORLISEAFACE MUMBAI MAHARASHTRA INDIA

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.
Post #1419830
Posted Thursday, February 14, 2013 10:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
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
Post #1420203
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse