Reports running automatically when all parameters had default values

If all the parameters for a report have default values, the report runs automatically as soon as you open it. Is there a way to prevent this?

Hi,

For the parameters set the default value to null.

Hope this helps.

|||

The point is that I WANT to provide defaults for all parameters but I DON'T want the report to run automatically.

|||

Hi,

you are asking this in client side or in Report Manager.

|||I am refering to running the reports from the client, that is when connection to http://mycomputer/reports using IE.|||

Hi,

Remove the default values of the parameters in the report or in Report Manager.Set the default values for parameters in Stored procedures.

|||

Thanks,

Will give that a try.

Do the default values still show up in the Reporting Services client? I guess I will find out when I test it.

There is another issue with this solution, I am using a table valued function that is part of a standard package so I can't edit it. I might set up a wrapper stored procedure.

Dick Campbell