Posts Tagged ‘SSIS’

SSRS Interview Questions VI

11. What is Report Subscription ?
A subscription is a standing request to deliver a report at a specific time or in response to an event, and in an application file format that you specify in the subscription. Subscriptions provide an alternative to running a report on demand. On-demand reporting requires that you actively select the report each time you want to view the report. In contrast, subscriptions can be used to schedule and then automate the delivery of a report.

Reporting Services supports two kinds of subscriptions: standard and data-driven. Standard subscriptions are created and managed by individual users. A standard subscription consists of static values that cannot be varied during subscription processing. For each standard subscription, there is exactly one set of report presentation options, delivery options, and report parameters.

Data-driven subscriptions get subscription information at run time by querying an external data source that provides values used to specify a recipient, report parameters, or application format. You might use data-driven subscriptions if you have a very large recipient list or if you want to vary report output for each recipient.

When a user creates a subscription, he or she can choose one of the available delivery extensions to determine how the report is delivered. Reporting Services includes support for e-mail delivery and delivery to a file share. Developers can create additional delivery extensions to route reports to other locations. Another delivery method is called the null delivery provider. This method is not available to users. Null delivery is used by administrators to improve report server performance by preloading the cache.

12. What is custom code in Reporting Services ?

Ans. As its name suggests,custom code gets saved inside the report definition (RDL) file; it is scoped at a report level. You can write embedded code in Microsoft Visual Basic .NET only. Once the code is ready, you can call it in your report expressions by using the globally defined Code member. For example, if you have authored an embedded code function called GetValue, you can call it from your expressions by using the following syntax:


You can write embedded code to create reusable utility functions that can be called from several expressions in your report.Also it centralizes the logic of the expression in one place instead of using functions for every field in the report and it makes the report more maintainable because, if you decide to make a logical change to your function, you do not have to track down and change every function in the report.

Prev    Next