Oracle ReportsThis is a featured page

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.


vesterli
vesterli
Latest page update: made by vesterli , Jan 9 2009, 1:46 AM EST (about this update About This Update vesterli new con: not strategic - vesterli

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.
Do you find this valuable?    
Keyword tags: None
Show Last Reply
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

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)