Multiple Value Parameter not working
Posted on 2011-04-29
In SSRS 2005 I have created a report having two two datasets.
Nbr1 - get patient names and their diagnostic codes - but only for diag codes specified in @dxcodes.
select a.patientName, b.dxcode
from patientTbl a left outer join patdiagTbl b on a.patkey=b.patkey
where b.dxcode in (@dxcodes)
Nbr2: - get all dxcodes to populate param drop down
select distinct dxcode from patdiag order by dxcode
The dropdown seems to work fine, I am able to choose multiple dxcodes. But the result set comes back only with the very first dxcode I selected.
dxcodes contains alpha values (some values are 600.1, 600.2, V25.1, V25.5)
It is interesting that SSRS doesn't place quotes around these values, only a comma between them. Could the decimal be my problem??
Thanks in advance for your help!
(this is the first time I've tried to use multi value params)
This is the first time I've tried to create a multi value param, so please bea