[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Collapse]Reporting
 [Expand]Product Information
 [Expand]Getting Started with DevExpress Reporting
 [Expand]Creating Popular Reports
 [Collapse]Detailed Guide to DevExpress Reporting
   Introduction to Banded Reports
  [Expand]Providing Data to Reports
  [Expand]Using Report Controls
  [Collapse]Shaping Report Data
   [Expand]Data Filtering
   [Expand]Grouping and Sorting
   [Collapse]Shaping Data using Expression Bindings
     Formatting Data
     Conditionally Changing a Control's Appearance
     Conditionally Changing a Label's Text
     Conditionally Filtering Report Data
     Conditionally Suppressing Controls
     Limiting the Number of Records per Page
     Conditionally Changing a Band's Visibility
     Calculating a Summary
     Calculating an Advanced Summary
     Displaying Row Numbers in a Report, Group or Page
     Counting the Number of Records in a Report or Group
     Counting the Number of Groups in a Report
   [Expand]Shaping Data using Legacy Data Bindings
   [Expand]Using Calculated Fields
   [Expand]Using Report Parameters
   Laying out Dynamic Report Contents
  [Expand]Customizing Appearance
  [Expand]Adding Navigation
  [Expand]Providing Interactivity
  [Expand]Adding Customary Information
  [Expand]Merging Reports
  [Expand]Using Expressions
  [Expand]Storing and Distributing Reports
  [Expand]Reporting API
 [Expand]Visual Studio Report Designer
 [Expand]Creating End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
This documentation page describes implementations made in our v17.2 release cycle. To learn about functionality shipping with v18.1, navigate to our updated help file experience at docs.devexpress.com. Learn More

Formatting 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 Formatting 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:

  • 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:

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.

Is this topic helpful?​​​​​​​