I have a report that looks at a number of regions. You can select a region by selecting from a drop down list. The report then gives you information specific to that region. I would like to send this model out to the different regions for use there, however, I need a way to make sure that the only options that each region will have in their drop down menu is their region and nobody else's. How can I create a drop down list which will be user dependant?
A curve ball I know, but all help is greatly appreciated.