Nate Winchester • 4 years ago
Thank you! I had been struggling with this kind of thing in a report myself but your instructions here finally got it to click for me over all the others I had found.
Just FYI for anyone else coming across here: Make sure you check what your other data is formatted. In mine, the query to generate the available parameters was returning INT. So I had to adjust it to:
UNION
SELECT 0 AS code, 'NONE' AS desc
Then in data to populate the table, tweak the where:
WHERE ISNULL(code, 0) IN (@ParamName)
After that, the report clicked and I got the results needed. Much obliged for the help.
Cool. Worked for me! Thanks