Multi Select Parameters

I'm working on  a report that I need to have multi select parameters. My data source is Oracle.  I tried using the Join Function in an expression

=Join(Parameters!Supplier.Value,

",") but it doesn't get the 'value1','Value2', etc format that I need.

My query Select * from table where supplier in (:Supplier)

Does anybody have a solution to this in their little book of tricks they would like to share?

Thanks in advance.

danamatson said:

=Join(Parameters!Supplier.Value,

 

",")

Is this being used to populate the available values of the parameter?

I think you want to create a second dataset that lists the values you want in the dropdown box for the parameter.

I do have a second data set that creates the list of values. I was using that function to build the parameter values from values that are selected from the dropdown. I maybe taking the completley wrong approach to this.

Ah ok, I see.  I think you may be looking for the first screen shot in the article that Dustin Ryan wrote:

http://www.bidn.com/articles/ssrs-development/61/building-a-report-from-the-ground-up-part-6-cascading-and-multivalue-parameters

Let me know if i'm off track.

I found this article that had exactly what I was looking for.

http://arcanecode.com/2008/10/20/sql-server-reporting-services-oracle-and-multivalued-parameters/#comment-27573

Thanks for all your help. I really appreciated it.