<div>
Exccellent - thank you for your help
</div>


<div>
<div class="content wysiwyg-content">
Thank you for looking at my question.<br />
<br />
We have a report on SRSS that lists transactions in a range off currencies, GBP, USD, AED.<br />
<br />
The formatting of the report cell containing the currency value is handled using an expression:<br />
<br />
=Fields!CurrencySymbol.Val<wbr />ue &amp;&nbsp;&quot;#,##0.00&quot;<br />
<br />
where the column CurrencySymbol is a char(3) field.<br />
<br />
On the report, when previewed on the report server or viewed via a web browser the currency values all are preceded by the &nbsp;relevant currency symbol eg £150.00, $99.00, AED500.00 but when I export the report to Excel I get an error messsage about some number fields losing their formats - specifically the AED values lose their prefix, all other values are OK.<br />
<br />
I tried exporting the report as a csv file and the formatting remains as it should.<br />
<br />
How can I retain the formatting for all values?
</div>
</div>


Thank you for looking at my question.

We have a report on SRSS that lists transactions in a range off currencies, GBP, USD, AED.

The formatting of the report cell containing the currency value is handled using an expression:

=Fields!CurrencySymbol.Value & "#,##0.00"

where the column CurrencySymbol is a char(3) field.

On the report, when previewed on the report server or viewed via a web browser the currency values all are preceded by the  relevant currency symbol eg £150.00, $99.00, AED500.00 but when I export the report to Excel I get an error messsage about some number fields losing their formats - specifically the AED values lose their prefix, all other values are OK.

I tried exporting the report as a csv file and the formatting remains as it should.

How can I retain the formatting for all values?

SRSS Report Loses some number formats when exporting to MS Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.