Solved

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

Posted on 2011-09-19
8
276 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
  • 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
 

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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now