Hello All, can anyone advise how we can stop initial load (execution of ) Interactive Report Query, instead i want the user to enter any of custom filter value and when he clicks on Apply filter button, query should get executed and gets data. Note that non of the filters are mandatory.
I tried with a hidden item. I set the value to N and on click, making the value to Y. and use the where item1 = 'Y'. But somehow its not working
Also i tried with below, not helping
where exists (select 1 from apex_appl_page_ig_rpt_filters f join apex_appl_page_ig_rpts r on r.report_id = f.report_id where f.APPLICATION_ID = :APP_ID and f.page_id = :APP_PAGE_ID and r.session_id = :APP_SESSION)