Multi select in Report Setup

Hi All,

I have a report which requires parameters of Season and Production Season, the second based on the first. Problem is that both of these need to be multi select. If I make Season multi select, it has to be a text field, which doesn't work for the WHERE clause of parameter 2, Production Season.

I tried to create a View, but couldn't get it to convert the text field passed from the Season parameter, to do the select on the Production Season.

Has anyone successfully done this?

Thanks, Debbie