Home > Report Designer > The Basics > Change Value Formatting of Report Elements

Change Value Formatting of Report Elements

To apply value formatting for a controls's content (e.g. date format,  time format, currency format, currency digit count, or date-time format), locate this control, click its Smart Tags , and in the invoked actions list, click the ellipsis button for the Format String entry.

Please read this section on the possible format strings. Printing Format

Then, in the invoked format string editor, choose one of the predefined formatting styles, or specify a custom one.

To quit the dialog and apply the changes, click OK.

Similarly, when the mail-merge is employed for a control's dynamic content, to apply a value formatting to an embedded data field, select it in the in-place editor, and click the control's smart tag. Then, in the invoked actions list, specify the required format.

Note that when a summary function is being applied to a control's dynamic content, value formatting is applied separately, via the Summary Editor, as described at Add Totals to a Report

Independently from the general (or, summary) value formatting, you can specify a native XLSX format string, which is to be preserved when the report is being exported to XLSX. This can be done via a control's Xlsx Format String property.

See also