|
Re: Passing DATA_PARAMETER in Oracle Reports 10g from Oracle Forms using RUN_REPORT_OBJECT [message #611724 is a reply to message #609562] |
Tue, 08 April 2014 00:56 |
|
sankalputtara
Messages: 53 Registered: January 2011 Location: Bangalore
|
Member |
|
|
Reports 6i we had an feature of passing DATA_PARAMETER - A VARCHAR2 string specifying the name of a record group defined in the current form When Form Builder passes a data parameter to Report Builder, the data in the specified record group can substitute for a query that Report Builder would ordinarily execute to run the report or display.
Since this feature is not available in Oracle Reports 10g (Passing data_parameter) we need to take an alternative approach and the best, efficient way to achieve this would be by making use of a temporary(Staging) table instead of record groups.
Build query based on these tables instead of record groups in report.
|
|
|