troubleshooting Question

Report Parameters

Avatar of Auerelio Vasquez
Auerelio VasquezFlag for United States of America asked on
SSRSMicrosoft SQL Server
2 Comments2 Solutions108 ViewsLast Modified:
I have two report parameters, region and state

What I desire is to have all the regions selected by default, which would make all states default.

But if you choose a region only the states for that region show up in the drop down ((by stored procedure)

What's happening is if all regions are selected the drop down for states is only showing for the first region

Ex

ATL is the first region and the states are fl, Nc, al, ga

So if I choose all regions only the states for ATL are showing up in the drop down list
ASKER CERTIFIED SOLUTION
Arifhusen Ansari
Business Intelligence Developer and Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2015

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros