Home Forums Reporting Services Reporting Services 2005 Development Create Paramater Filter by State RE: Create Paramater Filter by State

  • January 11, 2012 at 9:39 am

    #1431918

    matt.jonas (1/11/2012)

    Can you post code for the stored procedure you are calling to populate your State dropdown box?

    I have made some progress.

    I created another Data Set to poulate the list box and that works.

    SELECT StateAbbr

    FROM States

    I Select a State 'AK', click on View Report and it Filters the records.

    If I select another State from the list 'TX' and Click on View and it still displays 'AK'

    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/