Sunday, February 19, 2012

different character when exported to excel..HELP

Hi everyone!

Good day...I have this report which has records with tabs/spaces on it, after I export it to excel the tabs/spaces are converted to squares/blocks. I would like to know if there is a work around on this without changing the record itself..I need to eliminate the squares on some of the record items... please help... Thanks a lot..

JK

For all expressions you can modify the value in the report inself.

By default an expression will be like: =Fields!datavalue1.Value
Now you can replace all your tabs by adding .Replace(vbTab, " ") to the expression.

|||

hi,

thanks for your help but i dnt know where to add the statement to replace tabs... would it be

=Fields!datavalue.Value & Replace(vbTab, " " )

if wrong kindly correct it please thank you very much...

JK

|||

All expressions in Reporting Service are VB.NET code, so the syntax would be:
=Fields!datavalue.Value.Replace(vbTab, " ")

For more information: http://msdn2.microsoft.com/en-us/library/system.string.replace.aspx

|||Thanks Jan Peter to your help..ill try it if it works...god bless..

No comments:

Post a Comment