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