Solved

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

Posted on 2011-09-19
8
279 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

789 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