RS2005 Multi-Value Problem, urgent!

Dose RS 2005 Multi-Value parameter function can work?
Trying to use multi-value function of RS2005,
dataset named as "AdventureWorks and syntax as following:
SELECT Name, ProductCategoryID
FROM Production.ProductCategory
WHERE (ProductCategoryID = @.ID)
Properties: multi-value
Available values: From query
Dataset: dataset1
Value field: ProductCategoryID
Label field: Name
Dataset1's syntax:
SELECT Name, ProductCategoryID
FROM Production.ProductCategory
Preview report and choice Bikes, Clothing has error msg:
An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for data set 'AdventureWorks'.
Incorrect syntax near ','.
Dose anyone has the same problem?
In Beta the Multi-Value function is ok,
but in released enterprise version I have this problem?
What's happened?
Thanks for any advice!
AngiYou have to write
... WHERE ProductCategoryID IN (@.ID)
"Angi" <enchiw@.msn.com> schrieb im Newsbeitrag
news:uIw261SAGHA.3968@.TK2MSFTNGP10.phx.gbl...
> Dose RS 2005 Multi-Value parameter function can work?
> Trying to use multi-value function of RS2005,
> dataset named as "AdventureWorks and syntax as following:
> SELECT Name, ProductCategoryID
> FROM Production.ProductCategory
> WHERE (ProductCategoryID = @.ID)
> Properties: multi-value
> Available values: From query
> Dataset: dataset1
> Value field: ProductCategoryID
> Label field: Name
> Dataset1's syntax:
> SELECT Name, ProductCategoryID
> FROM Production.ProductCategory
> Preview report and choice Bikes, Clothing has error msg:
> An error occurred during local report processing.
> An error has occurred during report processing.
> Query execution failed for data set 'AdventureWorks'.
> Incorrect syntax near ','.
> Dose anyone has the same problem?
> In Beta the Multi-Value function is ok,
> but in released enterprise version I have this problem?
> What's happened?
> Thanks for any advice!
> Angi
>|||uh... Thanks Ralph...
Don't know what I think... ><
Make the funny mistake..
"Ralph Watermann" <We.Want@.NoSpam.de> ¼¶¼g©ó¶l¥ó·s»D:uizY49VAGHA.3928@.tk2msftngp13.phx.gbl...
> You have to write
> ... WHERE ProductCategoryID IN (@.ID)
>
> "Angi" <enchiw@.msn.com> schrieb im Newsbeitrag
> news:uIw261SAGHA.3968@.TK2MSFTNGP10.phx.gbl...
>> Dose RS 2005 Multi-Value parameter function can work?
>> Trying to use multi-value function of RS2005,
>> dataset named as "AdventureWorks and syntax as following:
>> SELECT Name, ProductCategoryID
>> FROM Production.ProductCategory
>> WHERE (ProductCategoryID = @.ID)
>> Properties: multi-value
>> Available values: From query
>> Dataset: dataset1
>> Value field: ProductCategoryID
>> Label field: Name
>> Dataset1's syntax:
>> SELECT Name, ProductCategoryID
>> FROM Production.ProductCategory
>> Preview report and choice Bikes, Clothing has error msg:
>> An error occurred during local report processing.
>> An error has occurred during report processing.
>> Query execution failed for data set 'AdventureWorks'.
>> Incorrect syntax near ','.
>> Dose anyone has the same problem?
>> In Beta the Multi-Value function is ok,
>> but in released enterprise version I have this problem?
>> What's happened?
>> Thanks for any advice!
>> Angi
>