Monitoring Subscription Status (also calling RS SOAP methods from inside reports)

While posting on the Reporting Services forum, I came across a post by some folks looking to know how to automatically find out that a subscription had failed to run.  Right now, the way the RS tools are, there is no way to do this automatically without calling a SOAP method – ListSubscriptions.  These folks…

2

Windows SharePoint Services and RS 2005

In RS 2000, users had a lot of grief to get RS to work on the same computer as Windows SharePoint Services (WSS).  The reason for this is that WSS version 2.0 effectively commandeers the computer.  We provide a trouble shooting document for these here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_9fdy.asp In RS 2005 we’ve done some work to make…

0

Community Resources

I’ve received several emails from folks reading my blog asking for direct assistance with various issues.  Though in some cases I can help directly – often times I just don’t have the bandwidth for direct responses. Not to fear, there are plenty of ways to get help on Reporting Services and Notification Services. I’ve tried…

0

Support for RS 2000 RDL in RS 2005

I’ve started getting questions like the following: Given a report developed on SRS 2000 can that report run or be deployed unaltered on a SRS 2005 install can that report be modified on a SRS 2005 install Given a report developed on SRS 2005 can that report run or be deployed on a SRS 2000…

1

Reporting Services Webcasts

Andrew Watt, an MVP for InfoPath, has a great post on his blog that lists the SQL Server 2005 Reporting Services weblogs.  Check them out here: http://www.tfosorcim.org/archives/000409.html

0

Scripting Actions in Reporting Services (Also, copy my server to another server)

I am sometimes asked how to automate actions on the report server.  The answer is to use the rs.exe scripting utility.  The utility gives you a host to run VB based script files easily against the Report Server SOAP API.  The utility in SQL Server 2005, supports both the 2005 and 2000 endpoints.  These are…

0

How to click in a report to show/hide (toggle) multiple items

Many people want the user to be able to click an area of a report and have items in the report be shown based on this interaction. For example, I might want to toggle between a table view and a chart view of some data. The way to do this is to use a report…

0

SQL PASS 2005 musing and picture!

SQL PASS was held in Dallas, TX the week before last.  At the event I gave 3 talks – one end-to-end RS talk, an upgrade talk on both RS and NS, and an NS breakout drilling a little more into the inner workings of NS.  All the presentations went well and were well attended. All…

1

Using Active Directory Groups with Reporting Services

I have received several questions from customers, the latest in a conference call today, wondering how Reporting Services works with Active Directory groups The question goes along the lines – How do I configure Reporting Services to use Active Directory groups?, or Do I need to write a custom security extension to use Active Directory…

0

How to trigger a subscription in Reporting Services 2000

RS 2000 doees not support custom events.  What this means is you cannot, on the face of it, trigger a subscription on demand.  Luckly, we thought of this.  The method of doing this is not particularly pretty, but it does work. Eventing in Reporting Services is currently (2000 and 2005) limited to two events: SnapshotCreated…

2