I've been working with SSRS 2005 reports for a little while now, and I've had a few requests come across asking for individual users to be able to save the parameters they use for the next time they run the report. Is this feasible? Is it a part of the "My Reports" role? Any thoughts?
+2
A:
I don't know if that can be done using the report manager, but you could always use URL parameters and pass through that way, then just give them the link to follow which will take them to their report (or render it as a PDF or other format if you wish) and already have the parameters passed in.
Here is a link that will take you to a lot of MSDN documentation about URL Access for your Reports.
TheTXI
2009-03-18 18:53:24
+1
A:
I think you'll have to stop using the built-in UI and build your own report front-end to do that. I have always used RS this way and it is not all that complicated.
cdonner
2009-03-18 18:54:49
That's what I was afraid of. The one thing I don't know is how to properly integrate with the AD security. Any thoughts or pointers?
MasterMax1313
2009-03-18 19:16:36
If you use the ReportViewer control (http://www.gotreportviewer.com/), you don't need to integrate (but you have to do a bit more coding). If you have to use the server, you could use the Web Service interface, or proxy requests using the URL interface. I have always avoided AD integration with RS.
cdonner
2009-03-18 19:43:45
I just remembered, I actually did an implementation of RS 1.0 with a Java proxy (see http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html).
cdonner
2009-03-20 00:55:14