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