SAP Knowledge Base Article - Public

2537517 - Is it possible to add a Dynamic Date Range Filter to a Table report?

Symptom

Is it possible to add a dynamic filter to a date field, e.g.  report needs to pull data from the past week without setting hard/static date filters in the report definition

Environment

SAP SuccessFactors HXM Suite

Resolution

It is not possible to add a dynamic date range in the Report - Table or Ad Hoc reporting.  The closest thing is to make the specific date field that you want to use "User-prompted".  To do this just tick the User-prompted checkbox beside the filter definition in the filter screen selection so that the user running the report is free to enter a specific date range.

Another workaround is to use report type Report - Canvas or the Online Report Designer and report from Live Data. Here it is possible to set a custom dynamic value for date filters in the Filter Designer.

Keywords

dynamic date filter, Ad Hoc, ORD, Report - Table date filter, Report - Canvas date filter, flexible date filter, data from the past week, data for the past month, data for the past year , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HXM Suite all versions