SSRS

[General]

Questions:

Notes:

What are the differences between Push and Pull Deliver Methods?

 With the Pull delivery method, the user is accessing the file from the Report Manager themselves.

 

With the Push delivery method, the reports are automatically delivered to the user.

What are Subscriptions?

 Subscriptions are a functionality with SSRS that pushes or delivers reports to multiple users on an automatic and scheduled basis.

What are the types of Subscriptions?

 The types of subscriptions include:

  • Standard Subscriptions
    • The report is delivered to multiple users in a single rendering format and the recipient information is hardcoded
  • Data Driven Subscriptions
    • The report is delivered to multiple users in multiple rendering formats and the recipient information is not readily available. The recipient information is in the data source where it must be retrieved.

How do you change the security of Rendering File Types?

 You can allow or deny users to use a specific rendering file type.

There are several ways to do this:

  • You can do this manually by opening this config xml file:

    C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportServerrsreportserver.config

    An changing the render file types to VISIBLE=”FALSE”

What are the two databases used by SSRS?

 ReportServer  and ReportServerTempdb

What is the purpose of ReportServer Database?

 It stores report metadata and snapshort reports.

What is the purpose of the ReportServerTempDb?

 It stores cached reports

What is involved in report Authoring/Development?

 In report authoring/development, you gather the requirement for the report, get the source of data and how to retrieve it, Then implement or create the report requested.

What is involved in management of reports?

 In report management, different optimization technics are employed to speed the performance of the report, security is provided to ensure safty of the report and access level control and deployment technics are layed out to clearly state how the report will be moved to the enviroment where it will be accessible to users or other developers.

What is involved in report delivery?

 Report delivery is the method of making report accessible to the clients. The delivery can be in different formats such as via email, subscriptions or storing the report on a shared folder on the network accessible to the clients.

Which component is used in creating a managed report, Adhoc Reports and Embedded Reports?

 Managed Reports are created using Report Server Projects in BIDs, Ad hoc Reports are created with Report Model Project in BIDS and Embedded Reports are created with Report Server Project in BIDs.

What is a Report Builder?

 It is a tool that comes with SQL Server with a microsoft office like interface that allows non technical or technical people to quickly create adhoc reports from a report model. The report model is created in BIDs using the report model project and deployed to the report server. Users can then load the report model into the Report Builder tool from the report manager web application interface and create custom reports, which can either be stored on the local machine or saved on the report server.

What is the difference between report server, report manager, report designer and report builder?

 Report server is the gateway to the ReportServer database to graphically see the reports in a web from. A report manager is a gateway to the Report engine to manage and administer the reports such as providing security, delivery and subscriptions.

What is a report?

 It is a structured arrangement of information that helps business and organizations to quickly view activities for better decision making.

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. The Reporting Services reporting platform was introduced in 2004 as an additional component of Microsoft SQL Server 2000.

What are levels of security in SSRS?

 System level: Enter into the system.

Report item level: Access to  folders, reports, data sources.

What is a document Map?

 Document map is for easy navigation within a large report and to add links to allow the user to jump to a related report or Web location.

What is RS.exe?

 It is a command Line utility that can be used to run vb.net scripts reports and it’s configuration data.

What is a Data Region?

 A data region is a special type of report item that you add to the

report layout that is bound to a data set, such as a table, matrix, chart, gauge,or list.

What are Report Items?

 You use report items to add graphical elements, such as an image or line to a report. Using a text box, you can display static text, such as a report title, or text from a data set.

 

Leave a Reply

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

Name *