Data Source Wizard

• Jan 14, 2019

The Data Source Wizard enables you to configure a data source and retrieve the required data. It 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

  Supports binding to a Microsoft ADO.NET Entity Framework data source.

• Object

  Connects to any data object implementing the IList, IList<T> and IEnumerable<T> interfaces.

• Excel File

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

• JSON

  Connects to JSON-formatted data.

• XPO

  Allows you to bind to XPO data.

• 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 using the Report Wizard, which contains the Data Source Wizard pages.

  

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

  

• Connect the Chart, Pivot Grid and Sparkline report controls to individual data sources. You can invoke the Data Source Wizard using the DataSource property in the control’s smart tag.