Solution Properties
Solution ID:
200519142611293
Last Modified Date:
Mon Mar 10 14:03:34 UTC 2025
Taxonomy Path:
Case category//I have a problem with...//a report
Author:
[email protected]
Error: 'The report could not be generated. No data was returned for this Report'
Description

When running reports, the following message appears when there is no information to report on for the criteria given:

Cause
Resolution

Table of Contents

The information doesn't exist

If you run a report to show information that doesn't exist on your system, this message appears.

For example:

  • You're running an invoice report but there are no invoices in the data
  • You run an Aged Debtors report for a customer with no outstanding transactions
  • You run a Sales Credit Day Book report for a customer without any SC transactions on their account
  • You run a product activity report for a product with no transactions
  • You run a Customer Statement report and select an outstanding item only layout, but the customer account doesn't have any transactions outstanding

Incorrect records selected

Only items you've highlighted within the module will appear on the report.

For example, if you highlight one or more invoices and run a report, the results will show that selection only.

If the highlighted records don’t meet the report criteria, the message appears.

To resolve this, check you've highlighted the correct items, or click the Clear button to deselect any highlighted records.

You've applied a search

When you apply a filter or search to the module, the report runs for the data displayed in the filter or search.. Find out more in our How do I filter my lists? guide.

For example, if you apply a filter to remove customers with an outstanding balance, running the Aged Debtors report will show the error.


To resolve this, remove the search, or change it to show the information you want to report on.

Check your regional settings 

This can occur if the date is in an American format for , 11/01/2022 instead of 01/11/2022. 

Check your computer date format is English (United Kingdom).

Check your report settings

If you have a multi-user licence, check where the software is looking to pick up your reports.

  1. Click Settings, then click Company preferences.
  2. Click Reporting.
    • If you hold your reports in your data directory, check the Use data path for reports checkbox
    • If you store your reports in the standard settings directory or haven't changed their location, clear the Use data path for reports checkbox
  3. Click OK.

 TIP: Run the report again. If it has criteria, narrow the parameters or run one criterion at a time to isolate the problematic data.

Speed issues

When you run a report or layout to preview, a delay in generation time may cause an error message to appear.

Use our troubleshoot speed issues with reports and layouts article to check and resolve this.

Check your customers default delivery address

NOTE: This is only available in Sage 50 Accounts Standard and Professional.

  1. Open the customer's record, then click Addresses & Contacts.
  2. Click Preferences.
  3. If the Deliveries drop-down list shows none, change this to Registered address.
  4. Click OK, click Close, then click Save.

Repeat this process for all required customers.

Check your suppliers default delivery address

NOTE: This is only available in Sage 50 Accounts Standard and Professional.

  1. Open the supplier's record, then click Addresses & Contacts.
  2. Click Preferences.
  3. If the Deliveries drop-down list shows none, change this to Registered address.
  4. Click OK, click Close, then click Save.

Repeat this process for all required suppliers.

Download the fixed reports

  1. Click the relevant layout you want to download below.
  2. If prompted to save the file, browse to where you want to save the file, then click Save.
  3. Browse to and right-click the downloaded file, then click Copy.
  4. On the menu bar click Help, then click About.
  5. Under Program Details, click the Data Directory path.
  6. Open the Layouts folder and right-click and paste in the downloaded layout file.
  7. Run the new layout from your software.

Statements

Copy of 2008 STATOSA4.LAYOUT

Copy of 2008 STATASA4.LAYOUT

Invoice

Copy of INVPLAINA4.LAYOUT

A blank Chart of Accounts

Management reports need a Chart of Accounts with information. If the chart of accounts is blank, this message appears.

To resolve this, identify and correct errors in your chart of accounts.

Check your report filter

If you use a customised report, there could be a filter on it that prevents the report from running.

Try removing your filter, then re-create it. You can use our Create or edit a filter on a document article to do this.

Contact us

If you've completed the steps in this guide, contact Sage Technical Support for further help.

 

[BCB:19:UK - Sales message :ECB]











Steps to duplicate
Related Solutions