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