In the last blog, I told you how to Implement Expressions in Dynamics 365 SSRS Reports using in-build Functions.
Now In this blog, we will tell you how to show Currency Symbol dynamically in Dynamics 365 SSRS Reports.
There are multiple scenarios where you want to calculate currencies based on your needs. But while performing expression steps, it will not display any currency symbol as it will consider it as some mathematical value. You can make it a currency type by using the out-of-the-box method by following the given steps:
Step 1. Go to your Expression box’s textbox properties.
Step 2. Navigate to the Number tab, and select the Currency category.
Step 3. Here, you can manage how the currency will look like, for example, the currency symbol, currency symbol placement, thousands separator, etc.
Step 4. Press OK.
Step 5. You can also define the expression box in any other format such as Percentage, Time, Date, etc., and manage them to display accordingly.
But, this method has its limitation because it will show only that currency symbol which you selected. We needed to display the currency symbol dynamically from the CRM.
To do so, we need our symbol to be fetched from the CRM in real-time while generating the report and show it with an expression box value.
Follow the given steps to achieve this:
1. Add the currency symbol in your fetch.
2. Update your Data Set query also.
3. Now, in your Expression box, you can implement the fetched currency symbol wherever you need using & with a calculated value.
4. Click OK, and it will start displaying the calculated value along with the currency being used in the CRM.