|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/a7f9d01787d766ca3ecf0d633906c5f0?s=64&d=mm&r=g) |
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.
|
|
|