SAP Knowledge Base Article - Public

2432190 - Table Report returns no data or just header with empty column

Symptom

During creation of a Table Report there is not data in preview or just the header with an empty column.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

Create a Table based on Single, Cross or Multidataset domain, add filters and preview - no data returned or missing data.

Cause

There are multiple possible causes for this behavior:

  • Permissions
  • Filters
  • Columns selected have no data

Resolution

Do the the following steps and if your report returns no data.

  • Permissions issues
    • You may not have permission to view data in the report you are creating.
    • Review your reporting permissions.
    • If you are creating a shared report that contains data you do not have access to, you will not be able to preview data when creating the report.

  • Preview report before applying filters
    • Preview the report prior to adding filters to ensure there is data in each column of the report.
    • Check the Data Mapping document to ensure you have selected columns that are being used.
    • Remove one column of data at a time from the report and then preview the report after removing each column until you get results returned.
    • Filters issue
      • Remove filters from the data set to see if records are returned.
      • If Data is returned with no filters, there may be no data that matches your filter criteria.
      • If rule added in the filter > Check your options when filtering by a rule.
    • Column selected has no data
      • Add the column you want to filter on to your report and preview the report to see what types of data are included in the column.
      • If the report returns no data, then there is no data in the column.

      Keywords

      Empty, Table Report,  Report return no data, report blank, report return only header, RBP, Permissions, missing , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

      Product

      SAP SuccessFactors HCM suite all versions