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 |
|
1sabine8
Posting Yak Master
130 Posts |
 Posted - 2007-10-15 : 03:32:10
|
| Hi, I have a parameter "Restaurant" got from a query which is multivalued and i have a table where there is a group "Restaurant". My problem is that on report generation, if i choose more than one restaurant from the list, i see in the table one the first restaurant chosen but with the values listed of all the other restaurants too. How can i fix the grouping in order to see the name of all the resaturants. I wrote =Parameters!Restaurants.Value()in the column in the table and =Parameters!Restaurants.Value(0)in the expression of the grouping.Pleaaaaaaaaase help... |
|
|
DHL
Starting Member
16 Posts |
Posted - 2008-01-10 : 05:22:16
|
| Any updates to this? I have the same issue... |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-10 : 07:05:33
|
| Didnt get you fully...are you telling that filtering is not working in report table?more details plzz... |
|
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2008-01-10 : 14:53:18
|
| I have only tried using multivalue report parameters by setting the report parameters to a dataset.It looks like you are trying to pass the parameter to filtering which I have don't know how to do either.Example of setup for Multi value report parameter..Name: idrangedatatype: integerMultivalue checkbox checked.Available values:select "From Query" where Dataset = dataset I created, Value Field = field from dataset, Label field = same as dataset.The dataset will return records already filtered. |
|
|
|
|
|
|
Grouping Multivalued Parameter