Delselected parameters
I have a series of 5 cascading parameters. That is, each parameter serves as a filter in the query to populate the values in the parameter list. The last 3 parameters allow for multiple selections. All refresh properties are set to automatic.
I have an instance where the parameter selections are modified upon report completion. The report is correct. But the parameter list has entries that were initially selected for the report now in an unselected state. This is confusing to
the user who wonders if the report is correct. This is a somewhat isolated situation in that I have several reports that use these parameters and this "unselect" result is not a consistent issue.
Any ideas that would cause this are appreciated.Leo
November 23rd, 2010 2:06pm
Not sure
Seems you might be hard coded Default value,
Use default value from Query and select parameter data set. it should work.
Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 2:13pm
There are no default values for the parameters where the problem exists.Leo
November 27th, 2010 11:37am
There are no default values for the parameters where the problem exists.Leo
Free Windows Admin Tool Kit Click here and download it now
November 27th, 2010 11:37am