Converting a crystal report to SSRS. The CR has a set of cascading parameters that when a user clicks on the first drop down list, a list of all available companies is shown, the user selects one company from the drop down. Once they select the company, the second parameter populates the list of projects for the company selected. As you can see the second parameter also allows multiple selections. How can I recreate these two parameters in SSRS? I know I could use the parameter type of ‘dropdown list’ powered by a BAQ listing all companies, but the real trick is then having that selection show the list of projects. I found a parameter type of ‘Item List’ that allows multiple selections but the problem is it does not show a dynamic list of values I can select from, I have to know the projectID to input it into the list.
Any Help is appreciated, Thank you!
