July 23, 2007 at 3:04 pm
I have some reports that automatically run and this appears to happen due to having default values or having all drop-downs. In most of my reports I have one or many drop-downs and my last parameters are usually text boxes that except strings for begin and end date ranges. As long as the last text box is not set with a default, then the report doesn't automatically run. I have one report that has all drop-downs with no textboxes and it automatically runs even when I remove defaults for the drop-downs.
1) Can you specify at the report level that the report should not automatically run when there are default values for parameters?
2) If you can not turn off auto run from the report level, is there a way of preventing a report from automatically running when there are all drop downs?
July 24, 2007 at 5:51 am
I have been wrong in the past, but I do not think there is a way to get the report to not run immediately if there are defaults for all of the parameters. If you do have dropdowns for the parameters without defaults and they do not allow NULL, the report will not run until the parameters have been set and the button is clicked.
So, the answer is, do not set a default for one of the parameters and make sure the parameter is required.
If you wanted a hack workaround and you have to have a default for all of the parameters, include an extra parameter that does not do anything, require it, and do not give it a default.
July 26, 2007 at 8:28 am
Thank you for the response Michael. For some reason my report still automatically runs when there are all drop-downs that do not contain defaults and do not allow NULL. Maybe it is due to other complexities in my report. I have some hidden parameters for setting parameter values or maybe it has to do with the chain in which the drop-downs drive each other.
The interesting thing that I have found is that I can get the report to behave the way I would like it to from the Visual Studio IDE. For instance, I can specify a bogus default value for a drop-down (a value not in my list) and it effectively makes the drop-down not auto-select and therefore not auto-run. When I follow your suggestion, I get desirable results from the IDE as well. However, when I deploy to the web server, I see auto-selecting of the first items in my drop-downs and the report auto-running.
Oh well---I give up after playing around with many different settings combos. It will either be a limitation for this report or I will provide another parameter as a text box to be used as a functional or non-functional (blank) parameter...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply