Question
Tata Consultancy Services Ltd
IN
Last activity: 25 Jul 2023 21:57 EDT
Fetching the values from Report Defination based on date range inputs
I've created a RD for case information. Now I want to fetch the data based on StartDate and EndDate properties which are defined in section. I tried with Param.StartDate too but haven't got the results. Then I included section in my RD and getting following error:
The error is showing for CustomFilter.StartDate and CustomFilter.EndDate as Not Defined and Invalid comparision.
I'm doing as .pxCreateDateTime >= CustomFilter.StartDate AND .pxCreateDateTime <= CustomFilter.EndtDate.
Can you please help me out?
Accepted Solution
Updated: 27 Apr 2023 5:25 EDT
Bits in Glass
IN
@PriyankaB1930 you can use RD itself. No need to add section to RD. Please check if you have added param.date in parameter tab with datetime as data type
Tata Consultancy Services Ltd
IN
@Anoop Krishna Thanks for the solution. I tried with yours, working fine for me.
But in case of section, I'm giving StartDate and EndDate properties, based on those inputs I need to filter data. How can I achieve this? I want to add section based filteration instead of Param ones.
Bits in Glass
IN
@PriyankaB1930 okay, then you can keep the section the UI, case or landing page and based on the selection in the UI, that dates will be stored in the clipboard. Pass that date as param to this RD.
Updated: 27 Apr 2023 8:12 EDT
Tata Consultancy Services Ltd
IN
@Anoop Krishna I'm calling the section in RD only. Because I want to display this RD in user portal along with Date input fields. So that user will directly select the date range, and will get the filtered results.
Updated: 25 Jul 2023 21:57 EDT
Pegasystems Inc.
IN
@PriyankaB1930 , Can you please share the screenshot of the settings done in the Report Viewer tab of the report definition? Also, check that the properties used in CustomFilter section should be date time fields as pxCreateDateTime expects both date and time.