Musings on Reporting Services and Notification Services

The question sometimes comes up for how to get out of the gate fast when ramping up on Reporting Services. Luckily the User Education team has been doing a fantastic job cranking out tutorials about Reporting Services. This is where I would start:...

There are a couple of threads on the Reporting Services MSDN Forumn and newsgroup about IE 7 Beta 3 freezing when trying to view Reporting Services reports. Just wanted to put some quick info out for folks who run into this issue: Firstly, we know...

Some folks have run into a problem using SQL Server 2000 Reporting Services now that Visual Studio 2005 has been released. Specifically, the Report Designer in RS 2000 doesn't work in Visual Studio 2005. Luckily, there is a solution: The Visual...

(Originally I thought this post should be titled: SQL 2005 SP1 Tattered my Report Server Database – What’s up with that?) When you upgrade SQL Server 2005 to SP1 and you are running Reporting Services, you may start to get the following error message...

Some folks have asked me what happens when I upgrade my RS 2000 to an RS 2005 deployment with respect to Report Definitions (RDLs). This is an interesting lifecycle problem that we’ve approached using the following idea: What you publish to the report...

Often people take a look at their report execution times and wonder how to optimize it. They readily see that it is possible to cache a report the first time a user runs it so that subsequent users don't have to incur the initial execution time. ...

Wanted to share with you the following link. This is a presentation I gave a little while ago on Reporting Services and Notification Services upgrade. It is now available for viewing in high fidelity video. http://www.microsoft.com/emea/itsshowtime...

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...

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:...

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...

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...

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

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,...

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...

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...

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...

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...