Have a Wetpaint account? Sign in
Oracle Reports
Oracle Reports is a reporting tool for producing pixel-perfect PDF output. It also supports other formats like HTML, RTF and XML. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server).
Oracle Reports is not being actively developed anymore, but is covered by Oracle Lifetime support (no forced migration). The strategic reporting product for Oracle in Fusion Applications is Oracle BI Publisher.
Pro
With a very sophisticated format model, an experienced developer can build just about any conceivable report with pixel precision. Report triggers allow the report developer to specify PL/SQL to be executed at specific points during the execution and formatting of the report (e.g. before report, between pages). Format triggers allow the developer to specify PL/SQL to be executed before the formatting of individual items (i.e. the formatting attributes of every object can be changed dynamically).
Oracle Reports contains good wizards that allow a beginner to quickly produce fairly good-looking reports, and comes with very good documentation outlining how to produce a wide variety of reports.
The reports server contains scheduling and caching of reports, and it is possible to start reports programmatically (for example from a database trigger).
Con
Oracle Reports is a power tool with a steep learning curve. The user interface for modifying reports is not obvious and most beginners are unable to make more than trivial changes without formal training or access to an experienced Oracle Reports developer.
Not a strategic product for Oracle anymore - don't expect any new features.
More Info
Refer to the Oracle Reports page on OTN for more information.
Oracle Reports is not being actively developed anymore, but is covered by Oracle Lifetime support (no forced migration). The strategic reporting product for Oracle in Fusion Applications is Oracle BI Publisher.
Pro
With a very sophisticated format model, an experienced developer can build just about any conceivable report with pixel precision. Report triggers allow the report developer to specify PL/SQL to be executed at specific points during the execution and formatting of the report (e.g. before report, between pages). Format triggers allow the developer to specify PL/SQL to be executed before the formatting of individual items (i.e. the formatting attributes of every object can be changed dynamically).
Oracle Reports contains good wizards that allow a beginner to quickly produce fairly good-looking reports, and comes with very good documentation outlining how to produce a wide variety of reports.
The reports server contains scheduling and caching of reports, and it is possible to start reports programmatically (for example from a database trigger).
Con
Oracle Reports is a power tool with a steep learning curve. The user interface for modifying reports is not obvious and most beginners are unable to make more than trivial changes without formal training or access to an experienced Oracle Reports developer.
Not a strategic product for Oracle anymore - don't expect any new features.
More Info
Refer to the Oracle Reports page on OTN for more information.
|
vesterli |
Latest page update: made by vesterli
, Jan 9 2009, 1:46 AM EST
(about this update
About This Update
13 words added view changes - complete history) |
|
Keyword tags:
reports
More Info: links to this page
|
| Started By | Thread Subject | Replies | Last Post | ||
|---|---|---|---|---|---|
| aminkhan77 | How to get report Server Name and Environment ID in Report | 1 | Mar 4 2009, 7:52 AM EST by luciofer | ||
|
Thread started: Mar 4 2009, 12:52 AM EST
Watch
How to print report Server Name and Environment ID in Report 10G.(Through in package or others)
I'm also using Oracle Application Server 10G. |
|||||
| KenW77 | Reports Length | 0 | Dec 5 2008, 11:29 AM EST by KenW77 | ||
|
Thread started: Dec 5 2008, 11:29 AM EST
Watch
Is it possible to extend the length of a report downward beyond the 105 mark in Oracle Reports 6i?
Do you find this valuable?
Keyword tags:
Reports Length
|
|||||
Showing 2 of 2 threads for this page


