<< Click to Display Table of Contents >>

 

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.

eurd-win-label-format-string-property

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

eurd-win-format-string-editor-currency

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

eurd-win-expression-editor-formatstring-function

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

eurd-win-format-data-result

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