Troubleshoot problems with data not displaying in a report

There are several possible reasons why data that you expect to be in a report does not appear:

  • Insufficient security permissions. If you don't have permission in Common Data Service to view a record, it will not appear in the report.

  • Data is not entered. The person entering data may have left fields empty.

  • Data does not match the criteria for the report. Many reports include a default filter that displays only active records, or you may have selected criteria that don’t have any matching record. Try changing the report filter. For more information, see Edit the default filter of a report

  • You may be viewing a cached copy of the report. By default, data in Common Data Service reports is pulled from the database each time you run a report. However, your system administrator may have changed a report to run from the cache. If data you entered recently is not included in the report, you may have an older version of the report from the cache. To refresh the report, on the Report toolbar, select the Refresh button.

  • You may not have permission to read records in a sub-report. If you do not have permission to read record types that are included in a sub-report, you will get an error message saying that the sub-report could not be displayed.

  • Your Microsoft Internet Explorer privacy settings may block required cookies. For chart reports, if instead of seeing the chart, you see a red letter X, your privacy settings may be blocking a cookie that is required for the chart control. To fix this problem, in your browser, enable cookies for the server that is running Reporting Services.

See Also

Work with reports

Create a report using the Report Wizard

Add a existing report

Edit report filter