Browse by Tags
All Tags »
Reporting Services (
RSS)
Nearly three years ago I wrote about how to query the ReportServer database and see who is running which reports . Since then I've made it a bit more focused. Which reports are being used the most? Which users are the busiest and which reports are...
We had an interesting problem while I was on holiday. (Why doesn't this stuff ever happen when I'm there?) The sysadmin upgraded our Exchange server to Exchange 2010 and everone's subscriptions stopped. My Subscriptions showed an error message...
I added a parameter to a report today, which put it the end of the list the user fills in before running the report. I wanted to move it higher up the list but they are presented in a tree structure. You can edit each parameter but there's no sign...
You can give somebody a hyperlink to get to a Reporting Services report and that's all they need if there are no parameters or if the default values are what they want. But how do you specify values for parameters? It turns out to be pretty simple...
Today I set out to produce a list of who has access to each report so I could get this audited by the business management. I didn't think it would take long. Download a couple of scripts, evaluate them, pick a good one, execute it, and on with the...
Just found the answer to something that has been irritating me slightly for ages: how to give a user access to a report without giving them access to all the other reports in the folder. We have folders that are based on the roles people perform in the...
I've just got round to trying out Reporting Services on my laptop, having rebuilt it with Windows 7. I'm fairly comfortable with Reporting on XP but I've clearly got some reading to do because there was some baffling security weirdness that...
Reporting Services doesn't give you any tools to monitor report usage. Who's running these reports? How often? When did they last use them? Here's how I find out. (Surprise surprise - it's another report!) I've developed over 130 Reporting...