The requested page is not available for the requested platform. You are viewing the content for Default platform.

Data Source Wizard

  • 2 min to read

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.

    xtrareport-wizard-databaound-report-01

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

    how-to-ef-datasource01

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

    HowTo - AddChartDataSource