Skip to main content

Data Source Wizard

  • 2 minutes to read

The Data Source Wizard allows you to configure a data source and retrieve its data.

The first page allows you to create or select an existing data connection.

Select existing data connection

If you chose a new connection, the next page allows you to select the data connection type.

Select data connection type

You can select a provider and click the “star” icon to pin frequently used database providers as favorites. Favorite providers appear at the top of the list for quick access:

Pin favorite database providers

Use the search panel to filter the connection type list:

Search connection types

Use the Data Source Wizard

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.

    Create data-bound report

  • Bind an existing report or its Detail Report band to data. To invoke this Wizard, click Add Data Source on the Ribbon‘s Home page.

    Add Data Source ribbon button

    Alternatively, click the report’s smart tag, expand the DataSource property’s drop-down menu and click Add Report Data Source.

    Add data source via smart tag

  • Connect the Chart, Cross Tab and Sparkline report controls to individual data sources.

    You can invoke the Data Source Wizard using the Add Data Source command on the Chart | Design contextual page.

    Chart Add Data Source button

    You can invoke the Data Source Wizard using the DataSource property in the chart’s smart tag.

    Chart DataSource property menu

Supported Data Source Types

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

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

  • Object Binding

    Connects to a data object.

  • Excel File

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

  • JSON

    Connects to JSON-formatted data.

  • MongoDB

    Connects to a MongoDB instance.

  • XPO

    Allows you to bind to XPO data.

  • No Data

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