The following code for the {?Dept_ID} input parameter is not working correctly when I select a value other than blank for the dept_id input parm:

It does not throw an error at all, it just will not return any values if I select a value other than blank (' ') in the parameter section. If I select blank I get a list of all the records but if I select a DEPT_ID in the parameter section then it returns no values at all when I know that it should.

I just changed it now and it worked correctly, thank you very much. Now since I changed that input parm to numeric I ran into another issue with a different part of my report. Is there an easy way to convert the numeric array back to a string array for use in other parts of the report?

I don't have any code in the report that converts the number to a name due to the fact that the list of department's is very very long so I can't hard code it.