SSRS REFRESHING A DOWNDOWN BASED ON ANOTHER DROP DOWN

I have an SSRS Report that has a drop down for storeID and then another drop down for Planogram.  Now each store has x planograms and each planogram is in x stores.

When the user selects a store id, I want the planogram drop down to populate the planograms that are just in that store.

I have a stored proc that take a storenumber parameter with a default value of 0 which returns all planograms or return the planograms for that store.  The stored proc works fine from Query Manager.

When the user selects a store the planogram drop down will not refresh.    I know it is not the stored proc because it returns the correct values when I run it from Query Manager.  

I have checked the auto refresh and always refresh but the planogram drop down continues to display all the planograms.  

Has anybody got any idea of how to force a dropdown to refresh.
sherbug1015Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>When the user selects a store id, I want the planogram drop down to populate the planograms that are just in that store.
Two possibilities come to mind

1.

The planogram data set is a stored procedure where you have not correctly set up a parameter to be the store parameter just selected, and

2.

The parameters section shows planogram then store, instead of store then planogram, so that it won't refresh planogram when store is selected.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sherbug1015Author Commented:
Is there anyway I can see the SQL that is being run when the dropdown changes?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.