Hi all,I have a report I'd like to open in 'dormant' mode initially. ie the user has to click 'view report' to generate the content.The only way i've been able to achieve this is to add a parameter and set it to not allow nulls and set the initial value to be null.I can live with this for now because the report has a datatime paramenter so the above hack is transparent I'd like to have the default value set to Today(). But this causes the report to fire and generate automatically when it is opened.This is in 2005

So what do you want to see when the report opens? Just a blank page? or are you looking for caching the reports last execution and showing that last previous cached report until the user forces it to go to the server?

So what do you want to see when the report opens? Just a blank page? Yeah. User sets parameters and hits 'view report'. I want to have default values set for the parameters so the user can just hit view report if they dont need to customise but I don't want the report generating automatically.It doesn't matter too much here because it only takes a few secs to generate but I'll be making some more intensive ones soon and I'd rather not hit the DB/waste the users' time unnecessarily

So basically you just want confirmation from the user. How about creating a parameter that will ask "Are you sure you want to continue?" or something similar and you have a Yes/No in a dropdown?

i want to give the user the option to change the parameters before they run the report

If there is no parameter or you set default value for the parameters, then you will see the report will be generated without clicking view report button. This is by design. “i want to give the user the option to change the parameters before they run the report” Since you mention the parameters, it seems you set default value for all parameters. So, you can remove one default value, or create a new parameter just as Ricardo Sampei Said. Then you can modify the value for the parameters before generate the report. Hope this helps. Raymond

This is useless.What if you require NULL values as valid parameter values for conditional report processing??? IE the user can select one parameter or another (mutually exclusive) but in order to process this situation in the stored proc you require to be able to use a NULL value for either (used to effectively turn off filtering) for that parameter. There needs to be a mechanism/attribute that can be set on the .RDL at design time to prevent automatic execution of reports where NULL valued parameters are required for all parameters.As for the idea of adding yet another parameter to force the user to 'continue' well that's just plain rediculous when there is already a button to View Report! This workaround is not good enough particularly as we as professional report developers articulate our BI reports in a professional manner and expect to be able to present our work to the executives and business decision makers as professional reports - not some hack job that's going to represent us as half-wits! Are we asking for too much??? I don't think so.

Hi all, I have a report I'd like to open in 'dormant' mode initially. ie the user has to click 'view report' to generate the content. The only way i've been able to achieve this is to add a parameter and set it to not allow nulls and set the initial value to be null. I can live with this for now because the report has a datatime paramenter so the above hack is transparent I'd like to have the default value set to Today(). But this causes the report to fire and generate automatically when it is opened. This is in 2005 Hi, I implemented that on my website . I have a hidden parameter AutoPerformed. If has true value then report is generated automatically. if it has false value it not generated automatically. Please see this report you need to click Apply button to generate report. Alexei Cioina

Not useless at all when you consider Reporting Services is fully expanded to the .NET framework and can be manipulated at just about any level you need. I'm guessing when presenting reports in any manner to executive level individuals the default ReportServer or any other default report viewing platform isn't in mind. A solid and professional representation of the reporting products deployed to the business will be managed and handled through careful navigation and controlled settings. Typically in a dashboard and home reporting repository that is commonly controlled from the entrance as is.If people are sending out links to ReportServer or ReportManager directly to reports of folders, then yes, I completely agree they are representing the team as, "half-wits"The power of SSRS are the expansion of itself into the entire framework exposing itself to hundreds of workflow and processing options. That enables it in itself to create an intelligent reporting solution. Ted Krueger Blog on lessthandot.com @onpnt on twitter

Thanks, my sentiments as well. With Drop downs I find it impossible not to define a default, it will error out. We really need a way to disable auto generation. The website becomes even unresponsive while the SQL runs.