Set report to deferred execution - Unable to save the settings

Content

Hi,

We have a report that is very useful for the Knowledge managers and they do not want any changes to that. We have optimized it to the extent possible but at times they get the error "The report could not be processed because it exceeds the query size limitation. Please reduce the amount of data processed by report. Would you like to queue the report with current search criteria?"

When they queue the report it takes a lot of time to return the results and they don't like it. As an interim solution we uncheck the option "Set report to deferred execution" which works for them but after few runs they again get the option to queue the report and we again have to reset the "Set report to deferred execution" option which is not a good experience for our end users.