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
Tagged with Reporting Services 2005 …
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
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 