Parameters failing when supplied by a query and set up to execute

I have a query that provides a list of detachments that are used as a parameter for the user to select when running a report.

It works fine.

I want to set up this report to also run on a schedule.

When I set the prameters on the report for any value other than the first one in the list it fails to execute with the following error.

Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) (there are no other details provided)

The query results are

All
A
B
C
D
E
G
H
I
N
V
W
X

I get this error if I input a value in the list other than All or any value that is not in the list. Any suggestions?

We are running Report Services 2000 SP1

Many thanks Ayla

All,

After additional testing, I have removed the parameter validation and can get the report to work. I hope this is fixed in a future release.

Ayla

|||

please use reporting services SP2... I think it will solve the problem.

dogu

|||

How did you remove the parameter validation?

Penn

|||I think he means remove the configuation of Avaliable values, I just fixed the problem. cheers!!