How do I resolve the "A Query filter contains too many values" error?

This Internal Error is seen when a user selects more than 100 items in a prompt selection. To resolve the error, click OK, refresh the report again, then reduce the number of items in the prompt selection to less than 100.