Solved

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

Posted on 2011-09-19
8
280 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
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 

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 500 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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSMS Imprt data from Excel 7 29
the way to learn Microsoft BI 13 51
denied execute as 13 33
Estimating my database size 7 21
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

730 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