Thanks to some SMTP changes, we’ve had tons of reports fail recently!!!! I needed a quick an easy way to see the subscription status of a report, and here is what I have devised: The code above will show ALL reporting services reports on Reporting Services 2005 and 2008, and will give the last 36 … Continue reading
Posted in October 2012 …
BIDS Helper
I needed to be able to clear my reporting services data cache to get accurate loading times for reports. Unfortunately, you have to manually find the .rdl.data files and delete them, or run command line text to clear them. After a little research, I found an awesome tool which not only added a right click … Continue reading
Percent of Totals in Reporting Services (Simple way without Data Set editing)
Suppose you have the following data set: and you wanted to display this in reporting services, but also have the % of totals (i.e. Gold = 50% of all In Store Purchases). Turns out there is a very easy way to do this, assuming you are only basing this off of a Grand Total or total … Continue reading
Gantt Chart of SQL Jobs
Recently, the need to map out SQL Jobs and their times has become more important to me. I needed a listing of SQL Jobs the scheduled times, and their duration, with the status. While our in house management tool provided the information I wanted an easier and more friendly tool to view these through, so … Continue reading
Reporting Services 2005/2008 Job Lookup
Ever needed to manually run a report from Reporting Services, following the rules of a subscription, but don’t want to go through the effort of editing an existing subscription, letting it run, then editing it back or creating a new one? The following T-SQL Statement, when ran against the Reporting Services Database will allow you … Continue reading
ERMAHBLERG 