Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Create Paramater Filter by State Expand / Collapse
Author
Message
Posted Wednesday, January 11, 2012 11:01 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, April 10, 2014 10:18 AM
Points: 1,769, Visits: 2,800
I 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
Post #1234215
Posted Wednesday, January 11, 2012 11:06 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:03 AM
Points: 4,052, Visits: 4,192
Thanks. 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.

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/

Post #1234219
Posted Wednesday, January 11, 2012 3:28 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:47 PM
Points: 2,627, Visits: 19,092
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.

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1234429
Posted Wednesday, January 11, 2012 3:36 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:03 AM
Points: 4,052, Visits: 4,192
jcrawf02 (1/11/2012)
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.


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.


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/

Post #1234432
Posted Friday, January 13, 2012 8:43 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:35 AM
Points: 1,172, Visits: 2,413
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
Blog: SQLSouth
Twitter: @SQLSouth
Post #1235706
Posted Friday, January 13, 2012 9:09 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:03 AM
Points: 4,052, Visits: 4,192
The refresh and all of the other control with the exception of the Show or Hide Parameter button are disabled on the preview tab.



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/

Post #1235729
Posted Friday, January 13, 2012 9:30 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 07, 2014 7:35 AM
Points: 1,172, Visits: 2,413
Welsh Corgi (1/13/2012)
The refresh and all of the other control with the exception of the Show or Hide Parameter button are disabled on the preview tab.



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?


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1235773
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse