Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anbalagan
Starting Member
5 Posts |
 Posted - 2007-10-05 : 04:47:05
|
| Hi All, I have two cascading parameters in my report.Both has default values as ALL coming from a query ("SELECT 'ALL' as defaultValue"). Values in the second parameter is populated based on the first one. 1. Selected a value other than the default(ALL) in Parameter1 2. Selected a value other than the default value in parameter2. 3. Selected the default value now. 4. Parameter2 is populated with all the records based on the default value of the parameter1. but selection still remains with the previous value. I need to reset it to default value. The value in parameter2 is resetting on changing of parameter1 if the previous selected value in parameter2 is not available in the newly populated data. |
|
|
|
|
|
Cascading parameters Issue (urgent)