I have created a number of SSRS 2005 reports, and provided a number of parameters for each. Each of the parameters have default values, and therefore the report automatically renders when someone visits the report through the SSRS web site.
What I'd like to do is have all the reports have their default values, but prevent the report from automatically rendering. I've looked online, and I haven't seen anything aside from people claiming that it cannot be done. I'm hoping to see some expert advice on this one for a method of preventing the reports from automatically rendering without having to develop a custom web interface.
Any thoughts?
Does anyone know if this behavior is different in SSRS 2008?
Best Answer
Oddly enough, I had this exact same problem on one of my reports. You must have at least one parameter that is not bound to a default value in order to achieve this effect, otherwise it is impossible as you suggested.
Proof:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/d9669fb82ecb18f0/87ed0eb0996d62bf?lnk=st&q=%22reporting+services%22+auto+load&rnum=4&hl=en&pli=1