is NOT a parameter

When I use this line of code:

CASE WHEN d.StatusId IN ('XF','?','XT') THEN 1 ELSE 0 END AS Status

MS Reporting Services 2005 thinks that ? is a parameter. I know that I can use a stored proc to prevent this, but I would rather not.

Does anyone have suggestions on how to prevent this from occuring?

How about (not testing but it should work):

Code Snippet

CASE WHEN d.StatusID IN ('XF',CHAR(63),'XT') THEN 1 ELSE 0 END AS Status

>L<|||

Thanks Lisa,

That works. I also found that you can remove the <Parameter> tag from the code to fix it.

floyd

|||Nice username. HAHAHA sql