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).

Warning

Use the approach below if expression bindings are enabled in the Report Designer (the Property Grid provides the Expressions tab ).

See Format Data if expression bindings are not enabled in the Report Designer (the Property Grid does not provide the Expressions tab).

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.

   

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

   

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

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

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