Share via


Monitoring Subcription Status - New reports!

A while ago I wrote a blog post to explain how to monitor subscription status.  You can read it here: https://blogs.msdn.com/lukaszp/archive/2005/12/30/monitoring-subscription-status-also-calling-rs-soap-methods-from-inside-reports.aspx

Today, I updated the Subscriptions List report contained in that entry and published to enhance its functionality.

I also added 3 reports that will help you see which subscriptions use which delivery extension.

You can get the reports here:

https://cid-e5eac755bcb2e151.skydrive.live.com/self.aspx/.Public/New%20Subscription%20Reports

New Subscription List Report: https://cid-e5eac755bcb2e151.skydrive.live.com/self.aspx/.Public/New%20Subscription%20Reports/SubscriptionsList.rdl

Extension used by subscriptions: https://cid-e5eac755bcb2e151.skydrive.live.com/self.aspx/.Public/New%20Subscription%20Reports/SubscriptionsByExtension.rdl

Sub report - Standard Subscriptions: https://cid-e5eac755bcb2e151.skydrive.live.com/self.aspx/.Public/New%20Subscription%20Reports/StandardSubscriptionsExtension.rdl

Sub report - Data Driven Subscriptions: https://cid-e5eac755bcb2e151.skydrive.live.com/self.aspx/.Public/New%20Subscription%20Reports/DataDrivenSubscriptionExtension.rdl

After you download all these files to your machine, create a new report project in Visual Studio/BIDS and add the RDLs. 

Then click the preview tab to see what they do.

The reports are quite interesting in and of themselves.  Between the reports, I use the following features of Reporting Servies:

XML data extension, expression based connection strings, internal parameters with validation logic (value substitution), data set filters, data set sort, subreports, custom data set fields, code functions in reports, show/hide/visibility control, SOAP web services, charts, etc.

Take care and good luck,

-Lukasz