Skip to main content
BuyLog In
.NET Reporting Tools
Search in…
Docs > Detailed Guide to DevExpress Reporting > Shape Report Data > Shape Data (Expression Bindings) > Format Data
A newer version of this page is available. .
All docs
V19.1
Reporting
Product Information
Get Started with DevExpress Reporting
Create Popular Reports
Detailed Guide to DevExpress Reporting
Introduction to Banded Reports
Provide Data to Reports
Use Report Controls
Shape Report Data
Filter Data
Group and Sort
Shape Data (Expression Bindings)
Format Data
Conditionally Change a Control's Appearance
Conditionally Change a Label's Text
Conditionally Filter Report Data
Conditionally Suppress Controls
Limit the Number of Records per Page
Conditionally Change a Band's Visibility
Calculate a Summary
Calculate an Advanced Summary
Calculate a Weighted Average
Display Row Numbers in a Report, Group or Page
Count the Number of Records in a Report or Group
Count the Number of Groups in a Report
Shape Data (Legacy Data Bindings)
Use Calculated Fields
Use Report Parameters
Arrange Dynamic Report Contents
Customize Appearance
Add Navigation
Provide Interactivity
Add Extra Information
Merge Reports
Use Expressions
Store and Distribute Reports
Reporting API
Visual Studio Report Designer
Create End-User Reporting Applications
Reporting in .NET Core 3 (CTP)
API Reference
ASP.NET Core API Reference
Client API Reference
Client API Reference (WebForms & MVC)
Download CHM

Format Data

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

Note

You can use this approach to formatting data when the UserDesignerOptions.DataBindingMode is set to DataBindingMode.Expressions or DataBindingMode.ExpressionsAdvanced.

See Format Data to learn about the legacy approach.

See Data Binding Modes to learn more about the available binding modes.

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.