Is there a way to set a variable :P2_SHOW_DATA in the where IR condition by clicking the button(DA)?
...
where ...
and :P2_SHOW_DATA = 'Y'
DAN_71Contributor
Set item for where condition via DA
2 Answers
You must login to add an answer.
Vinish
To use the SQL queries conditionally, you should use Function returning SQL query as IR source. Check the following tutorial:
IR Report Dynamic SQL Query in Oracle Apex
DAN_71
Thank you very much, I know this way, but I was thinking of something like set value and submit.