unable to Process Report

Content

Hi,

I get this error when i open report

The report could not be processed because it exceeds the query size limitation. Please reduce the amount of data processed by the report.

There was a fix given in other posts to tick "Set report to deferred execution". if i set that i am getting below error.

The report could not be processed because it exceeds the query size limitation. Please reduce the amount of data processed by the report.
Would you like to queue the report with current search criteria?
if you choose to cancel the report, no data will be returned.