SAP Knowledge Base Article - Public

2790912 - Classic Report - Form List Report Not Displaying Records if using Form End Date in Filters

Symptom

No records displaying in Form List Report if we use the exact PM Form End date in Date options.
End date should be the day after the Form’s End Date

Environment

SAP Successfactors Workforce Analytics

SAP Successfactors Analytics/Reporting

Reproducing the Issue

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

  1. Go to Classic Reporting Page
  2. Select List Views
  3. Click Form List to generate it

Use the exact Form Dates in Date Option Filter

Result: No data displayed in the Report

Form Dates.png

Exact End Date.png

Use the date after Form End Date

Result: Records will display

DateAfter.png

Cause

Configuration of List Reports in Hana using “to_date” which is not including the Form’s end date.

Resolution

Moving forward use the date after the Form End date as filter in the List Report (i.e. Form End Date +1).

Example:

Form End Date: December 31, 2017

Used the report date: January 1, 2018

See Also

2618940 - No report generated through Form List - List Views

Keywords

Form List, List Views, Classic Reporting, End Date, Form End Date , KBA , LOD-SF-ANA-VIE , List View, Spreadsheet & Classic reports , Problem

Product

SAP SuccessFactors HCM Core 1802