InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 10:21:15 GMT20http://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspx[quote][b]Welsh Corgi (1/13/2012)[/b][hr]The refresh and all of the other control with the exception of the Show or Hide Parameter button are disabled on the preview tab.[/quote]The Refresh button will be grayed out until you select some parameters and run the preview. When the results appear, the other toolbar buttons should no longer be grayed out. Are your buttons staying grayed out after you run the preview and see the result?Fri, 13 Jan 2012 09:30:20 GMTwolfkilljhttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxThe refresh and all of the other control with the exception of the Show or Hide Parameter button are disabled on the preview tab.Fri, 13 Jan 2012 09:09:40 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspx[quote][b]Welsh Corgi (1/11/2012)[/b][hr][quote][b]matt.jonas (1/11/2012)[/b][hr]Can you post code for the stored procedure you are calling to populate your State dropdown box?[/quote]I have made some progress.I created another Data Set to poulate the list box and that works. [code="sql"]SELECT StateAbbrFROM States[/code]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'[/quote]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.Fri, 13 Jan 2012 08:43:06 GMTwolfkilljhttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspx[quote][b]jcrawf02 (1/11/2012)[/b][hr]Meaning that you want to be able to pick all states? (by making no selection) if so, then create your statement dynamically and only drop in the state if selected. If that's not what you want, please clarify.[/quote]Excuse me but I have written a lot of reports in many different tools but that is not the case with SSRS.I did not know that you had the option to select all states until I checked the multi-select check box.So please disregard that statement.:-)Wed, 11 Jan 2012 15:36:56 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxMeaning that you want to be able to pick all states? (by making no selection) if so, then create your statement dynamically and only drop in the state if selected. If that's not what you want, please clarify.Wed, 11 Jan 2012 15:28:18 GMTjcrawf02http://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxThanks. The problem that I'm dealing with is that my Stored Procedure allows nulls but I must Select a State or I get an error.:hehe:Wed, 11 Jan 2012 11:06:05 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxI think that's BIDS caching again -I think you need to exit the report, resave, and then try running it again.You shouldn't see that behaviour in a deployed report :-)Wed, 11 Jan 2012 11:01:49 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxI spoke to soon, modified the SP to Accept a NULL value and the report defaults to the last State that I selected in the Drop Down Box.Wed, 11 Jan 2012 10:55:53 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxThanks everyone, I deleted the parameters and Dataset, recreated and all of my problems went away.:crazy:Wed, 11 Jan 2012 10:32:41 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxIIRC BIDS caches results locally. There is a way to make it run a fresh set but I forget how!You can force it by deleting the cached data from the file system - it'll have the same name & path as the rdl file.Wed, 11 Jan 2012 09:59:24 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspx[quote][b]matt.jonas (1/11/2012)[/b][hr]Which version of SSRS are you using? Are you doing your testing in Business Intelligence Development Studio?[/quote]SSRS 2005 & I'm testing in BIDS.Wed, 11 Jan 2012 09:55:02 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxWhich version of SSRS are you using? Are you doing your testing in Business Intelligence Development Studio?Wed, 11 Jan 2012 09:50:53 GMTmatt.jonashttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxI deleted the parameter but the data is still filtered by State?:laugh:Caching?Wed, 11 Jan 2012 09:43:03 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspx[quote][b]matt.jonas (1/11/2012)[/b][hr]Can you post code for the stored procedure you are calling to populate your State dropdown box?[/quote]I have made some progress.I created another Data Set to poulate the list box and that works. [code="sql"]SELECT StateAbbrFROM States[/code]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'Wed, 11 Jan 2012 09:39:48 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxCan you post code for the stored procedure you are calling to populate your State dropdown box?Wed, 11 Jan 2012 09:29:56 GMTmatt.jonashttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxSo 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. Wed, 11 Jan 2012 09:18:49 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic1234036-1063-1.aspxI'm trying to create a parameter to filter a Report by State.Any help would be greatly appreciated.Wed, 11 Jan 2012 08:28:05 GMTWelsh Corgi