Technical Interview Questions IN SSRS-Part 2

Few important facts about SSRS were still missed out from my last article titled- "Technical Interview Questions IN SSRS". So thought of adding all those in this one. Hope this will be useful to all of you

Please refer to Technical Interview Questions IN SSRS-Part 1

Types of SSRS Reports

1. Parameterized reports: When the output of a report is not static but instead depends on the input parameters supplied to the reports at run time, the report is known as a Parameterized report.Drillthrough reports, linked reports, subreport and all other report types are a kind of Parameterized reports.

2. Linked Report: A linked report is a report server item that is derived from an existing report and retains the original report's definition. A linked report always inherits report layout and data source properties of the original report. All other properties and settings can be different from those of the original report, including security, parameters, location, subscriptions, and schedules. Linked report act as a shortcut to the original report.
To create a linked report, we can go to the report manager. Click on the dropdown mark of any individual report.A menu like in the image-1 will appear. Click on the "Create Linked Report" option from the menu to create a new linked report.
To change the parameters,subscription, schedules, etc. Of the linked report click on the dropdown mark of the linked report and from the same menu shown in image-1 select the "Manage" option and you will get different options to modify according to your requirement.

3. Snapshot reports: A report snapshot is the report output reference i.e. report layout information and query results retrieved at a specific point of time.The report snapshot is stored in the report server to be delivered at the specified time to specific users. Basically, report subscription is a report snapshot generated on some defined scheduled time and delivered to the intended audience by the report server. The report snapshot can be used to build a history of a report that can be further used to analyze data changes over time.

4. Cached reports : A cached report is a saved copy of a processed report. Cached reports are used to improve performance by reducing the number of processing requests to the report processor and by reducing the time required to retrieve large reports. They have a mandatory expiration period, usually in minutes.

5. Adhoc reports: Reports which are created by the End user from the reporting model with predefined layout are called Adhoc reports. The developer needs to develop the Report Model or even give only the SSAS cubes so that the user can create Data model or views from existing cube to access in report depending on their requirements. To create a adhoc report on the Report Manager Server, we need to use the Report Builder feature of the Report Manger.

6. Drilldown reports:

7. Drillthrough reports:

8. Subreports : A subreport is a report that displays another report inside the body of a main report. It is used to embed a report within a report. Any report can be used as a subreport. The subreport can use different data sources than the main report and it can have its own datasets. The parameters can be passed from Main report to the subreport.

Difference between report builder and report designer:
Report Builder is a web-based tool to create reports. Report Builder is assessable through the Report Manager so the reports developed are bydefault stored in the Server but reports developed using Report designer of BIDS available in MS Visual Studio can be stored as RDL Files in the local or can be stored in the server. There is no compulsion as such.
Report Builder is basically used by the end-users for developing some basic reports with little features as compared to the large functionality of Report Designer in BIDS which is mainly used by developers.
A report builder looks more or less like some Microsoft Office tools.

What is report subscription?
A report subscription is a report snapshot generated on some defined scheduled time and delivered to the intended audience by the report server. SSRS allow you to create two types of subscriptions, i.e. standard subscription and data-driven subscription.

Standard Subscription:
Subscriptions are request to deliver a report to the requested recipients at a particular time. The schedules can be set at different time intervals like once,none,daily weekly or monthly,etc.

Data Driven Subscription in SSRS:
Only reports that use "stored credentials" to access a report data source can be distributed through a data-driven subscription. Stored credentials are necessary for unattended report processing. The SQL Server Agent service should be in running condition. If it is not running, you cannot save the subscription. In data-driven subscription the data or parameter values required during execution of the report can come from a query from a database including recipient list, delivery method and parameter values needed for each recipient's report execution, which makes it a dynamic subscription that gets required data during run time from the external data source.




No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: