Introduction
Interactive reports are very powerful reports. The end-user can set filters, highlighting, add computed columns, do control breaks or groupings, and much more.
As a developer, you might sometimes have the requirement to redirect from one page to another, which displays an interactive report, but this report should be filtered by whatever value is selected on the first page.
Steps to follow
- Give a Static ID for the IR region
- Use RIR in the ClearCache Section to reset to the default Interactive Report (clear all filters, formats, …) on the target Page
3 .Use CIR to clear all report settings
- Syntax:
IR<operator>_<column_name> where operator can be EQ,LT,GT,LTE,GTE,NEQ,LIKE,N,NN,C,NC
you can omit the operator if you want to use “equal” as operator
Example:
f?p=&APP_ID.:58:&SESSION.::&DEBUG.:CIR:IR[CONT]IN_NEGOTIATOR,IR[CONT]IN_COUNTRY,IR[CONT]_STUDY_NUMBER:\&P1_NEGOTIATOR_DISP.\,\&P1_COUNTRY_DISP.\,&P1_STUDY_DISP.
Call To Action:
For Oracle apex development and customization please do contact our company website https://doyensys.com/
Conclusion
Thus using the above steps we can pass the parameters through URL and set the filter for the interactive report.
