When creating custom reports in the report designer, the number formatting of a field is handled using a format string. The format string for example will determine if a number is displayed as a percentage, how many decimal places will be shown and what format to use for negatives.

The Calxa report designer utilises the .NET Numeric Format Strings and while this support note will provide a basic understanding of format strings and provide some examples, for a more detailed explanation you can also refer to the Microsoft Documentation - Standard Numeric Format Strings and Custom Numeric Format Strings.

Edit Format String

First you must have Created a Custom Template and then for each column in the report select the table cell and edit the Text Format String property a shown below.

Text Format String

Format String Examples

Decimal Numbers

Display 0 Decimal Places

{0:#,#;(#,#);0}Example formatted numbers: 
  • 12,345

  • (12,345)

  • 0

Display 2 Decimal Places

{0:#,#.00;(#,#.00);0.00}Example formatted numbers:
  • 12,345.67

  • (12,345.67)

  • 0.00

Display as Thousands

{0:#,0,;(#,0,);0}Example formatted numbers:
  • 12

  • (12)

  • 0

Display as Thousands with 1 Decimal Place

{0:#,0,.0;(#,0,.0);0}
Did this answer your question?