I have a report that populated drop down lists with default values. The problem is the report begins to execute prior to clicking on the "View report" button. I only want to give the user the default values to eliminate having to select them. however I don't want the report to run until the user clicks on the "view report" button. Is this possible? Thanks.

How are your users viewing the reports? Are they using Report manager or are they using a custom app? If they are using the report manager then its not an option. If they click on a report which has default paramters then its going to execute. I don't get it, why would a user click on a report but not want to view it? As a developer I would want my users to get to what they want with minimum click.

They are using Report manager. And as a developer I want my users to get what they want with a minimum of clicks also, that is why I am populating the drop down parameter lists with default values. However I also want my users to have the ability to change the defaults values to whatever they want prior to running the report. The defaults are there to save clicks, and if you want them, fine, if not, you should have the ability to change them without the report running first.

follow these steps to uncheck "Has Default" on report manager in report manager click on report > Properties > Parameters > and uncheck "Has Default" Thanks,SSRSRpt

The problem with that is if I do that I no longer have the drop down lists populated with the default values, the user then has to select a value from every drop down list. The whole point is to first offer the user drop down lists that are populated with default values, and then if they want to change any of the values they can. This seems like a very basic process that reporting services can't handle.

as far as i know if you populate parameter drop down list with default parameter, reports runs automatically. There is no way you can stop it from generating. If you come across any solution pls. share with me. Thanks,SSRSRpt

Thanks. If I find something I will let you know. I tried using a "dummy" parameter that doesn't have a default value but that didn't work either

other way of doing it, if you are passing more than 1 parameters then don't pass default value atleast for one of them that way you can stop from generating automatically.SSRSRpt

Thanks. If I find something I will let you know. I tried using a "dummy" parameter that doesn't have a default value but that didn't work either Have you found some way how to do this?? or still looking? ThanksSSRSRpt

Try adding 1 additional parameter... "ExecuteReport" & set the default to "0" Create a new query. IF @ConfirmParameters = 0 SELECT 'Please check the current parameter values and check "Execute Report" and click the "View Report" botton' AS PreRunMessage Then for you data query(s) add the following above the existing query... IF ConfirmParameters = 0 SELECT NULL AS Field1, NULL AS Field2, NULL AS Field3 -- use the actual field names... ELSE Use conditional Show/Hide based on the same parameter. The end result will be that you can set the defaults for all of your parameters but until the ExecuteReport parameter 1, none of the data queries will execute. Hope this makes sence, JasonJason Long

Jimnsov, I understand your need for the users to have and option to change the defaults. Probably you could use linked reports. You know that for linked reports you can have a different set of defaults or no defaults if you so choose. Then you could has have to set of folders. One with defaults and other folder having only linked report with no defaults.