Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.
We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received the following error: Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.
If there's a better way to write the query, update properties, or run the report - we are open to any suggestions
I tried running it with Schedule and it populates a blank report. I also tried making the following changes to the report per Maximum Report Data Size for Offline or Online Reports Exceeds the Limit (Doc ID 2816218.1)