That seemed like it would be a great solution but nothing is being evaluated prior to sending the query text directly to MySQL. Even typing in the expression box for the dataset query ="select..." returns a MySQL syntax error that it doesn't understand the beginning ="

This would explain why the parameters are not working becasue SSRS is not evaluation the @param, it's just sending the text "@param".

Thanks for the help, any other thoughts?