Define regional settings per report using a region property
Important
This content is archived and is not being updated. For the latest documentation, go to What's new and planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.
| Enabled for | Public preview | General availability |
|---|---|---|
| Admins, makers, marketers, or analysts, automatically | 
Mar 1, 2023 |
Apr 1, 2023 |
Business value
Until this release, report formats for date and numerical types depended on client settings for region and couldn't be configured on the report level. This was confusing because sometimes dates and numbers were formatted incorrectly.
Therefore, we added the ability for the tenant admin to set formatting of date and numerical types of a report object on the tenant, and also added the ability for users to override the setting when running a report.
Feature details
In this release, we've added the ability for developers and tenant administrators to set formats for dates and numerical types on report objects on the tenant. If needed, users can change the format when they run a report.
- We've added a new compiler property to give AL access to the property and set a metadata default value in the object. This allows the report developer to define region settings.
- We've added a new per-tenant configuration using a new region field on the Report Settings table. This can override the setting from AL report metadata.
- We've enhanced the Advanced FastTab on the report request page to allow end users to override region setting at report runtime.
See also
FormatRegion Property (docs)