We have report definition on our work table which as almost 12lac records. We have exposed this report to manager with some criteria.We have added customfilter criteria section in report definition. Wrote custom activity which will Call Rule-Obj-Report-Definition.pxShowReport OOTB activity to launch the report definition. We have invoked custom activity in open url in window control. System is taking lot of time to lunch window as it is loading the report definition with blank criteria. Which is trying to bring entire data.
Do we have any parameter or option to disable the report execution on launch and execute only when user click the apply filter button.
***Edited by Moderator Marissa to update platform capability tags****
If you want your report to run only with some filter criteria by default, then I would suggest to add default filters on the report to fetch only few records like last 7 days or one day. When the manager user changes the filter, they can modify them the way they want.
We have removed join with work table and moved all the report required columns to index table. Created report defination in index class and Defaulted initial load criteria with one day, with this changes currently report is launching quickly.