Browse by Tags

All Tags » Reporting Services (RSS)
06 June 2011
Failing report subscriptions
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 saying that the email address of one of the recipients... Read More...
no comments
Filed under: ,
09 September 2010
How to re-order report parameters
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 of dialogue that lists them (where you might be able... Read More...
no comments
Filed under: , ,
29 July 2010
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... Read More...
no comments
Filed under: , ,
01 December 2009
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... Read More...
1 comment(s)
Filed under: , , ,
02 November 2009
Report Manager folder & file security
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 company. We granted the appropriate domain groups... Read More...
no comments
Filed under: , ,
09 October 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... Read More...
no comments
Filed under: ,
02 June 2009
Who's running your reports?
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 Services reports and I want to know how much... Read More...
2 comment(s)
Filed under: