Log In
[Expand]Welcome to DevExpress .NET Documentation
[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]Document Server
 [Expand]Product Information
 [Collapse]Creating Reports in Visual Studio
  [Expand]Adding a Report to Your .NET Application
  [Expand]Getting Started with DevExpress Reporting
  [Collapse]Detailed Guide to DevExpress Reporting
   [Expand]Storing and Distributing Reports
   [Expand]Providing Data to Reports
   [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
   [Expand]Report Navigation, Interactivity and Appearance
   [Expand]Reporting API
  [Expand]Detailed Guide to Visual Studio Report Designer
 [Expand]Creating End-User Reporting Applications
 [Expand]API Reference
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Formatting Data

This document describes how to apply standard .NET formats to data values report controls display.


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 to solving this task.

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 the data value this control displays.

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

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


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

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