How to use a multi-value parameter in SSRS 2005?

Greetings,
I was under the impression that SSRS 2005 was able to support
multi-value parameters w/o the use of dynamic sql inside the query. If
this is true can someone please clarify the syntax or point me
somewhere that has it?
Currently my query looks like the following:
select
col1,
col2
from
mytable
where
col1 in (@.parm)
Thanks in advance,
Ben SullinsThere was a thread that had the answer for me, it contains a SQL function
that you need to create. I think that Bruce gave the answer
Look up the thread that contains:
RS2005 multi-select parameter
"sullins602" <ben.sullins@.gmail.com> wrote in message
news:1147293424.419757.99730@.g10g2000cwb.googlegroups.com...
> Greetings,
> I was under the impression that SSRS 2005 was able to support
> multi-value parameters w/o the use of dynamic sql inside the query. If
> this is true can someone please clarify the syntax or point me
> somewhere that has it?
> Currently my query looks like the following:
> select
> col1,
> col2
> from
> mytable
> where
> col1 in (@.parm)
> Thanks in advance,
> Ben Sullins
>|||This function is only for the issue in stored procedures. The below query
will work as the source for a dataset. The parameter has to be marked as
multi-select for it to turn into a multi-select parameter.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <cexley@.enableconsulting.com> wrote in message
news:u1bAkJHdGHA.4912@.TK2MSFTNGP05.phx.gbl...
> There was a thread that had the answer for me, it contains a SQL function
> that you need to create. I think that Bruce gave the answer
> Look up the thread that contains:
> RS2005 multi-select parameter
>
> "sullins602" <ben.sullins@.gmail.com> wrote in message
> news:1147293424.419757.99730@.g10g2000cwb.googlegroups.com...
>> Greetings,
>> I was under the impression that SSRS 2005 was able to support
>> multi-value parameters w/o the use of dynamic sql inside the query. If
>> this is true can someone please clarify the syntax or point me
>> somewhere that has it?
>> Currently my query looks like the following:
>> select
>> col1,
>> col2
>> from
>> mytable
>> where
>> col1 in (@.parm)
>> Thanks in advance,
>> Ben Sullins
>