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 Designer provides the Expressions panel).
See Format Data if expression bindings are not enabled in the Report Designer (the Designer does not provide the Expressions panel).
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.
Expand the Actions category and click the Text Format String property's ellipsis button.
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.