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.