I Have a report, in SQL Reporting servies. THE report has a field where the value shows up as an integer ie 0. However, when the report is exported to excel, the field value shows up as a decimal ie 0.4.
How do i keep the number to show as an integer only ie 0, when exported to excel.
Are you specifying a format code to only display the integer, or is the underlying value actually an integer? If it is the former, what is the format code you are using?
Ian|||Yes, I am specifying a format code of F0 on that textbox for that field.|||Tarana,
This seems like a bug; however, the good news is there is a workaround: try the following format code.
##0
Ian|||Thanks a bunch Ian- that worked very well.
No comments:
Post a Comment