ActiveReports 16 .NET Edition
ActiveReports 16 User Guide / Concepts / Page Report/RDL Report Concepts / Data Binding
In This Topic
    Data Binding
    In This Topic

    The data binding process involves setting up the data connection and associating the data with the report. In a Page report or an RDL, it is typically a two-step process.

    The first step requires you to set up a connection to the data source by configuring the data source connection properties. Next, you need to add a dataset to fetch the data you want to show in the report.

    This section discusses the data binding using the ActiveReports Designer. For information on run-time binding, please see Bind a Page Report to a Data Source at Run Time topic.

    Data Source Wizard

    With this feature, the Report Data Source configuration dialog is invoked when a new report is created. The user can choose to show or hide this dialog when creating a new report in Standalone designer or adding a new report in VS Integrated Designer. On successful connection, Data Set dialog is also launched.

    Following are the different ways in which you can control the autorun behavior of the Report Data Source dialog in reports.

    Method 1: Using the Launch Data Source Wizard option in the New Report dialog box of the Standalone designer. Keep the option selected, or unselect the choice to launch the data source wizard. By default, this option is checked. 
    Add icon in the Report Explorer

    Method 2: Using the GrapeCity.ActiveReports.config file to control the behavior. See this for more information. Set the value for the LaunchDataSourceWizard key to 'false' to disable the default behavior of the Report Data Source dialog to appear on creating a new report.

    GrapeCity.ActiveReports.config
    Copy Code
    </appSettings>
      <add key="LaunchDataSourceWizard" value="false"/>
    </appSettings>
    

    Method 3: Using the API. See this for more information.

    Data Sources

    In ActiveReports Designer, you setup the data source connection in the Report Data Source dialog. The Report Data Source dialog is where you select the type of data source to use, provide a connection string, and choose other options for your data source. You can also decide to use a shared data source, use a single transaction, and select a method for handling credentials. Once you add a data source, it appears in the Report Explorer under the Data Sources node. You can also add multiple data sources in a single report. See Connect to a Data Source for more information.

    Datasets

    A dataset fetches data from the data source to display in a report. The DataSet dialog is where you provide a command type and query string and choose other options for your dataset.

    You can also control the timeout period and other data options, and add fields, parameters, and filters to fetch the data you need. Once you have added a dataset, the dataset fields appear under the Data Source node in the Report Explorer. You can add multiple datasets for a data source. For example, you can use multiple data sets in a report when nesting data regions such as Tablix, List, Chart, BandedList, Table, and Sparkline. See Add Dataset for more information.

    Furthermore, ActiveReports provides a Visual Query Designer for Microsoft SQL Client and Microsoft OLEDB providers and Query Designers for JSON and XML providers, which allow the users to build the dataset queries easily.

    Supported Data Providers

    The supported data providers for designing Page/RDL reports are:

     

    See Also

    How To

    Page Report/RDL Report Concepts

    Report Page Concepts