9/19/2014

#SSRS Export NAV to Excel Currency

Ran into a bug when exporting SQL Server Reporting Services to Excel.  The field which contained a Currency in SSRS exported to Excel as a Text.

So one option was to multiply the SSRS formula by 1.000

=Fields!Retailer_Amount.Value* 1.000

By doing this, the field successfully converts to a number in Excel.  However, there is no currency symbol $.

So in order to keep the Currency symbol $, you have to set the property called "Format" to "C":



And this solved the problem.  Hope that helps.
 






Babalon