Reporting Services Line Breaks When Exported Not In HTML

In Reportings Serivces 2005..I have a matrix control with a the below expression in one of the cells. The problem is that all these lines are running together when viewed from the report viewer. It does, however, export in the correct format (pdf, excel). This is a little issue but its drving me nuts. I use the same technique on other reports and they display as expected.

Expression:

=Fields!FullName.Value + " (" + Fields!Id.Value.ToString() + ") "
+ chr(10) + chr(13) 
+ "dob " + Format(Fields!DateOfBirth.Value, "MM/dd/yyyy")
+ chr(10) + chr(13) 
+ "Days Enrolled: " + Fields!OriginalDaysEnrolled.Value.ToString()
+ chr(10) + chr(13) 
+ "45 Day: " + Fields!ItemStringFor45Day.Value
+ chr(10) + chr(13) 
+ "90 Day: " + Fields!NinetyDay.Value.ToString()
+ chr(10) + chr(13) 
+ "Current: " + Fields!CurrentDescription.Value
+ chr(10) + chr(13) 
+ "Open Follow Ups: " + Fields!FollowUpCount.Value.ToString()

Web Appearance (IE7, haven't checked others)

Doe, Johnny (123456) dob 03/30/2009 Days Enrolled: 98 45 Day: V H Deca Dev 90 Day: 18 Month Current: 18 Month Open Follow Ups: 1

Exported Appearance (as expected and as Web should look)

Doe, Johnny (123456) dob 03/30/2009 Days Enrolled: 98 45 Day: V H Deca Dev 90 Day: 18 Month Current: 18 Month Open Follow Ups: 1

Answers


I figured this out after checking a report that was working correctly (for the fifth time)...it's simple.

I used:

+ chr(10) + chr(13)  

but I should have used:

+ chr(13) + chr(10)  

I feel silly for overlooking it for so long, but I guess it never popped out at me.


Need Your Help

remove some of the dynamic sidebar in wordpress admin side

php wordpress

i am using evento word press theme.there are default sidebar widget in that theme.i don't want to visible in admin side.

Can't access Class in some other class in c#?

c# asp.net class web-applications

I have one class file JobSeekerBO it's has variable

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.