The report data is populated from a stored procedure. But in order to populate the drop down list, I set up another dataset from a query.
SELECT DISTINCT cipcode, ciptitle
FROM dbo.q_Outcomes
WHERE LEN(cipcode) = 2
ORDER BY cipcode;
Then set the @cip parameter "Available Values" to pull from this query. This works, but the LIKE part of the query in the original procedure goes away, and only one value is returned.
I hope this answered the question.