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

  • January 13, 2012 at 8:43 am

    #1433305

    Welsh Corgi (1/11/2012)

    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'

    As others have mentioned, this is most likely caused by the fact that BIDS caches the dataset the first time you generate a report previews and uses the cached data every time you re-run the report preview. There's a "Refresh" button on the Preview tab toolbar - click it to make BIDS retrieve new data from the data source to generate the report preview.

    Jason Wolfkill