Troubleshoot speed issues with reports
Description

When you run a report to preview, there can be a delay to generate or the following error message appears:

'The report could not be generated. No data was returned for this Report.'

Cause
Resolution

Before you start

Ensure the software isn't running in compatibility mode:
  1. Right-click the software icon on your desktop and select Properties.
  2. Select the Compatibility tab and deselect the Run this program in compatibility mode for: checkbox if selected.
Run this program in compatibility mode highlighted in the Properties tab.

If the issue persists

▼ Running reports over a network

Reports can run slowly when accessed over a network. You can run your reports from your local machine to improve speed.

  1. On the menu bar, go to Settings then Company Preferences.
  2. Select the Reporting tab.
  3. Deselect the Use Data Path for Reports checkbox, then click OK.
  4. If required, copy the report to your local computer.
  5. Run the report and check the speed.
  6. On the menu bar, go to Settings then Company Preferences.
  7. Select the Reporting tab.
  8. Deselect the Use Data Path for Reports checkbox, then click OK.

If the report runs locally, follow our article to troubleshoot any performance issues.


▼ Run the report for a smaller selection

Try running the report for a smaller number of records.


▼ Restore the reports only backup

If you experience issues with standard reports, you can restore the reports and layouts only backups.


▼ Check your data
  1. On the menu bar, go to File then Maintenance.
  2. Select Check Data.
  3. A message appears informing there are no problems. Click OK.

    If problems exist with your data, the File Maintenance Problems Report appears. To fix any issues, click How to fix errors & warnings in your Sage data or visit sage.co.uk/mydata.
  4. Click Close then Close again. 

▼ ERROR: 'No data was returned for this Report'

This message appears whenever there's no information found for the criteria given.

Follow the steps on our Error: 'The report could not be generated. No data was returned for this Report' article.

 


Steps to duplicate
Related Solutions