Friday, March 30, 2012

Problem in exporting Report with multiline textbox to Excel

Hi,

I am facing a problem while exporting reports to Excel.
My report contains a multilined textbox - which is displayed correctly in Report Design.

Following is code of report Statistics contents to be displayed in a textbox: ="Report Statistics " & vbcrlf & "Date : " & Format(Globals!ExecutionTime, "MMM dd yyyy tt”) & vbcrlf & "By : " & User!UserID

Problem Description: In Excel - one extra line is added between each line

Sample output of report exported in Ms Excel 2003:

Report Statistics

Date : Jun 12 2006

Time : 6:53:23 PM

By : COMPANY\EMP ID

Correct Output Required:

Report Statistics

Date : Jun 12 2006

Time : 6:53:23 PM

By : SERWIZSOL\P97006

Configuration:
Microsoft SQL Server 2000 SP3
Microsoft SQL Reporting Services 2000 SP2

If some one is facing similar problem or knows the solution, please let me know.

Thanks in Advance.
Regards,
Abhijeet

Hi Abhijeet,

I tried your expression ="Report Statistics " & vbcrlf & "Date : " & Format(Globals!ExecutionTime,"MMM dd yyyy tt") & vbcrlf & "By : " & User!UserID

Everything worked fine for me. I added a text box and set the expression to above text and it works perfectly. Was there anything else you were doing?

No comments:

Post a Comment