powerobjects: Formatting SSRS Report Textboxes Using the Language Property and D365 Data

[Blog bot]

Источник: https://www.powerobjects.com/2018/08...mics-365-data/
==============


Do you have users in different countries who view a SQL Server Reporting Services (SSRS) report? Depending on where these users and customers are located, they may have different needs for viewing numbers. The good news is that we can do this in Microsoft Dynamics 365 with one report using the Language property.

Note: for more information about SSRS reports within Dynamics CRM, please see The CRM Book here.

In the following scenario, a sales user in Dynamics 365 creates a Quote from a Contact record. Once they are finished editing the Quote, they want to provide a PDF document to the customer and have the numbers on the Quote PDF formatted according to the sales user’s country/office.

For example, a sales user who works out of the France office wants to provide a Quote PDF and have the Quote Total formatted according to French standards, and a sales user who works out of the American office would like the Quote Total formatted according to American standards.

1. First, we need to ensure that we have a dataset on the report that pulls in data from the Quote record in Dynamics 365. Dataset queries can be created using SQL or Fetch XML.

2. Second, we need to ensure a textbox on the report is created to store the Quote Total. This textbox should reference the Quote Total field from the Quote record in Dynamics 365.

3. Next, we will open the Textbox properties for the Quote Total Textbox and set the Number Format to “n2” to display two decimal places after the number. Then we’ll open the Language property and set an expression. This expression should look something like:

=IIF(First(Fields!po_salesorganization.value, “DataSetName”) = “American Sales Office”, “en-US”, IIF(First(Fields!po_salesorganization.value, “DataSetName”) = “France Sales Office”, “fr-FR”, “es-ES”))

The above expression sets the Language of the Textbox to American English (en-US) if the Sales Office (po_salesorganization) on the Quote is “American Sales Office” or if it is “France Sales Office”, the Language will be set to France French (fr-FR). For every other sales office, it will be set to Span Spanish.

And there you go! Number formatted reports based on Dynamics 365 data.

How it would look in the USA:

TOTAL6,431.45

How it would look in Spain:

TOTAL 12.333,00
How it would look in France:

TOTAL 4 998,00
For more Dynamics 365 how-tos and tips, be sure to subscribe to our blog!



Источник: https://www.powerobjects.com/2018/08...mics-365-data/