Format Data

<< Click to Display Table of Contents >>

Navigation:  User Interface (UI) Elements > Report Designer > Group and Sort Data >

Format Data

 

Format Data

This document demonstrates how to specify value formatting for report elements (for instance, format numeric values as a currency or apply a percent format).

After you bound your report to data and specified a bound data field in a report control's Expression property, you can format data values in a report.

1.Invoke the control's smart tag and click the Format String property's ellipsis button.

Formatdata1

2.This invokes the Format String Editor where you can specify the required format.

Formatdata2

Alternatively, you can use the FormatString function within the expression you specified for the report control.

Formatdata3

When switching to Print Preview, you can view the report control displaying values with the specified format.

Formatdata4

You can use the control's Xlsx Format String property to assign a native Excel format that is used for exporting reports to XLSX.