Thousand separator in a Web Report Designer

4 Answers 346 Views
Report Designer - Web Report Wizard Table
Mateusz
Top achievements
Rank 1
Iron
Mateusz asked on 12 Apr 2022, 01:01 PM
Hello Where to set the thousand separator in a Web Report Designer?

4 Answers, 1 is accepted

Sort by
1
Accepted
Mateusz
Top achievements
Rank 1
Iron
answered on 29 Apr 2022, 11:30 AM | edited on 29 Apr 2022, 11:31 AM

 

I found solution:

By default, Telerik Reporting uses the system locale that determines the format

currencies, dates and times, and numbers (thousands and decimal separators). When there is a need

you can use the function to generate reports for non-system locale

FormatWithCulture. This function has the following syntax:

FormatWithCulture(cultureName, format, args)

 

cultureName: RFC 1766 locale symbol, eg "en-PL"

format: specifies the format of the value indicated as the third argument; has a form

“{0: formatSymbol}” eg “{0: D}”; the list of format symbols can be found on the website

https://github.com/telerik/kendo-intl/blob/develop/docs/date-formatting/index.md; including

argument, you can also add any text before or after the formatted expression

args: references to the data source fields from which the values ​​are to be formatted, in

Fields. FieldName

0
Todor
Telerik team
answered on 15 Apr 2022, 07:23 AM

Hello Mateusz,

Can you elaborate on the requirement? Would you like to set a thousand separator for the final report documents exported with the preview functionality of the web designer, or you would like to change the separator when editing the report properties in the designer? I'm afraid that currently, both can't be configured.

For the final report document, the thousand separator is taken from the culture on the server.

There is also an option for providing a thousand separator when configuring a CsvDataSource data format.

Regards,
Todor
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
0
Mateusz
Top achievements
Rank 1
Iron
answered on 21 Apr 2022, 06:29 AM
I would like to set a separator for the displayed report.
0
Dimitar
Telerik team
answered on 25 Apr 2022, 02:37 PM

Hi Mateusz,

The separator that will be used for the thousands when displaying numeric values depends on the culture of that report or of the report itself.

To have the data display with a different separator, you can change the Report.Culture Property to a culture that displays numeric values with the desired separator.

For more information, please have a look at the Report Globalization article.

Regards,
Dimitar
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Report Designer - Web Report Wizard Table
Asked by
Mateusz
Top achievements
Rank 1
Iron
Answers by
Mateusz
Top achievements
Rank 1
Iron
Todor
Telerik team
Dimitar
Telerik team
Share this question
or