Stimulsoft Business Intelligence System | Forum

Following format function gives a , as result for the thousand separator in English Language. Example:
Actual situation: 1,017.50 €
Target situation: 1.017,50 €

I can´t use the standard functionalities of the Stimulsoft Report Designer, because the decimal places will be export in serveral variants from my ERP system.
I have to use the format functions. Do you have an overview over all possibilites (help page) ? Thank you for your support.

Hello,

Please check
Documentation - https://www.stimulsoft.com/en/documentation
Videos - http://www.youtube.com/user/StimulsoftVideos
Samples - https://www.stimulsoft.com/en/samples

Thank you.

Ok, thank you for the links. But that doesn´t solve my problem. Can you give me an overview for the Format functions?
What´s the right format function for this use case?

Hello,

You can find information about the format function at the following link:
https://learn.microsoft.com/en-us/dotne ... ew=net-7.0
https://learn.microsoft.com/en-us/dotne ... at-strings

Thank you.

I don´t find a function which solves my problem: I tried several formulas.
Target situation: 1.017,50 €

Target:
no change if the culture will be changed from DE to US for example.
Thousand separator and decimal separator won´t be changed.

Can you help me ? Thank you.

Hello,

Please try to use:
{String.Format(System.Globalization.CultureInfo.CreateSpecificCulture("en-US"),"{0:N2}",Variable1)}
or
{Replace(Format("{0:N2}",Variable1), ",", ".")}

Thank you.

The result with {Replace(Format("{0:N2}",Variable1), ",", ".")} is 48.220.00.
My Target is to show 48.220,00

{String.Format(System.Globalization.CultureInfo.CreateSpecificCulture("en-US"),"{0:N2}",Variable1)} gives an error message. (see screenshot1 in attachment.)

Do you have another suggestions?

Hello,

There are no other standard ways to change it.
As a way, you can add your own function in which set format as you need.

Thank you.

Hello @Lech Kulikowski,
which function is that?
I tried several functions. The thousand separator will be changed in every case. That has to be possible in my opinion. I don´t know what else can i try.

Hello,

> which function is that?

We mean, you can implement your OWN function and add to the dictionary, which will format your values as you need.

Thank you.