When defining a filter collection that contains parentheses for a Report Designer report, sometimes the following error message appears, even if the filter formula is correct:

Syntax error in expression. The number of parenthesis does not match.

This is a known issue in the report execution engine. A fix for this defect is not scheduled because Report Designer is being sunset.

Workaround

Remove a opening or closing parenthesis, save the filter, and then enter the parenthesis again. This normally clears the error and then you can save the filter and run the report.