Oracle Reports Documentation for General 7.1

Comments or suggestions? Please email Dave Midgett at:

The documentation on this page should be considered as a supplement to the FAQ's provided by SCT. You should read and thoroughly understand the configurations suggested by SCT before making a decision as to what is best at your Institution. Just because Eastern Kentucky University is doing something one way, doesn't make it the best solution or make it the right solution for your institution.

Taken from SCT's FAQ's here's a step by step guide I've created for our own internal use to getting 10gAS installed and configured.

This Install guide is for Win 2003 Server ONLY

Important configuration information on using Netscape/Firefox with Gen 7.1 is also included

Date Posted: 05/26/2005
Revisons: 6/2/2005 -- Added info regarding a port conflict when using the Sun Java Plug-In

Installing 10gAS and configuring Forms/Report servers

It's impossible for SCT to satisfy everyone's needs or desires when it comes to running Oracle Reports. SCT decided to insert parameter records for the report object properties set with parameters 71-76 for all reports. These records are then read and displayed in the Parameter Values section of GJAPCTL. When F10 is pressed, these records are then re-read and then deleted.

I don't particularly care for that concept. 99% of our reports were written to use parameter forms and there really is no need for our users to see these report object property parameters when they run a report and would probably generate calls to our Help Desk when changing these parameters have no effect on how the report runs.

So I decided to turn this feature off, while still allowing the capability of over-riding the defaults by entering the appropriate parameter number (71-76) in GJAPDEF for individual reports.

WARNING If you implement the coding modifications I made to GJAPCTL, you may need to define parameter 71-76 for the reports delivered by SCT.

I also added code that allows us to use the report scheduling feature of Oracle Reports.

Date Posted: 05/26/2005
Revisions:

Modifications I made to GJAPCTL.fmb

Modifying Oracle Reports

Date Posted: 05/26/2005
Revisions:

Whether you're migrating from Version 6.x INB or Client/Server, whether you use SCT's goqorep.pll or mine, extensive changes will be required to your Oracle Reports for them to run in General 7.1.

I created documentation for our progammers detailing the coding modifications needed for our reports to run. You can download it here.

Sample reports

I created these sample reports for our programmers to use as guides as they modify our Oracle Reports to run in Banner 7.1. 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 you must add the reports to banner security and gjajobs.

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. Parameter 01 must be defined in GJAPDEF which is the DeptNo from the scott.dept table.

Generate report output using parameters defined in GJAPDEF: gxjnprm.rdf

These examples show how to modify the Before Parameter Form trigger in existing reports 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