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.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/