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:

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:

New Subscription List Report:

Extension used by subscriptions:

Sub report - Standard Subscriptions:

Sub report - Data Driven Subscriptions:

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,