Microsoft Office Tutorials and References
In Depth Information
The new data source can be accessed via a URL. Whenever you create a shared data source using SSDT
Report Designer or Report Builder, you can enter the shared data source’s URL to access it. To know if there are any
dependent items using this shared data source, you can click View Dependent Items from the ECB menu of the shared
data source item in the document library. You can certainly edit or delete this shared data source, but be aware that
will impact the reports using it.
Now, what if someone wants to subscribe to these reports and knows how the data is changing over a course of
time? Or maybe you want to save these reports in a particular output format on a scheduled basis? Reporting Services
provides a mechanism to fetch these reports either on-demand or on a subscription basis. In the next section, you’ll
see how to subscribe to reports that are published to a SharePoint environment.
Subscription to Reports
When you publish reports to a SharePoint environment integrated with a report server, you have the option to
subscribe to them as long as you have access to the reports. You can create subscriptions that can be delivered
To a SharePoint document library: Reports are delivered to a document library that
is available on a SharePoint site integrated with report server running in SharePoint
integrated mode. The delivered reports are static in this case.
To a shared folder on file system: Static reports can be delivered to a shared folder that is
accessible from the network.
To e-mail: Reports are delivered as an e-mail attachment.
Null: You can preload ready-to-view parameterized reports into a cache for specific
scenarios. They can be used by administrators with the data-driven subscription model.
■ Data-driven subscriptions are used when you want to customize the distribution based on dynamic
subscriber data at run time. For instance, you can distribute a report in any format either as is or filter data within
your organization where subscriber lists vary over time. to learn more about data-driven subscriptions, go to
Reports are delivered in one of the available formats you choose while subscribing, including xml, csv, tiff, pdf,
mhtml, Excel, and Word. For best results, it is recommended that you export reports in preview mode to see if they
emerge correctly. If not, you can change them in design mode to make them look better.
An important aspect to note here is that reports delivered by subscription are not the original report files (.rdl).
They are static reports, and you can’t use them with the Report Viewer Web Part. Even if you change the extension
back to .rdl, you will not be successful in loading them.
When versioning is enabled, only the major version will be created for the rendered output documents.
In the following example, let’s try to subscribe to the Internet Sales report and deliver it to a SharePoint document
library in the web archive file format (.mhtml).
Search JabSto ::