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.
@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
@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.
@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.
@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.
@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.