?
Solved

how to load one parameter based on other in ssrs 2005/2008

Posted on 2011-09-19
8
Medium Priority
?
283 Views
Last Modified: 2012-05-12
Did any one implement ssrs report where on selection on one paramter another paramters values are loaded as dropdown using a stored procedure. Any steps involving this implementation is appreciated.
0
Comment
Question by:panthi
[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
  • 4
  • 4
8 Comments
 
LVL 8

Expert Comment

by:Leo Torres
ID: 36562401

All Posible parameters. should be on one table with Foreign Key. Then have a query that uses the first parameter to filer the values from the second table

These should be helpful  
http://msdn.microsoft.com/en-us/library/aa337169(v=sql.100).aspx

http://stackoverflow.com/questions/1053396/updating-report-parameters-based-on-perameter-selection-ssrs
0
 

Author Comment

by:panthi
ID: 36562420
the source of the report is a stored procedure so should i be creating one stored procedure for each parameter?
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 36562542

You should be able to do it in one proc.. But that is a design question on weather you want 1 proc or 2 procs to handle this process
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:panthi
ID: 36566798
how do i do in one proc lets says i need country, state and city as parameters where when  you select country you get states and then when you select state you get cities?
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 36567056

All the option have to be in a table
With these headers

Country   States_Providence    City
---------  ---------------------   ----------

then you set the boxes to a query like this

Select States_Providence from TableName Where Country = @Country

Where @Country is the parameter entered by user
for city it would be

Select City
from TableName Where Country = @Country and States_Providence = @States_Providence




0
 

Author Comment

by:panthi
ID: 36567139
but how to make this happen, i am not clear can someone give screenshots or examples.
0
 
LVL 8

Accepted Solution

by:
Leo Torres earned 1500 total points
ID: 36567252

I dont have Access to SSRS here.. but when you build a dataset you should be able to create these filters

But you create the table and just add filters to the dataset you should be good
Look at this link

http://arcanecode.com/2010/07/12/adding-filter-parameters-to-sql-server-2008-reporting-services-reports/
 
0
 

Author Closing Comment

by:panthi
ID: 36912865
i need more help that was not useful
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

777 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