Oracle Report Designer

1
Oracle Report Designer
2
Introduction
Report Builder merupakan tool untuk membuat
laporan dari data data yang telah kita simpan
dalam database lewat form. Report builder masih
satu paket dengan Form Builder yang telah
kita gunakan.
3
Report Wizard
4
Report Wizard
5
Report Wizard
6
Report Wizard
7
Report Wizard
8
Report Wizard
9
Report Wizard
10
Report Wizard
11
Report Wizard
12
Report Wizard
13
Report Wizard
14
Report Wizard
15
Contoh Report
16
Contoh Report
17
Interface
Interface Oracle Report Builder terdiri dari
4 komponen utama, yaitu Live Previewer, Obyek
Navigator, Data Model, Layout Model,
dan Parameter Form.
Object Navigator
18
Interface
Live Previewer
19
Interface
Data Model
20
Data Model
Query
Group
Kolom
21
Interface
Layout Model
22
Layout Model
Body
Frame
Repeating Frame
Field
23
Interface
Parameter Form
24
Sintax Memanggil Report dgn Form
Run_Product(REPORTS, 'c\aak\ct_bbs.rdf',
ASYNCHRONOUS, RUNTIME, FILESYSTEM, pl, NULL)
25
PROCEDURE Tunj_param IS Pl ParamList BEGIN Pl
Get_Parameter_List('KIRIM') If Not
Id_Null(pl) then Destroy_Parameter_list
('KIRIM') End If Pl
Create_Parameter_List('KIRIM') Message('Report
Process', No_Acknowledge) Add_Parameter(Pl,'P_NIM
', text_parameter, BSS.NIM_BSS)
Add_Parameter(Pl,'P_SMT', text_parameter,
bss.AKTIF_SMT) Add_Parameter(Pl,'P_JSMS',
text_parameter, to_char(BSS.JM_BSS))
Add_Parameter(Pl,'P_JENIS', text_parameter,
BSS.JENIS) Run_Product(REPORTS,
'c\aak\ct_bbs.rdf', ASYNCHRONOUS,
RUNTIME, FILESYSTEM, pl, NULL) END