Oracle Reports

Last updated

Oracle Reports is a tool for developing reports against data stored in an Oracle database. 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).

Contents

Output formats

The report output can be delivered directly to a printer or saved in the following formats: HTML, RTF, PDF, XML, Microsoft Excel

History

Oracle RPT

Oracle RPT was an early, primitive predecessor to SQL*Report Writer. There was no editor or IDE provided and instead the reports were created by editing text files to control the report output.

SQL*Report Writer

Oracle Reports 1

Oracle Reports 2.0

Oracle Reports 2.5

Release April 1995. New Object Navigator. New Toolbars. New Menus.

Still no undos.

More stable IDE.

Oracle Reports 6i

New features added in 6i: [1]

Oracle Reports 9i

New features added in 9i: [2]

Oracle Reports 10g

New features added in 10g: [3]

Related Research Articles

Microsoft Access Database manager that is part of the Microsoft Office package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

C++Builder is a rapid application development (RAD) environment, originally developed by Borland and as of 2009 owned by Embarcadero Technologies, for writing programs in the C++ programming language targeting Windows NT, macOS, iOS and Android. C++Builder combines the Visual Component Library and IDE written in Object Pascal with multiple C++ compilers. Most components developed in Delphi can be used in C++Builder with no or little modification, although the reverse is not true, but this constraint is valid only for source code. Binary code generated by Delphi can easily be linked to binary code generated by C++Builder and vice versa to generate an executable written in both Object Pascal and C++. With this approach, C++ can be called from Object Pascal and vice versa. Since both Delphi and C++ use the same back end linker, the debugger can single step from Delphi code into C++ transparently.

WebObjects Java web application server and framework originally developed by NeXT Software

WebObjects is a Java web application server and a server-based web application framework originally developed by NeXT Software, Inc. As of 2009 the software has been independently maintained by a volunteer community.

Oracle Forms is a software product for creating screens that interact with an Oracle database. It has an IDE including an object navigator, property sheet and code editor that uses PL/SQL. It was originally developed to run server-side in character mode terminal sessions. It was ported to other platforms, including Windows, to function in a client–server environment. Later versions were ported to Java where it runs in a Java EE container and can integrate with Java and web services.

JDeveloper integrated development environment

JDeveloper is a freeware IDE supplied by Oracle Corporation. It offers features for development in Java, XML, SQL and PL/SQL, HTML, JavaScript, BPEL and PHP. JDeveloper covers the full development lifecycle from design through coding, debugging, optimization and profiling to deploying.

Uniface (programming language) Fourth-generation programming language

Uniface is a development and deployment platform for enterprise applications that can run in a large range of runtime environments, including mobile, mainframe, web, Service-oriented architecture (SOA), Windows, Java EE and .NET. Uniface is a model-driven, Rapid Application Development (RAD) environment used to create mission-critical applications.

XMLSpy XML editing integrated development environment

XMLSpy is a proprietary XML editor and integrated development environment (IDE) developed by Altova. XMLSpy allows developers to create XML-based and Web services applications using technologies such as XML, XBRL, XML Schema, XSLT, XPath, XQuery, WSDL and SOAP.

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS.

Oracle XML Publisher (XMLP) is Oracle Corporation's latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. Osama Elkady from the Applications Technology Group and Tim Dexter from the Financials Group were the main drivers for the product. It was first released with Oracle E-Business Suite 11.5.10 in 2003. Since then it has been integrated into most of Oracle Products including JD Edwards EnterpriseOne application 8.12 and PeopleSoft Enterprise 9, and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.

PeopleTools consists of proprietary application software originally developed by PeopleSoft Corporation, an Enterprise Resource Planning (ERP) software vendor acquired by Oracle Corporation in 2004. PeopleTools facilitates the deployment of both vendor-developed and custom-developed applications using an Internet-based architecture known as the PeopleSoft Internet Architecture (PIA).

Azure DevOps Server is a Microsoft product that provides version control, reporting, requirements management, project management, automated builds, testing and release management capabilities. It covers the entire application lifecycle, and enables DevOps capabilities. Azure DevOps can be used as a back-end to numerous integrated development environments (IDEs) but is tailored for Microsoft Visual Studio and Eclipse on all platforms.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Oracle SQL Developer

Oracle SQL Developer is an Integrated development environment (IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.

ActiveReports

ActiveReports is a .NET reporting tool used by developers of .NET Core, MVC, JavaScript, WinForms, and ASP.NET applications. It was originally developed by Data Dynamics, which was then acquired by GrapeCity. ActiveReports is a set of components and tools that facilitates the production of reports to display data in documents and web-based formats. It is written in managed C# code and allows Visual Studio programmers to leverage their knowledge of C# or Visual Basic.NET when programming with ActiveReports.

I-net Crystal-Clear

i-net Clear Reports is a Java-based cross-platform reporting application providing a report designer and a server component to create reports in numerous output formats like PDF, HTML, PS, RTF, XLS, TXT, CSV, SVG, XML, as well as being viewable in a Java applet or Swing component. Application programmers can integrate i-net Clear Reports using the public API which spans over 200 classes. Starting with release 11.0 i-net Clear Reports also supports the .NET programming language and offers a public API for further integration in other products.

FarPoint Spread

This article refers to the last FarPoint Edition of the Spread Product line. Spread is now developed by GrapeCity, Inc. Since the acquisition, Spread for Biztalk Server has been removed from the product line and SpreadJS, a JavaScript version, has been added.

List & Label is a reporting tool for developers to enable the design and print of reports in desktop, web and cloud applications on Microsoft Windows plattforms. It supports data sources and development environments such as Microsoft Visual Studio and Embarcadero RAD Studio. List & Label supports frameworks and programming languages such as .NET Framework/.NET Core with C Sharp, Visual Basic, Visual Basic .NET, C++, Delphi, Java and many more. Reports are designed in the interactive Designer and can then be exported to formats such as PDF, Excel, XHTML and RTF. For the custom preview format, a free viewer application is available. The Designer can be used by end-users royalty free with all paid editions of List & Label.

Scriptcase

Scriptcase RAD is a development platform for PHP applications, is web oriented and can be installed in a server in the internet. It acts as a platform for developers and allows them the use of a graphical interface directly through a web browser to automatically generate the codes. It was developed by NetMake in the year 2000. Can be used on Mac, Windows, and Linux operating system.

Oracle TopLink is a mapping and persistence framework for Java developers. TopLink is produced by Oracle and is a part of Oracle's OracleAS, WebLogic, and OC4J servers. It is an object-persistence and object-transformation framework. TopLink provides development tools and run-time functionalities that ease the development process and help increase functionality. Persistent object-oriented data is stored in relational databases which helps build high-performance applications. Storing data in either XML or relational databases is made possible by transforming it from object-oriented data.

References

  1. "New Features in Oracle Reports Developer and Reports Server 6i" (PDF).
  2. "Oracle9i Reports New Features" (PDF). Archived from the original (PDF) on 2006-09-28.
  3. "Oracle Reports 10g Release 2 (10.1.2) New Features" (PDF). Archived from the original (PDF) on 2006-09-25.