Forum Discussion

M_nwadibia's avatar
M_nwadibia
Icon for Resolver III rankResolver III
3 years ago

SSRS Report not maintaining same format when exported to Excel

Hello , I have a Oracle SQL query Select To_NUMBER( AG.SBA_REP, '99,999.99') FROM TABLE A. I used the SQL in SSRS and formatted the cell with SSRS expression FORMAT(CDec(Fields!Total_RLHAP_Award....
40
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

This is expected since the FORMAT() function returns a string. If you want to maintain the data type you should use the Format property on the textbox in your table instead of using the FORMAT function in an expression on the Value.

M_nwadibia's avatar
M_nwadibia
Icon for Resolver III rankResolver III
3 years ago

I have tried this and it didnt work. see the screen shot. When I exported it, the excel defaulted to general intead of staying as number.