You create a SQL Server 2008 Reporting Services (SSRS) report. You plan to create a list
of customers by using a List control. For each customer in the List control, you plan to
include a table that contains the orders for that customer. The customer data is stored in the
Customers table in the data source, and the order data is stored in the Orders table. You
need to define the required dataset or datasets for this report. What should you do?
A.
Create a query that joins the two tables in the data source by using the JOIN clause. Add
the query as a single data set to the report.
B.
Create a query that combines the two tables in the data source by using the UNION
operator.
Add the query as a single data set to the report.
C.
Create a query for each table. Group both tables on the column that is used to join the
tables.
Add both queries as separate data sets to the report.
D.
Create a query for each table. Sort both tables on the column that is used to join the
tables.
Add both queries as separate data sets to the report.