This tutorial demonstrates how to bind a report to a hierarchical data source and specify a master-detail relationship between data source queries.
Before you create data-aware reports, define data models that obtain the data from your data providers. For this tutorial, prepare the Northwind data model that provides 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, choose which tables, views and/or stored procedures to add to the data source.
Select the Order Details view. Click the Queries category's plus button to create a custom query in the Query Builder and display information from two different tables at the same hierarchical level.
In the invoked Query Builder, add the Orders and Customers data tables to the 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.
If the Custom SQL Query Execution Mode option is set to Execute SELECT Statements Only or Execute All in the General Settings window, you can write a custom SQL query instead of constructing it in the Query Builder. See Write a Custom SQL Query for more information.
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, specify key fields to define master-detail relationships between queries. 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:
Click Finish to complete the wizard.
The Field List displays the data source hierarchy after you connect a report to data.
A report's Data Source and Data Member properties specify the report's data binding.