To Print the Text continously in word file Using SSRS 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » To Print the Text continously in word file...

To Print the Text continously in word file Using SSRS 2008

Rate Topic

Display Mode

Topic Options

Author

Message

avdhut.k

Posted Thursday, February 14, 2013 12:03 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 4:48 AM
Points: 56, Visits: 136

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

Daniel Bowlin

Posted Thursday, February 14, 2013 10:43 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:53 AM
Points: 2,672, Visits: 2,416

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 »

Permissions