in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • Reporting on report usage revisited

    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 they looking at? Here's what I came up with....
    Posted to DavidWimbush (Weblog) by DavidWimbush on Sun, Apr 8 2012
  • URLs to reports with non-default parameters

    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 but the documentation is a little vague on some of...
    Posted to DavidWimbush (Weblog) by DavidWimbush on Thu, Jul 29 2010
  • Reporting security audit

    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 next job. After all, this is crucial stuff. There's...
    Posted to DavidWimbush (Weblog) by DavidWimbush on Tue, Dec 1 2009
  • More fun with SQL 2008 and Windows 7

    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 I never would have fixed without help. Once again...
    Posted to DavidWimbush (Weblog) by DavidWimbush on Fri, Oct 9 2009
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems