So far I have created a Stored Procedure with a State Parameter.

I changed the Data Source to the Stored Procedure.

I have a Drop Down Box and it displays the States but they are repeated for every record on my Stored Procedure which is based on Companies.

I selected a State 'TX' and clicked on View Report and it filters the Report.

I click on the State List box and it and it only lists 'TX', the other States are not displayed.

I click to refresh the Data but I sill on get TX.

I do not want the States to be distinct.

How can I accomplish that & get rid of the filter problem.