SSRS

[General]

Questions:

Notes:

What is SSRS?

 SSRS stands for SQL Server Report Services. It is the component of Microsoft SQL Server 2008 that provides an enterprise-ready and extensible presentation layer for the Microsoft business intelligence platform to develop, manage and deliver reports.

 

What are the stages of the Report Life Cycle?

 The stages of the Report Cycle include:

  1. Authoring /Development

i.            Development and creation of a report

  1. Management

i.            Optimization and Security

  1. Delivery / User Access

i.            Deployment and Delivery through Emails, Shared Folders, etc. Subscriptions.

What happens during Requirement Gathering?

 Ask questions such as:

  • What is the data source? OLTP? SSRS? Analytical DB?
  • What kind of business questions do you want to answer?
  • How should this data be presented? In what form?

What are the main components of SSRS?

 The main components of SSRS include:

  1. Report Designer
  2. Report Builder
  3. Report Server
  4. Report Manager

What types of Reports does SSRS support?

 The types of Reports include:

  1. Managed Reports
  2. Ad Hoc Reports
  3. Embedded Reports

What are Managed Reports?

 A Managed Report is for users who know how to use all of the aspects of the reporting tool.

 

They are Enterprise Reports that are managed by the SQL Developers up until the finished product.

 

These users know the structure of the underlying data and they know how to retrieve the data. These reports are code based for developers.

 

You use the Report Designer to make Managed Reports.

Leave a Reply

Your email address will not be published. Required fields are marked *

Name *