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 |
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
 Posted - 2006-07-03 : 14:12:04
|
| I'm using RS 2005. I want to set up a report that uses a parameter to disable/enable other parameters. I haven't been able to do this so I've gone with a 3 parameter solution, the 1st parameter determines which parameter (#2 or #3) the report uses and repopulates the drop downs for #2 and #3 and uses "--Not Used--" for the display and "-1" for the value. Parameters #2 and #3 have a default value of -1, to fill in the "--Not Used--" (and only) choice for the user. The problem is, the default value is no longer selected on subsequent report runs or if I toggle param #1 multiple times. Any help would be appreciated. |
|
|
|
|
|
Default values