SAP Knowledge Base Article - Public

2755897 - Table reports and canvas reports inactive users behavior


Do table reports and canvas reports include inactive users?
Inactive users not appearing on as of date report.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


SAP SuccessFactors HXM Suite


Both report types can include inactive users, but they handle them differently.

A few points to consider:

Table Report:

  • Excludes inactive users by default.
  • In the People tab of the editor, you can click People to see the option to include inactive users.
  • Hence to include users marked as inactive in the UDF, 'include inactive users' has to be enabled regardless of the effective date (As Of Date / Date Range) selected at the report's runtime.


Canvas Report:

  • Live Data:
    • Works similar to Table reports - Excludes inactive employees by default.
    • Includes inactive users when the same is specified in the People Scope.
    • Lack of date effectiveness explained in the Table reports applies here as well.


  • Advanced Reporting:
    • Includes all users by default. 
    • Build a test query on employees and their status to see which status categories (e.g. Retired, Terminated) should be included in any filter on inactive users. 
    • The correct categories may vary depending on the instance's configuration.


inactive, users, Ad, hoc, table, report, center, canvas, Live, Data, Detailed, Reporting, Advanced, include, exclude, filter , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To


SAP SuccessFactors HCM suite all versions