Solved

How to filter results on drop down of lookups?

Posted on 2011-03-21
4
609 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

785 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