Databases Reference
In-Depth Information
Oracle Reports Developer includes Oracle Reports Builder and Oracle Reports
Services. Oracle Reports Builder is used to develop the report and Oracle
Reports Services executes, distributes, and publishes your reports for
enterprise-wide reporting.
This paragraph has been added just to show you the possibility of integrating Oracle
Reports with Oracle Application Express.
The Oracle report is called as follows:
http://hostname:port/reports/rwservlet?module=example.rdf&userid=hr/
hr@tnsalias&destype=cache&desformat=pdf&p_empid=10
In Application Express, the only thing needed is to deine a substitution variable to
integrate Oracle Reports with Application Express.
Substitution strings use the
&variable
notation. They can be used anywhere in your
APEX application such as in an HTML region or even in a template.
The navigation path for creating a substitution string is
Application Builder
Tab/Edit Application properties/Substitution section
.
Enter
REPORTS_URL
under the
Substitution String
ield.
Enter
http://hostname:port/reports/rwservlet?userid=hr/
hr@tnsalias&P_EMPID
under the
Substitution Value
ield.
The Oracle report can be called by pressing a button. A button is created with the
URL target as follows:
&REPORTS_URL.&module=example.rdf&destype=cache&desformat=
&P1_DESFORMAT.&p_empid=&P1_EMPID
Integration with Cocoon
You may prefer another XSL-FO processing engines, which are Apache Cocoon and
Apache Tomcat. Cocoon is a web framework other than APEX, of course. For full
explanation and a step-by-step approach, follow this link:
http://carlback.blogspot.com/2007/03/apex-cocoon-pdf-and-more.html