Data Formats

Applies to: Kyvos Reporting

In business reports, data often carries contextual meaning—such as names, percentages, dates, or monetary values. Kyvos Reporting provides preset formatting options that let you represent this data in a meaningful, localized, and visually appropriate way.

Data formatting is applied to a field during report generation. Format properties are saved as format codes (also known as format strings), which define how the data should be displayed.

You can use the Format dialog box (available on the Analytical Object page) to apply preset formats. When a format is selected, the corresponding format code is displayed in the Format text box, along with a sample output.

Preset Data Formats

Kyvos Reporting offers the following preset formatting categories:

General

Use this option when data does not require specific formatting.

• Input Format: Accepts data in any format.

• Output Format: Displays the value as received from the database.

Number

Configure how numeric values should appear.

• Decimal Places: Number of digits to display after the decimal point.
  Example:

  • 12 → 12.00 (if set to 2)

  • 12.345 → 12.34

• Use 1000 Separator: Adds a comma after every thousand.
  Example: 1000000 → 1,000,000

• Negative Numbers:
  Choose how to represent negative values:

  • Enclosed in brackets: (874.98)

  • With a negative sign: -874.98

Currency

Use this format for monetary values such as sales, salary, or profit.

• In addition to number formatting, select a currency symbol from the Currency dropdown.

• A preview of the formatted value and the corresponding format code is shown.

Date

Choose from various preset formats to display dates.

Examples:

• United States format: 12/27/2025 (MM/dd/yyyy)

• India format: 27/12/2025 (dd/MM/yyyy)

• Year only: 2025

To learn more, refer to the Date and Time Format Codes section.

Time

Select how the time values should appear.

Example formats:

• 10:30 AM

• 22:30:00

A sample is shown when a format is selected.

Percentage

Use this format to display values as percentages.

• Decimal Places: Define how many digits to show after the decimal point.
  Example:

  • 0.56 → 56% (if decimal places = 0)

  • 0.5678 → 56.78% (if decimal places = 2)

Scientific

Use this format to display values in scientific (exponential) notation.

Example:

• 123.456 → 1.23456E+2

Text

Specify how text should be displayed:

• None: Keeps the original casing.

• Upper Case: Converts text to uppercase.

• Lower Case: Converts text to lowercase.

Apply Locale Default Format

While formatting Number, Currency, Date, and Time fields, you can choose to apply the locale-specific default format:

• Check Apply Locale Default to use formats based on the active locale at the time of report generation.

• Uncheck to apply a custom format.