Solved

How to filter results on drop down of lookups?

Posted on 2011-03-21
4
616 Views
Last Modified: 2012-05-11
I have a large dataset and want to apply a parameter that lets me filter by selecting from a drop down of county names.  I created a secondary dataset with just the county names. The drop down works perfectly, but it doesn't actually filter anything. I am missing some critical tie between the drop down list (County parameter) and the RES_COUNTY field in the dataset.

Am looking to filter on RES COUNTY by the list of drop down options for COUNTY (added to the dataset exclusively to create a clean drop down).  Any ideas?
View of Report Data Pane showing drop down Properties for Parameter Look Up Drop down works great but not tied to RES COUNTY
0
Comment
Question by:gberkeley
  • 2
4 Comments
 
LVL 27

Assisted Solution

by:planocz
planocz earned 150 total points
ID: 35182587
have to tried passing your parameter back to your query and have the query select only that county to view in your report?
0
 

Author Comment

by:gberkeley
ID: 35182932
I am not sure I understand your answer. How would one "pass a parameter back to the query"?I
If it means what I think you mean then I don't think this answer meets the requirement. I want to be able to run the report - select one county at run time and then run it again on another and another.

It seems overly cumbersome to go back to the query and limit the query to only one county each time I need to run the report.

0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 350 total points
ID: 35187118
What planocz is saying is that you should modify the query for the ConsumerSvc... dataset.  It should accept the County parameter that you've set up.

To do that, open up the Dataset properties and add a WHERE clause to your SELECT statement (assuming that you've currently set up a SELECT without a WHERE clause).

The syntax is like this:
WHERE RES_COUNTY = @county

The next step is to open up the Parameters page of the dataset properties and link the parameter in your query to the parameter in your report.  To avoid typos, you can use the dropdown in the Parameter Value to select your report parameter.

Hope that clarifies it a bit?
0
 

Author Closing Comment

by:gberkeley
ID: 35189320
Another challenge conquered!!! Thanks very much to you both.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question