I am having a strange problem with cascading parameters. I have a report based on a table that has a bunch of medical procedures in it and each procedure belongs to a specific category. I want to select the category and then select from the procedures in that category. I have a dimension table ljoined to the transaction table (left join from the transactions to the dimension table) that is a simple list of all valid procedures with their categories. When I create the dynamic cascading parameters, I first enter Proc Category from the transaction table as the first value and create the parameter and then below that I enter Proc Code from the transaction table and create the parameter. Both are set as multiple selection parameters. However, when I preview and see the parameters I am only seeing two of the categories (there are many of them) and can therefore only select procedures belonging to those two categories. I don't have any filters in anything that would limit the data to those two categories. It is completely weird.

Edited by dbodell - 27 Dec 2011 at 11:50am

Thanks HCH very much. It seems that the problem is resolved  by not using multiple selections on BOTH parameters. In other words, it worked when I selected only 1 procedure category at a time and then selected multiple procedures from there. It should work with both levels being multiselect but perhaps it is thinking that the second level has to be in ALL of the categories selected instead of ANY of the categories selected.