Forum Discussion
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....
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.
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.