You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains summary information in two sections named Agencies and States. The Agency summary section contains two matrices and the State summary section contains a table. The information about each section is grouped together.
You need to design the report to meet the following requirements:
-When the report is exported to a Microsoft Excel spreadsheet, each summary section is rendered to a separate tab.
-The structure in each section is retained.
What should you do?
A.
Select the Keep together on one page option on all report items.
B.
Select a line component between the report items for the Agency and State summary sections.
C.
Select all the report items for each section in a list report item and enable the Add A Page Break Before option on the list report item.
D.
Select all the report items for each section in a rectangle report item and enable the Add A Page Break Before option on the rectangle report item.
Explanation:
Tip: "spreadsheet … structure in each section is retained" = "rectangle"http://technet.microsoft.com/en-us/library/ms155915(SQL.100).aspx
Add a rectangle to your report when you want a graphical element to separate areas of the report, emphasize areas of a report, or provide a background for one or more report items. Rectangles are also used as containers to help control the way data regions render in a report. You can customize the appearance of a rectangle by editing rectangle properties such as the background and border colors.