I have a requirement to develop a new report..
The report is called from a form.The report contains two data models with two queries(the queries are based on two tables which are having same structure).
Based on the form buttons this report will execute and gives the excel output.
The thing is that there are two buttons,each button associated with the query in the report.There is a parameter will be passed if we press the button.Based on the value of the parameter the associated query has to execute.
So, when we pass a parameter to the report builder from the form ,how to select the associated data model based on the parameter passed when the button pressed.if there is layout model then we can write the code in format trigger.but there is no layout model here.
How to pick the required data model based on the parameter passed.
Thanks in advance....
You can add an extra line in the where clause for the two queries. For query 1:
and :p_param = 'query1'
This will return no rows if p_param = 'query2'.