About Report

What is report?

To get answers to questions like these, you'll want to generate a report. There are lots of ways you can query, filter, sort and group your data to give you the answers you're looking for. Then output those results in any format that works best. For example, you're not stuck displaying tasks in a chronological list. Try presenting them in a calendar or timeline instead.

Reports let you:

v      Specify which records you want to see. Filter out some of your records (by specifying matching values to use). Visiting the in-laws in Woonsocket? Use Woonsocket or nearby area codes as matching criteria that will return a list of the clients in the area you could visit while you're there.

v      Order those records exactly as you want. Specify how records are sorted or grouped. You could order that list of clients alphabetically or by how much each one has purchased from you.

v      Design the layout and set colors to suit your purpose. Not only can you choose from a variety of formats (see list of links below) you can customize the layout and look of each of those formats. Rearrange and resize columns. Change the colors and labeling of charts in a snap.

v      Ask the user what information they seek. You don't need to decide everything. Perhaps you'd like to give your application users an opportunity to choose what company's data they want to see. Or what quarter's sales they need to track. If so, look into creating a report that prompts users to enter criteria, then displays the results.

Introduction to Oracle Reports Builder:

Oracle Reports Builder is a powerful enterprise reporting tool used to build reports that dynamically retrieve data from the database, format, display and print quality reports. Reports can be stored in File or Database (Report Builder Tables).

This discusses the basic techniques that a successful Oracle Reports developer should know. It is intended for the novice user with strong SQL-PL/SQL knowledge who is interested in learning to use Oracle’s Reports Developer.

Reports Developer Basic Tools

To start using Reports Developer, you need the software, a database, and a set of templates. Although Oracle provides a set of templates.

Report file storage formats

.rdf Report 

.rep Report

.rdf Report

•          Binary File Full report definition (includes source code and comments) 

•           Modifiable through Builder. Binary, executable Portable if transferred as binary. 

•           PL/SQL recompiles on Open/Run

.rep Report 

•           Binary Run-Only File 

•           No source code or comments. Not modifiable binary, executable. 

•           Report Executables