Format Currency in SSRS reports in CRM Online

Key Technologies:  SQL Server Reporting Services

Note:  This article assumes experience on SQL Server Reporting Services for developing reports

For creating SSRS reports with CRM Online please refer the following article
http://www.cloudfronts.com/how-to-create-a-custom-report-in-microsoft-dynamics-crm-online-2/

1. Create a new report in SSRS

2. Add dataset and design a new table

Click to Enlarge

3. Right click on the unit price cell.
Click on text box properties.
On the left hand pane, click Number –> Currency

Click to Enlarge

4. Expression
=Format(Fields!UnitPrice.Value, “C”)
It will give you 2 decimal places with “$” prefixed.
Mathematical calculations are not possible since this function returns a string.
Hence take the base values from CRM for adding the values.

Note:  Fields with ‘base’ as the suffix are the base values in CRM
<attribute name=”totalbudget_base”/>
<attribute name=”actualbudget_base”/>
<attribute name=”totalbudget”/>
<attribute name=”actualbudget”/>

To get More information about CRM consulting services visit – http://www.cloudfronts.com/microsoft-dynamics-crm-consulting.html

Corporate Office Address:
CloudFronts Technologies LLP
T-5 Satyam Business Centre, A Wing.
M.G.Road, Ghatkopar E.
Mumbai 400077, INDIA
Phone: +91 92 2358 3878

USA Partner:
Deven Tech Corporation
50 Glenn Oaks Ct
Old Bridge , NJ 08857