SQL*ReportWriter (sqlrep) was a general purpose tool for developing and executing reports against the Oracle database. It was designed for application developers who knew the SQL language. Information was entered into SQL*ReportWriter through its fill-in-the-forms interface.
Elements of a report
A SQL*ReportWriter report is made up of the following objects:
- Queries define the data to be retrieved from the database.
- Fields represent column expressions and report calculations from SELECT statements and describe how each is to be displayed.
- Groups contain sets of fields. Groups are used to describe each section or subsection in the report and its relationships, as well as to dictate control breaks for subtotalling purposes.
- Summaries similar to fields, except they display subtotals and grandtotals rather than data directly from a query.
- Texts contain fields, summaries, and parameter references, combined with literal strings, such as titles, and define the final report format.
- Report object defines the page size, margins, parameter form text, comments, security, and history of the report.
- Parameters contain literal values that you supply at runtime to control the behaviour of the report. You can vary the data, routing of the output, and select national language settings.