The information in my documentation is based mainly on Oracle docuementation contained in Integrating Oracle9iAS Reports in Oracle9iAS Forms
This documentation (inbserver.doc) last updated on : 02/23/2005
Server, gjapctl and report modfifications Documentation
The above document is the same document distributed with the PPT for session 019 - Using Oracle Reports in INB at the Summit conference in Honolulu.
Sample reports
All of these reports uses the scott.emp and scott.dept tables to create a simple report. You must create public synonyms for the emp and dept tables. To run these reports in Banner (Client/server or INB), you must add the reports to banner security and gjajobs.
These examples show how to modify the Before Parameter Form trigger in existing reports that are currently running in Client/server mode to generate the desired output in INB. The code modifications allows the report to run in both client/server and INB from the same rep file.
Example not using Oracle Report Parameter forms and displaying output in various formats: gxjnprm.rdf
Generate report output to a pdf displayed in browser: gxjpdf.rdf
Generate report output to Excel: gxjxcl.rdf
Generate report output to Word: gxjword.rdf
Generate output for a fixed format text file: gxjfile.rdf
This example shows how to create a report that uses parameters defined in GJAPDEF. This report also uses the scott.emp and dept tables. Parameter 01 must be defined in GJAPDEF which is the DeptNo from the scott.dept table. You will also need to define the 71-76 parameters (see documentation) as needed.
Generate report output using parameters defined in GJAPDEF: gxjnprm.rdf
These examples show how to modify the Before Parameter Form and After Parameter Form triggers in existing reports that are currently running in Client/server mode that generates a report for viewing and generates output to Word/Excel. These modifications make use of a javascript developed by John Cigas, Computer Science professor at Rockhurst University and Dave Midgett.
Generate report output to pdf/Excel: gxjjxcl.rdf
Generate report output to pdf/Word: gxjjrtf.rdf
The following report is an example of how to create bookmarks in PDF files. This example works in INB and also in Client/Server mode. In C/S mode, you have to run the report, click the Generate to PDF file option, and the re-run the report. This report is *solely* provided as an example of the techniques involved.
The following report is an example of creating an Oracle Report that generates an html report with hyperlinks to run other reports: fbjddmg.rdf
