Question
EY El Salvador
SV
Last activity: 7 Mar 2019 14:30 EST
Set default filtering for past two years counting from current date
We have a requirement in which the business needs to display cases from the past two years based on a date property. For example if I'm generating the report on March 07,2019 it should display cases from March 07,2017 until today. Also the user should be able to expand the date range to show all cases or any other range.
Any idea or suggestion in how to do this?
I added a filter where I calculate the difference in days with the current date and if it less than 731 days then the row is included and hid the filter. I thought that the out of the box filtering for that column would override to let the user modify the range but I was wrong.
Pegasystems Inc.
IN
Hi Carlos,
You have two options to achieve this:
1. you can create a custom section where you can let the customer define the date range and use this date range to filter the results in the Report Viewer:
2. You can allow user to change the filter value that you have set in the RD using the below option:
