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?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee.
Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee.
You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will contain a total of 100 different reports created by using Report Definition Language (RDL).
Each report must meet the following requirements:
-Display a common set of calculations based on a parameter value.
-Provide a method for setting values on a report URL or in a subscription definition that are not exposed to a user.
-The business rules for all reports that determine the calculations change frequently.

You need to design a solution that meets the requirements. You need to perform this action by using the minimum amount of development and maintenance effort.
What should you do?

You are creating a SQL Server 2008 Reporting Services (SSRS) solution for a company that has offices in different countries. The company has a data server for each country. Sales data for each country is persisted in the respective data server for the country. Report developers have only Read access to all data servers. All data servers have the same schema for the database.
You design an SSRS solution to view sales data.
You need to ensure that users are able to easily switch between sales data for different countries.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) report. The report must display the list of orders placed through the Internet.
You need to ensure that the following requirements are met:
-The amount of time required for processing the report is minimal.
-The report contains the most recent data at the end of each business day.
-A report is available for any of the last seven days.

Which type of report should you create?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a sales report by using SQL Server 2008 Reporting Services (SSRS). The report is used by managers in a specific country.
Each manager prints multiple copies of the report that contains the previous day’s sales for each of their sales executives.
You need to ensure that the report uses the minimum number of round trips to the database server.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Reporting Services (SSRS) report that meets the following requirements:
-Displays sales data for the last 12 months.
-Enables users to view the sales information summarized by month.
-Enables users to view individual sales orders for any given month.

You need to design the report to minimize the impact on bandwidth.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have developed SQL Server 2008 Reporting Services (SSRS) reports that are deployed on an SSRS instance.
You plan to develop a new application to view the reports. The application will be developed by using Microsoft ASP.NET 3.5.
You need to ensure that the application can perform the following tasks:
-Display available reports in a tree view control.
-Create and manage subscriptions on reports.

What should you do?

You are designing a SQL Server 2008 Reporting Services (SSRS) solution. You have a report that has several parameters that are populated when users execute the report. You need to ensure that the solution meets the following requirements:
-Users can define their own default parameter values for the report.
-Users can schedule snapshots at any time.

Which feature should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop SQL Server 2008 Reporting Services (SSRS) reports. Several reports will contain identical data regions.
You need to minimize the amount of maintenance when changes are made to the data regions.
What should you do?