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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-02-20 : 04:51:49
|
| Hi,Hope this makes sense. Ive got a query which has a whole list of sales figures but would like a filter (parameter) so the user can select which values he would like to vue. I know when inputting parameter into the query this would require = @param or > @param if your looking for equals OR more than.I can create a dummmy table with values 100, < 75, < 50, > 50. But how can I implement this as the parameter so they can select either value above?Fahad |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-20 : 11:41:19
|
| just add dataset to your report to retrieve the values from dummy table. then use it to populate a parameter which enables user to select a value. then you can use filter available in data tab under dataset properties to filter results based on selected range. |
 |
|
|
|
|
|
Report parameter suggestion