none
Passing multiselect filter from dashboard to reporting services RRS feed

  • Question

  •  

    Hi,

     

    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

     

    Marko

     

     

     

     

     

     

     

     

    Thursday, August 21, 2008 12:59 PM

Answers

All replies

  • Hi Marko

     

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

     

    Tim

    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

     

    Cheers

     

    Marko

     

    Thursday, August 21, 2008 9:15 PM