[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
 [Expand]Product Information
 [Expand]Get Started with DevExpress Reporting
 [Expand]Create Popular Reports
 [Expand]Detailed Guide to DevExpress Reporting
 [Collapse]Visual Studio Report Designer
  [Expand]Dock Panels and Designer Options
  [Expand]Report Wizard
  [Collapse]Data Source Wizard
   [Expand]Connect to a Database
   [Expand]Connect to an Entity Framework Data Source
   [Expand]Connect to an Object Data Source
   [Expand]Connect to an Excel Data Source
   [Expand]Connect to a JSON Data Source
   [Expand]Connect to an XPO Data Source
   [Expand]Connect to a Federated Data Source
    No Data
   Query Builder
 [Expand]Create End-User Reporting Applications
 [Expand]API Reference
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Data Source Wizard

The Data Source Wizard enables you to configure a data source and retrieve its data. The wizard supports the following data source types:

  • Database

    Obtains data from all major data providers (Microsoft SQL Server, XML data, Microsoft Access, Oracle, etc.).

  • Entity Framework

    Binds to a Microsoft ADO.NET Entity Framework data source.

  • Object

    Connects to any data object that implements the IList, IList<T> or IEnumerable<T> interface.

  • Excel File

    Obtains data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.

  • JSON

    Connects to JSON-formatted data.

  • XPO

    Binds to XPO data.

  • Data Federation

    Retrieves data from multiple data sources.

  • No Data

    Allows you design a report that is not bound to a data source.

The Data Source Wizard allows you to do the following:

  • Add a new data-bound report to your application. To do this, use the Report Wizard, which contains the Data Source Wizard pages.

  • Bind an existing report or its Detail Report band to data. To invoke the Data Source Wizard, click the report's smart tag, expand the XtraReportBase.DataSource property's drop-down menu and click Add Report Data Source.

  • Connect the Chart, Pivot Grid and Sparkline report controls to individual data sources. To invoke the Data Source Wizard, click the control's smart tag, expand the DataSource property's drop-down menu and click Add Report Data Source.

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