Reporting Services Subscriptions in "Pending" Status

Ran into this issue today. A subscription that had been working failed. Looking at it in the RS portal it had a status of “pending” Not helpful! I tested the report, looked at the datasources, and the subscription, it all looked good. It was only when I stepped through the subscription wizard and hit Finish that […]

Notes on Setting Up & Troubleshooting Reporting Services Using Kerberos

Not comprehensive, but perhaps useful next time: Verify that the SPN’s are correct for the server that has the Reporting Services database. Many ways to do this, but I like the Kerberos Configuration Manager. The SPN tab should show “Good” for the instance that hosts the database. If not, fix (typically requires domain admin). Don’t […]

Learning About Reporting & Visualization

Today I watched DATAVIZ YOU THOUGHT YOU COULD NOT DO WITH SSRS by Jason Thomas. The intro felt long, but once the content started it was fun to watch someone do some nice tricks with Reporting Services as far as visualizing data. The focus was using the capabilities provided with Reporting Services in unusual (to […]

Renaming The Reporting Services TempDB Database

Strange that I’ve never had/wanted to do this before, helping someone do it today and renaming it causes everything to break. The main ReportDB (regardless of what you named it) has hard references to the location to the ReportingTempDB (whatever it was called when you did the install). I found this post from quite a […]

Reporting Services Parameter Assumptions

Ran into a new-to-me quirk this week while putting together a couple of reports. I have a summary report (essentially a group by) that is linked to a detail report (that shows the details!) based on a couple of passed parameters. Works fine. I wanted to add a couple of optional filters to the detail […]

GiveCamp in Orlando Oct 21-23, 2011

The GiveCamp in Orlando needs volunteers to convert 25 reports from Crystal to Reporting Services. Food is provided, just need the volunteers!

Notes about Server SSDs

Note: This isn’t a recommendation or endorsement, just notes from some research I’ve done. Please contact your vendor before making purchasing decisions! I’ve had an SSD (solid state drive) in my laptop for a while now. There are times when the performance is downright impressive. SSD’s have been making some inroads into the world of […]