Parameter Error Message

[CuteGeek]

Error Message: The report parameter ‘prmPI’ has a DefaultValue or a ValidValue that depends on the report parameter “prmPI”. Forward dependencies are not valid.

I have created a dataset that shows the below query: this is working.

SELECT
0 AS ID,
'All' AS name
UNION
SELECT DISTINCT
per.ID, per.lname + ', ' + per.fname + ' ' + per.mname AS name
FROM awardpi api
JOIN personnel per ON api.piID = per.ZID
WHERE @prmPI = CONVERT(varchar(100), per.ID)
ORDER BY per.ID

Than in Report Parameter I have below:
dataset dsPI
Value field: ID
Label field: name

but I am still getting the above error message..not sure what I am missing..

Thanks
Cutegeek

 

[xlbo]

What do you have set for the "Default Value" property of that parameter?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question