> 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
>

> 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
>>
>
>