Email Us : sunilkumark11@gmail.com
Free Training > SQL PL / SQL Forms Reports Oracle Applications
< Previous Next >

 
Reports - Introduction of Oracle Reports

Used to display data in arranged format for read only purpose.

Report Interfaces ( screens )

1. Object Navigator
2. Data Modal Editor  -- Used to create reports manually.
3. Layout Editor  -- Used to design the report.
4.Property Palette -- Used to specify properties
5. Live Preview -- Report format is displayed
6. Run time preview -- Final output is displayed.
7. Parameter form  -- Used to accept arguments from user.

Report Styles
1. Tabular  --  Displays report in tabular format.
2. Form like  -- Displays one record per page.
3. Mailing labels -- Used to print address in label format.
4. Form letter -- Used to prepare letters.
5. Group Left -- Used to arrange grouped results.
6. Group Above  -- Used to arrange grouped results.
7. Matrix -- Used to display reports in rows and columns.
8. Matrix with group  -- Used to display reports in rows and columns with grouping columns.

Reports are saved with extension .RDF
RDF stands for report definition file.
After compilation of RDF file, .REP file is generated.

File extension in Oracle developer 10g

Objects

File Extensions

Forms

FMB /  FMX / ERR

Menus

MMB  /   MMX

PL/SQL Libraries

PLL  /  PLX

Object Libraries

OLB

Oracle Graphics files

OGD  /  OGR

Oracle Reports

RDF  /  REP

SQL Scripts

SQL

Iconic files

ICO

Report Template definiton file

TDF

Short cuts


Shortcuts

Save

Ctrl + s

Compile

Ctrl + t

Run

Ctrl + r

 

 


 


< Previous Next >