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 |
|
Vassago
Starting Member
33 Posts |
 Posted - 2010-06-09 : 14:20:37
|
| I have a parameter on a report with Available values from a Query of Supervisors. Currently, it's set to read the person's UserID as the Default Value so it automatically filters to the Supervisor's team if the person appears on the list of Supervisors. If the person doesn't appear, it's blank so the user may select one or all of the Supervisors. Is there any way to automatically tell the Parameter to choose Select All if the person's userid doesn't appear in the Available Values?Thanks for any and all help received, it's been wearing me out! |
|
|
|
|
|
UserID Parameter Check Question