Solved

How to filter results on drop down of lookups?

Posted on 2011-03-21
4
636 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

717 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