sql server reporting services: Multi-Value parameter syntax error -- sql server reporting services

Multi-Value parameter syntax error

StMaas
10/10/2006 11:12:02 AM

sql server reporting services:

I am new to reporting services...
I've created a report that uses a multi-value parameter based ona dataset
usign a simple select statement. It works fine when a single value is
selected, but when multiple values are selected returns the error Incorrect
Syntax near ','.
How can the report code be modified to pass multiple values with the correct
syntax?

Re: Multi-Value parameter syntax error

Bruce L-C [MVP]
10/10/2006 1:19:30 PM

See my response to your other posting (which is basically, show us what you
did). My guess is you have an incorrect SQL statement OR you are not going
against SQL Server.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]