All Collections
Custom Reports and Charts
Report Columns
Number Formatting in Reports (Format Strings)
Number Formatting in Reports (Format Strings)

Present your numbers in the right formats

Mick Devine avatar
Written by Mick Devine
Updated over a week ago

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


Example formatted numbers:

  • 12,345

  • (12,345)

  • 0

Display 2 Decimal Places


Example formatted numbers:

  • 12,345.67

  • (12,345.67)

  • 0.00

Display as Thousands


Example formatted numbers:

  • 12

  • (12)

  • 0

Display as Thousands with 1 Decimal Place

Did this answer your question?