<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Reporting Services
»
Reporting Services 2005 Development
»
Create Paramater Filter by State
17 posts, Page 2 of 2
««
1
2
Create Paramater Filter by State
Rate Topic
Display Mode
Topic Options
Author
Message
Gazareth
Gazareth
Posted Wednesday, January 11, 2012 11:01 AM
UDP Broadcaster
Group: General Forum Members
Last Login: 2 days ago @ 1:53 AM
Points: 1,474,
Visits: 2,342
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
Welsh Corgi
Welsh Corgi
Posted Wednesday, January 11, 2012 11:06 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 3,833,
Visits: 4,052
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
jcrawf02
jcrawf02
Posted Wednesday, January 11, 2012 3:28 PM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 12:09 PM
Points: 2,550,
Visits: 18,882
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
Welsh Corgi
Welsh Corgi
Posted Wednesday, January 11, 2012 3:36 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 3,833,
Visits: 4,052
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
wolfkillj
wolfkillj
Posted Friday, January 13, 2012 8:43 AM
Right there with Babe
Group: General Forum Members
Last Login: 2 days ago @ 6:54 PM
Points: 721,
Visits: 1,375
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.
Post #1235706
Welsh Corgi
Welsh Corgi
Posted Friday, January 13, 2012 9:09 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 6:19 AM
Points: 3,833,
Visits: 4,052
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
wolfkillj
wolfkillj
Posted Friday, January 13, 2012 9:30 AM
Right there with Babe
Group: General Forum Members
Last Login: 2 days ago @ 6:54 PM
Points: 721,
Visits: 1,375
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?
Post #1235773
« Prev Topic
|
Next Topic »
17 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
