[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2011-09-19
8
Medium Priority
?
284 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
Independent Software Vendors: 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
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…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

656 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