Microsoft
70-448 · Question #285
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…
The correct answer is A. Create a query that joins the two tables in the data source by using the JOIN clause. See the full explanation below for the reasoning.
Question
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. T he 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?
Options
- ACreate a query that joins the two tables in the data source by using the JOIN clause.
- BCreate a query that combines the two tables in the data source by using the UNION operator.
- CCreate a query for each table. Group both tables on the column that is used to join the tables.
- DCreate a query for each table. Sort both tables on the column that is used to join the tables.
How the community answered
(38 responses)- A74% (28)
- B13% (5)
- C5% (2)
- D8% (3)
Community Discussion
No community discussion yet for this question.