Hello, Pamela,

This feature is implemented in standalone TBM, but not in Lite. However, task could be solved via Scripts tab in the report designer. Would you like me to explain how to achieve this?

Hi Eugene, 

Yes please! I've spent about 12 hours today fooling around with Lite. I can change some things, but others just won't happen (for example, for some reason every zero added to a percentage equals three zeroes. I've managed to fiddle it so that it calculates the 10% tax I'm looking for, but in the quote it shows it as 1%). Also, can you confirm that the standalone version is no longer available?

Thank you!

Ok, Pamela, let's split it into 2 parts.

1. Date and number formatting rules, which depends on language settings. Language is determined by Studio language, and that formatting is applied to all numbers and dates.

Say, for dates, format 'D' (short date) could look like:

Thursday, 12 December 2019 for en-us
Donnerstag, 12. Dezember 2019 for de-de

Script tab allows to temporary set current culture for a report (invoice). Do the following:

1. Click outside paper in the report designer to select whole report
2. Switch to the Scripts tab and add this line in the beginning:
   private System.Globalization.CultureInfo originalCulture = null;
3. Expand right drop down list and select Before print:
   
4. Write this in a created function:
   originalCulture = System.Threading.Thread.CurrentThread.CurrentCulture;
   System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de");
   Replace language code here with language code you need.
5. Add this code for After print event:
   System.Threading.Thread.CurrentThread.CurrentCulture= originalCulture;

Final result looks like this:

2. Problem with percentage. You just need to apply correct formatting. If percentage is entered as absolute value (1..100, not as 0.01-1), then you can't apply Percentage formatting to it. Instead apply this format for a percentage value: {0:n2}%

0:n2 in curly brackets means number value format with two decimals, while '%' is a simple character added at the end.

Ok, Pamela, let's split it into 2 parts.

1. Date and number formatting rules, which depends on language settings. Language is determined by Studio language, and that formatting is applied to all numbers and dates.

Say, for dates, format 'D' (short date) could look like:

Thursday, 12 December 2019 for en-us
Donnerstag, 12. Dezember 2019 for de-de

Script tab allows to temporary set current culture for a report (invoice). Do the following:

1. Click outside paper in the report designer to select whole report
2. Switch to the Scripts tab and add this line in the beginning:
   private System.Globalization.CultureInfo originalCulture = null;
3. Expand right drop down list and select Before print:
   
4. Write this in a created function:
   originalCulture = System.Threading.Thread.CurrentThread.CurrentCulture;
   System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("de-de");
   Replace language code here with language code you need.
5. Add this code for After print event:
   System.Threading.Thread.CurrentThread.CurrentCulture= originalCulture;

Final result looks like this:

2. Problem with percentage. You just need to apply correct formatting. If percentage is entered as absolute value (1..100, not as 0.01-1), then you can't apply Percentage formatting to it. Instead apply this format for a percentage value: {0:n2}%

0:n2 in curly brackets means number value format with two decimals, while '%' is a simple character added at the end.