Bind Report to Non-Dabacon Data

Binds a report to a non-Dabacon data source. The source can be a database, an entity framework, an object, an excel file, a JSON or an XPO. The example describes how to bind a database to a report.

1. On the Report Designer tab, click at the top-left of the report to display the Report Tasks window.

   

2. Select Add New DataSource from the Data Source drop-down menu to display the Data Source Wizard.

   

3. Click Database and click Next.

   

4. Select, No, I’d like to specify the connection parameters myself and click Next.

   

5. Select a data provider (the database) from the Provider drop-down list. The fields below the Provider field are specific to the selected data provider. Populate the fields with the required data to connect a database.

6. Click Next.

   

7. Select the required check boxes to define the tables obtained from the database and click Finish.

   Note:
   If several tables are chosen, Reporting creates a data relationship between them (if possible), which is used to create parent-detail reports.

The report is bound to the data source, the Data Source and Data Member fields are populated on the Report Tasks window.

After binding a report to a data source, each data-aware report control must be bound to a data field from that source. Refert to Display Values from a Database (Bind Report Controls to Data) for further information.