ReportingCloud: Setting the Culture for Date and Currency Fields
ReportingCloud adds a culture property to the MergeSettings object in the document/merge endpoint. Passing a Language Culture Name such as de-DE or en-US controls how currency symbols, decimal separators, and long date formats render when the reporting engine merges a template.
ReportingCloud provides fields that are localized automatically based on a culture that can be specified. We just introduced a new property in the MergeSettings object to specify the culture for the merge process.
The endpoint document/merge accepts a MergeBody object in the request body data. This object contains a MergeSettings object to adjust several settings for the merge process. The new property culture accepts a string that specifies the culture for the merge process for date and currency values. It must be the Language Culture Name that can be found in this list:
Table of Language Culture Names
For example: For French use "fr-FR", for German "de-DE". Default is English "en-US".
https://api.reporting.cloud/v1/document/merge
MergeSettings
| Key | Value Type | Value description |
|---|---|---|
| culture | String | Optional. Specifies the culture for the merge process for date and currency values. |
Consider a merge field in an invoice that shows the price of a product.
This field should be formatted as a currency field which is done by setting a C to the Numeric Format option:
When merging this field with culture set to "de-DE", you will get a € currency symbol. If set to "en-US", you will get a $ currency symbol. The same is valid for the language of long date field formats:
Happy coding!
Cloud
Are we moving to the cloud? This question is changing from "if" to "when" and "how". Text Control ReportingCloud brings complete reporting functionality to the cloud so all developers can use it, irrespective of the platform or language they're using. Its highly RESTful API can be used to merge Microsoft Word compatible templates with JSON data from all clients including .NET, Javascript, PHP, Node.JS, jQuery, Ruby, Python, Android, Java and iOS.
Related Posts
ReportingCloud Monthly Payment Available
ReportingCloud now supports monthly subscription plans that auto-renew each billing cycle until cancelled. Subscribers manage active plans and view payment invoices through the online store…
Visit Text Control at BASTA! 2017
Text Control exhibits at BASTA! 2017 in Mainz, showcasing the TX Text Control X15 beta with thesaurus, mini toolbar, chart ribbon tab, and background image features. The booth also demonstrates…
More Impressions from DWX Developer Week 2017
Text Control concluded its exhibition at DWX Developer Week 2017 by holding an Xbox One raffle on the final day. The team continued demonstrating reporting products at their Nuremberg booth,…
DWX Developer Week 2017: First Impressions
Text Control exhibited at DWX Developer Week 2017 in Nuremberg, one of Germany's largest developer conferences. The team showcased .NET reporting libraries at their booth, previewed the TX Text…
NDC Oslo 2017 Impressions: Part II
Text Control wrapped up its exhibition at NDC Oslo 2017, a multi-day developer conference at the Oslo Spektrum drawing over 2000 attendees. The team discussed TX Text Control products and services…