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 |
|
dlwilson007
Starting Member
5 Posts |
 Posted - 2007-04-04 : 11:25:27
|
| Hi,In creating a report, how can you display a parameter selection that is a choice (for example, yes/no) where the data that is passed to the query is translated for the query. Selecting 'yes' would pass, for example, 'internal' to the query and selecting 'no' would pass 'external'.Is this a setting that can be adjusted in Reporting Services, or is this just a matter of how I write my queries?Thanks,David |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-04-04 : 13:12:47
|
| Just create a non-queried static list with two items, for the first the value will be "internal" and the label "Yes", for the second the value will be "external" and the label "No". |
 |
|
|
|
|
|
Parameter Values