SSRS multiple values parameter not working
Posted on 2014-09-26
I have a report showing Sales Order information, basically a Header section and a Sub-report showing the lines. The report has a parameter defined for the order number. Everything works great when showing a single order.
However, if select more than 1 order in the parameter drop-down, then the report is blank.
I'm using 3 data sets: Header Detail, Line Detail & a 3rd for the Order Number query.
The parameter value(s) for the header and lines datasets are set to use the values returned from this 3rd dataset.
This piece is working as I do get a correct list of Order Numbers to select in the drop-down, it just won't work if I choose more than 1 (or All).
What am I missing??