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 not enabled in the Report Designer (the Property Grid does not provide the Expressions tab ).

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

After you bound your report to data and specified a bound data field in a report control's Data Binding 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.

   

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.