Format Data

This document describes how to apply standard .NET formats to data values in a report.

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.

  • Invoke the control's smart tag and click the Format String property's ellipsis button:

    formatting-expressions-label-smart-tag

  • This invokes the Format String Editor where you can specify the required format:

    format-string-editor-currency

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

ExpressionEditor_FormatString

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

format-string-preview-result

TIP

You can use the XRControl.XlsxFormatString property to assign a native Excel format to a control that is used for exporting reports to XLSX.