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 |
|
andros30
Yak Posting Veteran
80 Posts |
 Posted - 2008-12-23 : 12:32:17
|
| I am trying to create a report that will allow a user to select from a list of offices and will return patient names and emails for the office selected.I've got my query that gives back patients and emails and a separate query that pulls all the open offices for users to see. How can I make the parameter to list these offices? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-12-23 : 14:40:56
|
quote:
and a separate query that pulls all the open offices for users to see
This select results in a DATASET - yes?In Properties of the parameter you can choose the source for it. There you can choose your DATASET containing the offices.Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-29 : 01:02:25
|
| you need to create two datasets one for parameter value listing and other for actual data.then as webfred suggested use from query option available in parameter properties tab to map to dataset to get values of open offices.then use other dataset for showing data. |
|
|
|
|
|
|
Parameter question