You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support. Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you.
According to his requirement, you have to use SQL Server 2008 Reporting Services (SSRS) to design a report.
Each time the users render the report, detail information is displayed.
According to the requirement of the CIO, Summary information must be displayed when the report is initially rendered.
Besides this, only when the users click a column header, detail information is displayed. You must satisfy these requirements.
So what action should be performed?
A.
You should set the hidden property to False. Then you should set the Visibility can be toggled by another report item property to True
B.
You should set the hidden property to True on the column that contains detail information.
Then set the Visibility can be toggled by another report item property to True.
C.
You should set the hidden property to False on the column that contains detail information.
Then set the Visibility can be toggled by another report item property to False.
D.
You should set the hidden property to True on the column that contains detail information.
Then set the Visibility can be toggled by another report item property to False.