Reporting Services Output to Excel

See more:

reporting-services

Hey Guys, I have a small problem with reporting services. I have a text box with AreaCodes which I trim down when the length of the area codes is greater than 50 when I view the report which is fine and works like a treat. Like so

=Fields!AreaCodes.Value.ToString().Substring(0, iif(CINT(TRIM(Fields!AreaCodes.Value.ToString()).Length) <= 50, CINT(TRIM(Fields!AreaCodes.Value.ToString()).Length), 50)) & IIF(Fields!AreaCodes.Value.ToString().Length >= 50, "...", "")

My problem is when I export to excel I don't want the above forumla to apply instead I want to trim it doen to the max characters allowed in a column by excel which is 255.

Any help is very much apreciated.