Data Source Wizard

• May 14, 2019

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.

You can invoke the Data Source Wizard in the following ways:

• Click the report’s smart tag, expand the XtraReportBase.DataSource property’s drop-down menu and click Add New to bind an existing report or its Detail Report band to data.

  

  Alternatively, click the Add Data Source button in the toolbar.

  

• Click the control’s smart tag, expand the XtraReportBase.DataSource property’s drop-down menu and click Add New to connect the Chart, Pivot Grid and Sparkline report controls to individual data sources.

  

You can invoke the Report Wizard to add a new data-bound report to your application. The Report Wizard contains the Data Source Wizard pages.