Passing multiselect filter from dashboard to reporting services RRS feed

  • Question




    i have created a report in reporting services based on SQL database using a select statement with a parameter:


    @account (string - multivalue select).


    i am using the @account parameter in where clause


    where AccountNumber in (@account).


    AccountNumber is of nvarchar (50) type.


    i have some 20 account numbers in the report and in reporting services i can filter more than one account. now i wanted to do the same in dashboard. so i created a filter based on the account table and added the account numbers and set the filter to multivalue tree. but when i choose more than one value i get just the last account number chosen in the filter and not the rest.


    How can i get the filter from dashboard to pass the multiselect to reporting services?


    thank you











    Thursday, August 21, 2008 12:59 PM


All replies

  • Hi Marko


    This was a fix in Service Pack 1 - have you updated?



    Thursday, August 21, 2008 2:46 PM
  • Hi Tim,


    SP1 is installed on this server. But i can't still filter more than one value.


    Thank you






    Thursday, August 21, 2008 9:15 PM