I am using a command object to provide a distinct list of values for a parameter drop down list - P_HS_YEAR.

The report uses approx. 8 tables joined together along w/ this command object. The command object is not linked in any way to the tables.

The report contains two other parameters that get data from the linked tables in the report P_Academic_Year,P_Type. When I run the report all possible values in P_Academic_Year and P_Type are not displayed; we see perhaps 6 out of 8 for academic_year, 5 out of 6 for type. When I remove the command object all values in the drop downs come in as expected. Can anyone provide a fix / reason for this?