Hi all,
I have a tricky behavior here. I have a column in my report which contains alphanumeric codes. When I have a code like 17E001 and I export the report to Excel, excel kindly shows that alphanumeric code to 1+E7 and the value of the column is changed to 1700 which is defintly not what I want.
So I was wondering if there is any way to force the column types when exporting from SSRS?
Sbastien.
By the way if there is a way to force all columns to be formated as Text that will do for me as the excel reports are only used to process data using SSIS.
No comments:
Post a Comment