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 |
|
mikeyAndy
Starting Member
1 Post |
 Posted - 2008-07-18 : 18:21:32
|
| Hi all!I have a report which has a parameter "salesPerson".But currently, to use the report, one would have to type out the salesPerson's name.Is there a way to make that textbox field where someone would type a value into a dropdown list with all possible list of names? This would be much better as if someone mistypes a name, nothing would show up.Code-wise: this is what I got right nowWHERE (dbo.people.salesPerson = @salesPerson ) |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-18 : 21:35:40
|
| Create a data set for the drop-down. In the parameters area, you then specify the data set for the drop-down list values. |
 |
|
|
shilpaa
Starting Member
6 Posts |
Posted - 2008-07-25 : 02:25:33
|
| Hello,Just Create another Dataset in the Layout tab, like select Salesperson from "table" . In the Report Parameters, Select the Just Created Dataset In the available Values, and give the SalesPerson as Value field and Label filed. Then You have dropdown list which contains all the Sale Person List. Hope this HelpsShilpa Reddy |
|
|
|
|
|
|
from typing paramter values to drop down list