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

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.
panthiAsked:
Who is Participating?
 
Leo TorresConnect With a Mentor SQL DeveloperCommented:

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
 
Leo TorresSQL DeveloperCommented:

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
 
panthiAuthor Commented:
the source of the report is a stored procedure so should i be creating one stored procedure for each parameter?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Leo TorresSQL DeveloperCommented:

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
 
panthiAuthor Commented:
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
 
Leo TorresSQL DeveloperCommented:

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
 
panthiAuthor Commented:
but how to make this happen, i am not clear can someone give screenshots or examples.
0
 
panthiAuthor Commented:
i need more help that was not useful
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.