This tutorial demonstrates how to bind a report to a hierarchical data source and specify a master-detail relationship between data source queries.
Before creating data-aware reports, you first need to define data models that obtain the necessary data from your data providers. For this tutorial, prepare the Northwind data model providing the Orders and Customers tables as well as the Order Details view.
Open an existing report or create a new one as described in the Create and Customize Reports document to get started with this tutorial.
To obtain a report's dynamic data from an external data source, do the following:
Click the main menu button and select Add SQL Data Source to create a new data source.
On the first page of the invoked SQL Data Source Wizard, select an available data model and click Next to proceed.
On the next page, you can choose which tables, views and/or stored procedures to add to the data source.
Select the Order Details view. Create a custom query by clicking the plus button for the Queries category to display information from two different tables at the same hierarchical level.
In the invoked Query Builder, add the Orders and Customers data tables to a query and join them based on a key column.
Give the Orders name to the created query and click OK to close the Query Builder.
Click Next on the wizard page to proceed.
The next wizard page allows you to configure parameters for a custom query. Click Next to skip this step.
On the following wizard page, define master-detail relationships between queries by specifying their corresponding key fields. Click the plus button next to the master query, choose the detail query to add a new relationship and specify the relationship condition as shown in the following image:
The Field List displays the hierarchy of the data source after a report has been connected to data.
A report's Data Source and Data Member properties specify the report's data binding.