|
SSRS |
|
|
[General] |
|
|
Questions: |
Notes: |
|
What is a Report? |
A Report is a structured arrangement of information. Typically, the information in a business report comes from data in a business application, although report information can be derived from a variety of sources.
They are answers to Business Questions. |
|
What is a Reporting Platform? |
A Reporting Platform is an integrated set of applications that supports all required activities in a managed report environment, including report development, management, and viewing. |
|
When was the first Reporting Services released? |
The Reporting Services reporting platform was introduced in 2004 as an additional component of Microsoft SQL Server 200 to address these problems.
Since then, organizations small and large have migrated to Reporting Services to take advantage of the many benefits it has to offer. |
|
What is a Managed Report? |
A Managed Report is characterized by detailed operational data or summarized management information that is gathered from a variety of data sources and formally organized into a central repository.
Also known as Static Reports. Often, managed reports must conform to specified formatting standards. |
|
What is an Ad Hoc Report? |
An Ad Hoc Report allows users with limited technical skills to produce new, simple reports on their own.
They can choose whether to save them privately or to share them with others by publishing to the Reporting Services centralized store. |
|
How accessible are Ad Hoc Reports? |
Because Ad Hoc reports usually don’t have the same layout requirements as managed reports and because Report Builder is easy to use, typically anyone with permission to see data used for reporting is allowed to create ad hoc reports. |
|
What are Report Models for? |
To support business users creating ad hoc reports, a more technical user can develop a report model that describes the tables and columns in a database in a user-friendly format. |
