Multi-Select Query with redundant values

[tomstieger]

I have an Multi-Select Query for an input control in Jasper Server CE 3.7 that is not working like I expect.

My SQL for the control is like the following;

  Select dptno, cname from dptlist                     

When I run this SQL outside of Jasper I get all the departments and their descriptions, some departments have multiple subdepartments with the same department number.

In Jasper Server with the input control it only shows me one description for each department.

My value for the input control is set for dptno and I am displaying both dptno and cname for the drop down.

 

Any help is appreciated.  Thanks.

 

-Tom