ROS.60050 ( r
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 8000 ! 8000 " 8000 # 8000 $ 8000 % 8000 & 8000 ' 8000 ( 8000 ) 8000 * 8000 + 8000 , 8000 - 8000 . 8000 / 8000 0 8000 1 8000 2 8000 3 8000 4 8000 5 8000 6 8000 7 8000 8 8000 9 8000 : 8000 ; 8000 < 8000 = 8000 > 8000 ? 8000 @ 8000 A 8000 B 8000 C 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v @ \ r 08QR(VpZ @Z ` 08ghij l ! p v Save as Excel L p Save as Word p pK Save as PDF `
p ekuorep
p goqorep p (0@E 0 | p ~ #JpKTU(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{ |F_DEPTNO 0 dp tS ` 88 # T P 88 h l 0 88 t x &00x $ 0 D r88g25b88 ,08x * v #JpK 00r100g75b100 ,08x *0ipjpj0j 00r100g100b100 p 8&p'+,2p6 gQ_1 mbpchijk JOB P /bpcghijklprrpspsstuvw0x0y0z0{0|0}p~ piDEPT
p wbpcrstusMGR h t Mgr ` ' MGR /bpclmnopqP_USER_CONNECT x lZp[de(fpjpppppp vHIREDATE h w HiredateB_DEPTNO 0 \ JpKQR(VpZ X /bpcghijklprrpspsstuvw0x0y0z0{0|0}p~F_SAL
TE 0 ppppp ySAL h z h w Sal _ ' SAL /bpchijklmpnnpopoopqrs0t0u0v0w0x0ypz( pppppp |COMM h } Comm al _ ' COMM /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ pppppp DEPTNO h Deptno @ ' DEPTNO 102 /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp P_PASS
' P_PASS E H /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp P_ROLE
' P_ROLE p p&p189:0;0<=>?@ ADEPTNO emp.DEPTNO DEPTNO g
00r88g88b100 208x * , . 00 00r100g88b100 b1 .08x & ( * , $ 00custom5 .08x & ( * , ( 00custom6 .08x & ( * , 00custom7 0 .08x & ( * , 00custom8 ,08x $ & ( *rk 00gray16
,08x $ & ( *ge 00gray12GGG ,08x $ & ( *rk 00gray8 ,08x $ & ( * 00gray4 -08x & (* +ay 00r0g100b0 /08x ( *, - 00r25g100b0 @ $ /08x ( *, - 00r50g100b0 /08x ( *, - 00r75g100b0 0 /08x ( *, - " 00r88g100b0 /08x ( *, -&
00r100g100b0 .08x ' ( * , 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .00
00r50g100b50 008x ( * , .00
00r75g100b50 008x ( * , .00
00r88g100b50 208x * , . 000 00r100g100b50 8 .08x ' ( * ,8g 00r0g100b75 8 008x ( * , .00
00r25g100b75@ 008x ( * , .g7
00r50g100b75 008x ( * , .5g
00r75g100b75 008x ( * , .0g
00r88g100b75 208x * , . 05g 00r100g100b75 .08x ' ( * ,b7 00r0g100b88 008x ( * , .5b
00r25g100b88@ 008x ( * , .88
00r50g100b88 008x ( * , .b8
00r75g100b88 008x ( * , .b8
00r88g100b88 208x * , . 0b8 00r100g100b88 ( 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ * 208x * , . 0 00r50g100b100 208x * , . 0 00r75g100b100 208x * , . 0 00r88g100b100 00r75g75b100 008x ( * , .
00r88g75b100 8000 v x 0 r 88 pZ `
2jk0l0m0n8p8rt v0x0yz{0|}~ppppppppr%rHrHr]r]r]r]r]rbbrcrffrjrrrsrtrpe C
Rhj xg
| 2
$ GXJJWXP jk B(F0JK@N@R@V@Z0^0_0`0a0b0c d0f0ghi8j8l0nop rtpupp fr]r ]r @ @ P jj Report Parameters Enter values for the parameters $00x ! "_U black (00x " $ & white %00x " #AT green )00x# $& ' darkgreen VpZ (00x " $ &l gray96
=
=
= (00x " $ &E gray92zzz (00x " $ &h gray88 (00x " $ & gray84((( %00x !" #po r0g0b0 u0v (00x "$% & r25g0b0 @ (00x "$% &
r50g0b0 (00x "$% &MM r75g0b0 (00x "$% &v r88g0b0 (00x "$% &p
r100g0b0 (00x!" $ & r0g0b50 *00x "$ & (02 r25g0b50@ m *00x "$ & (0z r50g0b50 *00x "$ & (p r75g0b50 *00x "$ & ( r88g0b50 H ,00x $& ( *r r100g0b50 (00x!" $ & r0g0b75 *00x "$ & ( r25g0b75@ *00x "$ & (p1 r50g0b75 A *00x "$ & ( r75g0b75 b1 *00x "$ & ( * r88g0b75 00 ,00x $& ( *8 r100g0b75 (00x!" $ & r0g0b88 *00x "$ & ( r25g0b88@ & *00x "$ & ( r50g0b88 *00x "$ & (8 r75g0b88 8 *00x "$ & (ay r88g0b88 8 ,00x $& ( *ay r100g0b88 (00x"# $ &ay r0g0b100 ,00x $& ( *00 ! r25g0b100 @ ,00x $& ( *00 " r50g0b100 ,00x $& ( * # r75g0b100 ,00x $& ( * $ r88g0b100 ,00x $& ( *, %
r100g0b100 &00x " $ ( & gray 00 *00x " $ & (8 ' darkgray &00x " $ ( cyan r * *00x" $ & ( ) darkcyan ( (00x " $ &@ * gray80333333 (00x " $ &0g + gray76=p=p=p (00x " $ & , gray72GGG (00x " $ & , - gray68QQQ '00x! "$ % . r0g25b0 @ )00x " $& ' / r25g25b0@ @ ( * )00x " $& '8 0 r50g25b0 @ ( )00x " $& '@ 1 r75g25b0 @ )00x " $& '0b 2 r88g25b0 @ 8 +00x $ &( )5g 3 r100g25b0 @ *00x" $ & (00 4 r0g25b50 @ ,00x $ & ( * 5 r25g25b50 @ @ ,00x $ & ( * * 6 r50g25b50 @ ,00x $ & ( * ( 7 r75g25b50 @ ,00x $ & ( * 8 r88g25b50 @ ,00x $ & ( *8 9
r100g25b50@ *00x" $ & ( : r0g25b75 0@ b8 ,00x $ & ( * ; r25g25b75 @ @ ,00x $ & ( * < r50g25b75 @ ,00x $ & ( *b1 = r75g25b75 @ ,00x $ & ( *5g > r88g25b75 @ ,00x $ & ( * ?
r100g25b75@ *00x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v @ r .hh , ROSATTRIBS class attributes 0 +hh )ROSLFDESC ros lf descrip 1 )hh '\ROSOBJMAP ros name->id ion +hh ) bROSSTRINGS tk2 uiStrings T *hh (A ROSSTRUCTS struct types *hh (ROSTK2RESV tk2 reserved $ hh ͫSRW2_ANCHOR &h!"h# $ SRW2_BODY_LOCATION $h h! " SRW2_BOILERPLATE hh SRW2_BUTTON ! hh SRW2_COLUMN #h h ! SRW2_DATA_MODEL
$h h! " SRW2_DISPLAY_TAG %h !h" # SRW2_DISTRIBUTION ' h h ͫSRW2_ELEMENT hh 8 SRW2_FIELD )h$%h& ' SRW2_FORMAT_EXCEPTION & hh SRW2_FRAME hh NCSRW2_GROUP M" #h h !E"SRW2_GROUP_NODE # "h h BSRW2_HYPERLINK " $h h! " SRW2_JAVA_APPLET $ (h#$h% & SRW2_JAVA_PROPERTIES % hh SRW2_LAYOUT %h !h" # SRW2_LAYOUT_GROUP hh SRW2_LINK hh SRW2_LISTS hh SRW2_MATRIX 'h"#h$ %SRW2_OGD_COLUMN_MAP $h h! " SRW2_OG_DOCUMENT #h h ! SRW2_PARAM_FORM hh %SRW2_QUERY %h !h" # SRW2_TEXT_SEGMENT D hh ORTOOL_ACCESS h h TOOL_COMMENT h h TOOL_LIBRARY
hh 0TOOL_MODULE n hh bTOOL_PLSQL gi $pp "
eVG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID a@ R +pp $&'( )VG_COLOR CELLID a@
-pp &()* +VG_COLOR NAME_SET @ ESS /pp (*+, -VG_COLOR NAME_LENGTH u /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE "x Empno "x Ename x KG Job x Mgr %x # Hiredate x Sal !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v P r 88 p6 788:8<8>8@BC DgQ_1 E Uff SL FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpt tpup hG_EMPNO g =*%&4 G_EMPNO LIST_G_EMPNO /bpclmnopqprrpspwwxyz{0|0}0~000ppppppp YPRINTJOB Yes P Show Print Job Dialog /bpchijklmpnnpopwwxyz{0|0}0~000ppppppp ZMODE Default P Output Mode /bpcnopqrspvvpwpzz{|}~000000ppppppp [BACKGROUND
t No P Run in Background /bpcopqrstpzzp{p000000ppppppp \ORIENTATION No Default P Orientation /bpcklmnoppvvpwpwwxyz{0|0}0~000ppppppp ]DECIMAL Decimal Indicator /bpcmnopqrpvvpwpwwxyz{0|0}0~000ppppppp ^THOUSANDS Thousands Indicator /bpclmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp _CURRENCY Currency Symbol /bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp `COPIES 1 Number of Copies @ /bpcmnopqrpvvpwp||}~ 000000ppppppp aDESFORMAT dflt Destination Format _C /bpcklmnoppvvpwpwwxy z|0}0~0000ppppppp bDESNAME Destination Name
/bpcklmnoppvvpwp~~000000ppppppp cDESTYPE Screen P Destination Type x Sal !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v ` r 88 u zp{p{{|}~000000ppppppp P_USER_CONNECT 2
P_RO P_USER_CONNECT /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp Output (
OUTPUT / bpdqrstuvpzzp{p{{|}~000000ppppppp P_SERVERNAME
2
OUTP P_SERVERNAME / bpdmnopqrpvvpwpwwxyz{0|0}0~000ppppppp P_ACTION d
P_ACTION t *Zp[cd(jpnpn0n0o8p8rtuvxz000000p0 0B_EMPNO ͫ0 h t *Zp[cd(jpnpn8n0p8r8tvwxx~000000p0 0~B_ENAME ͫ0 *Zp[ab(fpjpj8j0l8n8prstxz000000p0 B_JOB 0 6 0 6 *Zp[ab(fpjpj8j0l8n8prstxz000000p0 pB_MGR
0 T 0 T *Zp[fg(jpnpn8n0p8r8tvwxx~000000p0 B_HIREDATE 00 j T j n *Zp[ab(fpjpj@j0n8p8rtuvxz000000p0 RMB_SAL TE 0 j n *Zp[bc(fpjpj@j0n8p8rtuvxz000000p0 B_COMM E 0 j ~~000000ppppppp cDESTYPE Screen P Destination Type x Sal !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v p T r O N(0@@00@@@@@@000000ppp 00880@@11AA
AAAA1 1 A"A&1*1+A.A2A6A:A>AB1F1GHIJKLM dp tS L PB ` `
O jj L PB ` ` L PB ` `
z *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_2 IS IS x *Zp[cd(jpnpn8n8p8r8tvwxx~000000p0
PB_DEPT q
S q
S *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_3 U-U U S
U -U U
S
~
j
ݒ
ߜ
~ BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{ |M_G_EMPNO_GRPFR p0 h 0 v BpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tM_G_EMPNO_HDR p h v BpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tR_G_EMPNO R 0 h E ~ #JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_EMPNO 0 0 j 0 ~ #JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_ENAME 0 0 m z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_JOB 00 6 p z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_MGR 00 T s ~ #JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_HIREDATE 00 j v !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v r
p goqorep @00@@@@@@000000ppp 00880@@11AA
AAAA1 1 A"A&1*1+A.A2A6A:A>AB1F1GHIJKLM dp tS L PB ` `
O jj L PB ` ` L PB ` `
z *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_2 IS IS x *Zp[cd(jpnpn8n8p8r8tvwxx~000000p0
PB_DEPT q
S q
S *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_3 U-U U S
U -U U
S
~
j
ݒ
ߜ
~ BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{ |M_G_EMPNO_GRPFR p0 h 0 v BpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tM_G_EMPNO_HDR p h v BpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tR_G_EMPNO R 0 h E ~ #JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_EMPNO 0 0 j 0 ~ #JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_ENAME 0 0 m z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_JOB 00 6 p z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_MGR 00 T s ~ #JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_HIREDATE 00 j v !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v r
p ekuorep @00@@@@@@000000ppp 00880@@11AA
AAAA1 1 A"A&1*1+A.A2A6A:A>AB1F1GHIJKLM dp tS L PB ` `
O jj L PB ` ` L PB ` `
z *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_2 IS IS x *Zp[cd(jpnpn8n8p8r8tvwxx~000000p0
PB_DEPT q
S q
S *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_3 U-U U S
U -U U
S
~
j
ݒ
ߜ
~ BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{ |M_G_EMPNO_GRPFR p0 h 0 v BpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tM_G_EMPNO_HDR p h v BpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tR_G_EMPNO R 0 h E ~ #JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_EMPNO 0 0 j 0 ~ #JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_ENAME 0 0 m z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_JOB 00 6 p z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_MGR 00 T s ~ #JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_HIREDATE 00 j v !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v $ r p p Save as PDF @000000ppp 00880@@11AA
AAAA1 1 A"A&1*1+A.A2A6A:A>AB1F1GHIJKLM dp tS L PB ` `
O jj L PB ` ` L PB ` `
z *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_2 IS IS x *Zp[cd(jpnpn8n8p8r8tvwxx~000000p0
PB_DEPT q
S q
S *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_3 U-U U S
U -U U
S
~
j
ݒ
ߜ
~ BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{ |M_G_EMPNO_GRPFR p0 h 0 v BpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tM_G_EMPNO_HDR p h v BpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tR_G_EMPNO R 0 h E ~ #JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_EMPNO 0 0 j 0 ~ #JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_ENAME 0 0 m z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_JOB 00 6 p z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_MGR 00 T s ~ #JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_HIREDATE 00 j v !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v $ r p Save as Word ss attributes +hh )&'ROSLFDESC ros lf descrip C )hh 'VWROSOBJMAP ros name->id qrs +hh )ROSSTRINGS tk2 uiStrings *hh (ROSSTRUCTS struct types *hh (ROSTK2RESV tk2 reserved &h!"h# $ SRW2_BODY_LOCATION #h h ! SRW2_DATA_MODEL
hh SRW2_LAYOUT hh SRW2_LISTS #h h ! SRW2_PARAM_FORM hh TOOL_ACCESS h h TOOL_LIBRARY
hh TOOL_MODULE $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID a@ +pp $&'( )VG_COLOR CELLID a@ -pp &()* +VG_COLOR NAME_SET @ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE " 8000 # 8000 $ 8000 % 8000 & 8000 ' 8000 ( 8000 ) 8000 * 8000 + 8000 , 8000 - 8000 . 8000 / 8000 0 8000 1 8000 2 8000 3 8000 4 8000 5 8000 6 8000 7 8000 8 8000 9 8000 : 8000 ; 8000 < 8000 = 8000 > 8000 ? 8000 @ 8000 A 8000 B 8000 C 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v ( r ! p Save as Excel s attributes +hh )&'ROSLFDESC ros lf descrip C )hh 'VWROSOBJMAP ros name->id qrs +hh )ROSSTRINGS tk2 uiStrings *hh (ROSSTRUCTS struct types *hh (ROSTK2RESV tk2 reserved &h!"h# $ SRW2_BODY_LOCATION #h h ! SRW2_DATA_MODEL
hh SRW2_LAYOUT hh SRW2_LISTS #h h ! SRW2_PARAM_FORM hh TOOL_ACCESS h h TOOL_LIBRARY
hh TOOL_MODULE $pp "VG_COLOR VG_COLOR +pp $&'( )VG_COLOR ITEMID a@ +pp $&'( )VG_COLOR CELLID a@ -pp &()* +VG_COLOR NAME_SET @ /pp (*+, -VG_COLOR NAME_LENGTH /pp (*+, -VG_COLOR COLOR_NAME x 'pp "#$ %VG_COLOR RED )pp "$%& 'VG_COLOR GREEN )pp "$%& 'VG_COLOR BLUE " 8000 # 8000 $ 8000 % 8000 & 8000 ' 8000 ( 8000 ) 8000 * 8000 + 8000 , 8000 - 8000 . 8000 / 8000 0 8000 1 8000 2 8000 3 8000 4 8000 5 8000 6 8000 7 8000 8 8000 9 8000 : 8000 ; 8000 < 8000 = 8000 > 8000 ? 8000 @ 8000 A 8000 B 8000 C 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v d r ]0808[ E E
Oracle HTML Navigator
: 8000 ; 8000 < 8000 = 8000 > 8000 ? 8000 @ 8000 A 8000 B 8000 C 8000 D 8000 E 8000 F 8000 G 8000 H 8000 I 8000 J 8000 K 8000 L 8000 M 8000 N 8000 O 8000 P 8000 Q 8000 R 8000 S 8000 T 8000 U 8000 V 8000 W 8000 X 8000 Y 8000 Z 8000 [ 8000 \ 8000 ] 8000 ^ 8000 _ 8000 ` 8000 a 8000 b 8000 c 8000 d 8000 e 8000 f 8000 g 8000 h 8000 i 8000 j 8000 k 8000 l 8000 m 8000 n 8000 o 8000 p 8000 q 8000 r 8000 s 8000 t 8000 u 8000 v r ,00x $ & ( *E D r88g25b88 @ ,00x $ & ( *EA E
r100g25b88@ *00x# $ & (in F r0g25b100 @ to ,00x $ & ( * & G
r25g25b100@ @ ,00x $ & ( *fi H
r50g25b100 @ ,00x $ & ( *il I
r75g25b100 @ ,00x $ & ( * t J
r88g25b100 @ .00x & ( * ,ge K r100g25b100 @ e $00x ! "[0 L red (00x "$% &pa M darkred $00x "/
N blue (00x"# $ &t O darkblue (00x " $ & j P gray64\(\(\( (00x " $ &
Q gray60ffffff (00x " $ &rw R gray56ppp (00x " $ & * S gray52zzz '00x! "$ %nd T r0g50b0 e )00x " $& '/* U r25g50b0@ */ )00x " $& 'f( V r50g50b0 {
)00x " $& 'ge W r75g50b0 );
)00x " $& '/
X r88g50b0 m)
+00x $ &( )ge Y r100g50b0 = *00x" $ & (m, Z r0g50b50
,00x $ & ( *d [ r25g50b50 @ ,00x $ & ( *ni \ r50g50b50 ,00x $ & ( *fo ] r75g50b50 ,00x $ & ( *ue ^ r88g50b50 ,00x $ & ( *ge _
r100g50b50 *00x" $ & (ag ` r0g50b75 0 ); ,00x $ & ( *Y> a r25g50b75 @ ,00x $ & ( *; b r50g50b75 ,00x $ & ( *T c r75g50b75 ,00x $ & ( *.f d r88g50b75 ,00x $ & ( *on e
r100g50b75 *00x" $ & (to f r0g50b88 5 on ,00x $ & ( *>
g r25g50b88 @ ,00x $ & ( *td h r50g50b88 ,00x $ & ( *or i r75g50b88 ,00x $ & ( *AL j r88g50b88 ,00x $ & ( *ce k
r100g50b88 *00x# $ & ( l r0g50b100 ,00x $ & ( *0 m
r25g50b100@ ,00x $ & ( * n
r50g50b100 ,00x $ & ( * o
r75g50b100 ,00x $ & ( *0 p
r88g50b100 .00x & ( * , q r100g50b100 0 '00x "$ % r yellow +00x $ &( )0 s
darkyellow *00x "$ & ( t magenta .00x &( * , u darkmagenta (00x " $ &0 v gray48 (00x " $ & w gray44\\\ (00x " $ & x gray40 (00x " $ & y gray36ףף '00x! "$ %0 z r0g75b0 )00x " $& ' { r25g75b0@ )00x " $& ' | r50g75b0 0 )00x " $& ' } r75g75b0 )00x " $& ' ~ r88g75b0 +00x $ &( ) r100g75b0 .08x & ( * , 00r0g75b50 008x ( * , . 00r25g75b50 @ 008x ( * , . 00r50g75b50 008x ( * , . 00r75g75b50 008x ( * , . 00r88g75b50 008x ( * , .0
00r100g75b50 .08x & ( * , 00r0g75b75 0 008x ( * , .0 00r25g75b75 @ 008x ( * , . 00r50g75b75 008x ( * , . 00r75g75b75 008x ( * , . 00r88g75b75 008x ( * , .
00r100g75b75 .08x & ( * , 00r0g75b88 5 008x ( * , . 00r25g75b88 @ 008x ( * , .0 00r50g75b88 008x ( * , . 00r75g75b88 008x ( * , .0 00r88g75b88 008x ( * , .
00r100g75b88 .08x ' ( * , 00r0g75b100 008x ( * , .
00r25g75b100@ 008x ( * , .
00r50g75b100 008x ( * , .
00r75g75b100 008x ( * , .
00r88g75b100 8000 v p r 208x * , . 0E 00r100g75b100 .08x & ( * ,00 00custom1 0 .08x & ( * ,10 00custom2 .08x & ( * ,@ 00custom3 $ .08x & ( * , 00custom4 ( ,08x $ & ( * 00gray32 ,08x $ & ( * 00gray28QQQ ,08x $ & ( *e 00gray24 ,08x $ & ( * 00gray20 +08x % &( )0 00r0g88b0 -08x & (* +" 00r25g88b0@ -08x & (* + j 00r50g88b0 ( -08x & (* +ay 00r75g88b0 -08x & (* +p 00r88g88b0 " $ /08x ( *, - 00r100g88b0 .08x & ( * , 00r0g88b50 b0 008x ( * , . " 00r25g88b50 @ 008x ( * , .& 00r50g88b50 008x ( * , ./
00r75g88b50 008x ( * , . 00r88g88b50 008x ( * , .g5
00r100g88b50 .08x & ( * ,b5 00r0g88b75 0 008x ( * , . 00r25g88b75 @ 008x ( * , . 00r50g88b75 008x ( * , . 00r75g88b75 008x ( * , . 00r88g88b75 008x ( * , .0
00r100g88b75 .08x & ( * , 00r0g88b88 5 b7 008x ( * , . $ 00r25g88b88 @ 008x ( * , . ( 00r50g88b88 008x ( * , .on 00r75g88b88 008x ( * , . 00r88g88b88 008x ( * , .5g
00r100g88b88 .08x ' ( * ,b8 00r0g88b100 008x ( * , .
00r25g88b100@ 008x ( * , .
00r50g88b100 008x ( * , .
00r75g88b100 008x ( * , .
00r88g88b100 208x * , . 00 00r100g88b100 b1 .08x & ( * , $ 00custom5 .08x & ( * , ( 00custom6 .08x & ( * , 00custom7 0 .08x & ( * , 00custom8 ,08x $ & ( *rk 00gray16
,08x $ & ( *ge 00gray12GGG ,08x $ & ( *rk 00gray8 ,08x $ & ( * 00gray4 -08x & (* +ay 00r0g100b0 /08x ( *, - 00r25g100b0 @ $ /08x ( *, - 00r50g100b0 /08x ( *, - 00r75g100b0 0 /08x ( *, - " 00r88g100b0 /08x ( *, -&
00r100g100b0 .08x ' ( * , 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .00
00r50g100b50 008x ( * , .00
00r75g100b50 008x ( * , .00
00r88g100b50 208x * , . 000 00r100g100b50 8 .08x ' ( * ,8g 00r0g100b75 8 008x ( * , .00
00r25g100b75@ 008x ( * , .g7
00r50g100b75 008x ( * , .5g
00r75g100b75 008x ( * , .0g
00r88g100b75 208x * , . 05g 00r100g100b75 .08x ' ( * ,b7 00r0g100b88 008x ( * , .5b
00r25g100b88@ 008x ( * , .88
00r50g100b88 008x ( * , .b8
00r75g100b88 008x ( * , .b8
00r88g100b88 208x * , . 0b8 00r100g100b88 ( 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ * 208x * , . 0 00r50g100b100 208x * , . 0 00r75g100b100 208x * , . 0 00r88g100b100 00r75g75b100 008x ( * , .
00r88g75b100 8000 v r 208x * , . 0E 00r100g100b100 ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ m4 h >p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcde fCourier New h >p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcde fCourier New ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ouq ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ouq 8 h >p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcde fCourier New j >p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefg hMS Sans Serif , j >p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefg hMS Sans Serif j >p?p?p?0MNOPQRSTUVWX Z\]^_`abcdefg hMS Sans Serif g8 j >p@p@p@0NOPQRSTUVWXY Z\]^_`abcdefg hMS Sans Serif q 1p"&'*. /beforepform
-p "#&* +afterpform 1 p"&'*. /afterreport @
p p%p/5670809:;<= >kEMPNO emp.EMPNO EMPNO g @
p p%p/5670809:;<= >nENAME emp.ENAME ENAME
g :
p p#p+/0102034567 8qJOB emp.JOB JOB g :
p p#p+/0102034567 8tMGR emp.MGR MGR g I
p p(p5>?@0A0BCDEF GwHIREDATE emp.HIREDATE HIREDATE g 00 :
p p#p+/0102034567 8zSAL emp.SAL SAL g @ =
p p$p-2340506789: ;}COMM emp.COMM COMM g 8 C
p p&p189:0;0<=>?@ ADEPTNO emp.DEPTNO DEPTNO g
00r88g88b100 208x * , . 00 00r100g88b100 b1 .08x & ( * , $ 00custom5 .08x & ( * , ( 00custom6 .08x & ( * , 00custom7 0 .08x & ( * , 00custom8 ,08x $ & ( *rk 00gray16
,08x $ & ( *ge 00gray12GGG ,08x $ & ( *rk 00gray8 ,08x $ & ( * 00gray4 -08x & (* +ay 00r0g100b0 /08x ( *, - 00r25g100b0 @ $ /08x ( *, - 00r50g100b0 /08x ( *, - 00r75g100b0 0 /08x ( *, - " 00r88g100b0 /08x ( *, -&
00r100g100b0 .08x ' ( * , 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .00
00r50g100b50 008x ( * , .00
00r75g100b50 008x ( * , .00
00r88g100b50 208x * , . 000 00r100g100b50 8 .08x ' ( * ,8g 00r0g100b75 8 008x ( * , .00
00r25g100b75@ 008x ( * , .g7
00r50g100b75 008x ( * , .5g
00r75g100b75 008x ( * , .0g
00r88g100b75 208x * , . 05g 00r100g100b75 .08x ' ( * ,b7 00r0g100b88 008x ( * , .5b
00r25g100b88@ 008x ( * , .88
00r50g100b88 008x ( * , .b8
00r75g100b88 008x ( * , .b8
00r88g100b88 208x * , . 0b8 00r100g100b88 ( 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ * 208x * , . 0 00r50g100b100 208x * , . 0 00r75g100b100 208x * , . 0 00r88g100b100 00r75g75b100 008x ( * , .
00r88g75b100 8000 v X r /bpchijklmpnnpopoopqrs0t0u0v0w0x0ypzpppppp iDEPT
Dept select deptno from dept deptno DEPT K /bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~ pppppp jEMPNO h k Empno ` ' o fr EMPNO /bpcijklmnprrpspsstuvw0x0y0z0{0|0}p~( pppppp mENAME h n
Ename ` ' ENAME /bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( pppppp pJOB h q Job _ ' JOB P /bpcghijklprrpspsstuvw0x0y0z0{0|0}p~ pppppp sMGR h t Mgr ` ' MGR /bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp vHIREDATE h w Hiredate ' _ ' B HIREDATE X /bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( pppppp ySAL h z h w Sal _ ' SAL /bpchijklmpnnpopoopqrs0t0u0v0w0x0ypz( pppppp |COMM h } Comm al _ ' COMM /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ pppppp DEPTNO h Deptno @ ' DEPTNO 102 /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp P_PASS
' P_PASS E H /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp P_ROLE
' P_ROLE p p&p189:0;0<=>?@ ADEPTNO emp.DEPTNO DEPTNO g
00r88g88b100 208x * , . 00 00r100g88b100 b1 .08x & ( * , $ 00custom5 .08x & ( * , ( 00custom6 .08x & ( * , 00custom7 0 .08x & ( * , 00custom8 ,08x $ & ( *rk 00gray16
,08x $ & ( *ge 00gray12GGG ,08x $ & ( *rk 00gray8 ,08x $ & ( * 00gray4 -08x & (* +ay 00r0g100b0 /08x ( *, - 00r25g100b0 @ $ /08x ( *, - 00r50g100b0 /08x ( *, - 00r75g100b0 0 /08x ( *, - " 00r88g100b0 /08x ( *, -&
00r100g100b0 .08x ' ( * , 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .00
00r50g100b50 008x ( * , .00
00r75g100b50 008x ( * , .00
00r88g100b50 208x * , . 000 00r100g100b50 8 .08x ' ( * ,8g 00r0g100b75 8 008x ( * , .00
00r25g100b75@ 008x ( * , .g7
00r50g100b75 008x ( * , .5g
00r75g100b75 008x ( * , .0g
00r88g100b75 208x * , . 05g 00r100g100b75 .08x ' ( * ,b7 00r0g100b88 008x ( * , .5b
00r25g100b88@ 008x ( * , .88
00r50g100b88 008x ( * , .b8
00r75g100b88 008x ( * , .b8
00r88g100b88 208x * , . 0b8 00r100g100b88 ( 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ * 208x * , . 0 00r50g100b100 208x * , . 0 00r75g100b100 208x * , . 0 00r88g100b100 00r75g75b100 008x ( * , .
00r88g75b100 8000 v r ~ #JpKQR(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{ |F_SAL
TE 0 y pt ~ #JpKRS(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{ |F_COMM E 0 | p ~ #JpKTU(VpZpZ@Z8^8`8bdefghijkl0m0n0opppr0rstuvwxyz{ |F_DEPTNO 0 t ~ #JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |PF_DEPT 0 0 ui AM v #JpKPQ(RpVpV8V8X8Z8\^_`abcdef0g0h0ipjpj0jklmnopqrs tPF_1 1*> Job _ ' JOB P /bpcghijklprrpspsstuvw0x0y0z0{0|0}p~ pppppp sMGR h t Mgr ` ' MGR /bpclmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp vHIREDATE h w Hiredate ' _ ' B HIREDATE X /bpcghijklprrpspsstuvw0x0y0z0{0|0}p~( pppppp ySAL h z h w Sal _ ' SAL /bpchijklmpnnpopoopqrs0t0u0v0w0x0ypz( pppppp |COMM h } Comm al _ ' COMM /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~ pppppp DEPTNO h Deptno @ ' DEPTNO 102 /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp P_PASS
' P_PASS E H /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp P_ROLE
' P_ROLE p p&p189:0;0<=>?@ ADEPTNO emp.DEPTNO DEPTNO g
00r88g88b100 208x * , . 00 00r100g88b100 b1 .08x & ( * , $ 00custom5 .08x & ( * , ( 00custom6 .08x & ( * , 00custom7 0 .08x & ( * , 00custom8 ,08x $ & ( *rk 00gray16
,08x $ & ( *ge 00gray12GGG ,08x $ & ( *rk 00gray8 ,08x $ & ( * 00gray4 -08x & (* +ay 00r0g100b0 /08x ( *, - 00r25g100b0 @ $ /08x ( *, - 00r50g100b0 /08x ( *, - 00r75g100b0 0 /08x ( *, - " 00r88g100b0 /08x ( *, -&
00r100g100b0 .08x ' ( * , 00r0g100b50 008x ( * , .
00r25g100b50@ 008x ( * , .00
00r50g100b50 008x ( * , .00
00r75g100b50 008x ( * , .00
00r88g100b50 208x * , . 000 00r100g100b50 8 .08x ' ( * ,8g 00r0g100b75 8 008x ( * , .00
00r25g100b75@ 008x ( * , .g7
00r50g100b75 008x ( * , .5g
00r75g100b75 008x ( * , .0g
00r88g100b75 208x * , . 05g 00r100g100b75 .08x ' ( * ,b7 00r0g100b88 008x ( * , .5b
00r25g100b88@ 008x ( * , .88
00r50g100b88 008x ( * , .b8
00r75g100b88 008x ( * , .b8
00r88g100b88 208x * , . 0b8 00r100g100b88 ( 008x ( * , .
00r0g100b100 208x * , . 0 00r25g100b100 @ * 208x * , . 0 00r50g100b100 208x * , . 0 00r75g100b100 208x * , . 0 00r88g100b100 00r75g75b100 008x ( * , .
00r88g75b100 8000 v 0 l 1
$ BEFOREPFORM function BeforePForm return boolean is
vc_parameter_form varchar2(4000);
vc_hidden_runtime_values varchar2(1000);
vc_report_name varchar2(50);
hold_cmd VARCHAR2(240);
/* **** This section must be commented out in 6.x, uncomment when upgrading to 7.1
obj ORA_JAVA.JOBJECT;
x VARCHAR2(100);
exc ORA_JAVA.JOBJECT;
-- Exceptions.
--
NO_OBJECT EXCEPTION;
NO_INST EXCEPTION;
NO_ACCESS EXCEPTION;
NO_PASSWORD EXCEPTION;
INVALID_VERSION EXCEPTION;
INVALID_ACCESS EXCEPTION;
NAME_MISMATCH EXCEPTION;
--
-- Exception pragmas.
--
PRAGMA EXCEPTION_INIT(NO_OBJECT,-20100);
PRAGMA EXCEPTION_INIT(NO_INST,-20101);
PRAGMA EXCEPTION_INIT(NO_ACCESS,-20102);
PRAGMA EXCEPTION_INIT(NO_PASSWORD,-20103);
PRAGMA EXCEPTION_INIT(INVALID_VERSION,-20104);
PRAGMA EXCEPTION_INIT(INVALID_ACCESS,-20105);
PRAGMA EXCEPTION_INIT(NAME_MISMATCH,-20106);
*/
begin
srw.get_report_name(vc_report_name);
-- -- Start Security Check -- Version checking not turned on at EKU so
-- -- version number not relevant but a number must be passed
-- -- In the 6x version of ekuorep, this is a dummy routine that does nothing
-- -- In 7.1, this is SCT's routine that actually sets the security
G$_REPORT_SECURITY.G$_REPORT_VERIFY_ACCESS( upper(vc_report_name), '7.1' ) ;
vc_parameter_form := GWZ$_SET_HTML (upper(vc_report_name), -- Report name
8, -- Generate PDF HTML
'delimiteddata', -- Output Format
NULL, -- ASCII Delimiter (optional)
'Output', -- Field name for java scripts (types 5-8)
'Save as PDF', -- Verbage to select PDF output (types 5-8)
'Save as Excel', -- Verbage to select Excel output (types 5-8)
'Save as Word', -- Verbage to select Word output (types 5-8)
:p_role, -- Banner role passed to report
:P_pass, -- Banner role password passed to report
:P_user_connect, -- Connect string passed to report
NULL,NULL,NULL); -- Reserved for future expansion
srw.set_before_form_html (srw.text_escape, vc_parameter_form);
return (TRUE);
--
exception
/* uncomment these exceptions when compiling in 7.1
WHEN NO_OBJECT THEN
SRW.MESSAGE(1000,'*ERROR* No parameters were passed - report terminated.');
return (FALSE);
WHEN NO_INST THEN
SRW.MESSAGE(1000,'*ERROR* No records found on GUBIPRF - report terminated.');
return (FALSE);
WHEN NO_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* User not authorized to access '
|| vc_report_name || ' - report terminated.');
return (FALSE);
WHEN NO_PASSWORD THEN
SRW.MESSAGE(1000,'*ERROR* No password found on GUBROLE - report terminated.');
return (FALSE);
WHEN INVALID_VERSION THEN
SRW.MESSAGE(1000,'*ERROR* Invalid version of '
|| vc_report_name || ' - report terminated.');
return (FALSE);
WHEN INVALID_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* Invalid password tried - report terminated.');
return (FALSE);
WHEN ORA_JAVA.EXCEPTION_THROWN THEN
SRW.MESSAGE(1000, '*ERROR* Report Server Configuration - report terminated.');
ORA_JAVA.CLEAR_EXCEPTION;
return (FALSE);
*/
WHEN OTHERS THEN
SRW.MESSAGE(1000,'ERROR: ' || SUBSTR(SQLERRM,1,190));
--SRW.MESSAGE(1000, '*ERROR* Before Parm trigger could not set database role - report terminated.');
return (FALSE);
end;
@ @ l @ - _ &Available Columns: ' % _ &Bookmarks: ic _ If you would like to generate links between a chart and the rest of the report for navigating within your report in a Web browser, select the charts to be linked. . , ! _ &Available Charts: $ " _ &Charts: hi }` If you would like to include HTML from a file at the beginning and/or end of your report, specify the name(s) of the file(s).
. , ` &Header HTML file: & $
` &Browse... . , MS ` &Footer HTML file: & $
` B&rowse...dp Congratulations! You have finished preparing your report for the World Wide Web. When you click Finish, the wizard will perform the action you choose below. 5 3 Generate &HTML output nowf A ? % Generate HTML &style sheet output now 4 2 Generate &PDF output now. , Return to &Builder = ; cf ! Generate output to a &Web browser
0800
`
p 0808 name attrs type modality appmenu navigation canresize canmaximize canminimize canclose canmove title vsatype hsatype content genattrs font matchnearest cansynthesize size face weight style rpolicy contentstack dimension childstacks view springs natural shrink stretch elasticity direction springcnt subviews innerwd innerht info imagefile label alignment group autocoordinate outerwd outerht isdefault groups contentclass borderuse borderbevel borderwd bgcolor red green blue assocview items itemcnt valueindex selectstyle alwayshome maxlen cwidth cheight autoscrolled secure editable horizontal scrollee navigable tabstop pagecnt pages numcols scrollself columns width slowdraw x y lineincrement private csprings cspringcnt iconfile autoskip canreorder contentwd contentht enabled nitems id hidden tearoff help submenu accelerator standardkey keyval modifiers cs state startgroup icon cantitle vtatype htatype statustype statusclass status htaclass hta vtaclass vta menu iconsize showlabels canvasmovable wd ht viewclass casefold splitmode string pageresource current canapply eventprocname eventargname fgcolor compress buttons properties data ismapped maprequest isdragsource numrows cells value ishoriz selected enable eanble srctl tgttl 0800 ~ 0 @ 0800
P 0800 ` 0800 p $ 0800" % 0800 c ___ st
p8 headerfield rwbf_parameter Fonts ; 9 Fields box Data box
Type box Sections box Templates box FinishedQuery box rwwt_Express wizard vgmisq_help string rwbwvpul menu rwlfs_help string | z rwlb string q o rwdqe_help string j h rwbwol window K I rwbwdo window , * ! rwbwfe window * ( Y rwbwet window ) ' rwbwtp window % # l rwbhre window # ! rwbwtr window " rwbwfi1 window rwbwcm window rwbwdi window # rwbwmr window rwbwrg window rwbwcn window
rwbwsr window
rwbwgi window HyperlinksWW box MatrixCell box
rwbwmf window
vgmitx_help string vgmirt_help string vgmigr_help string rwlo P l function BeforePForm return boolean is
vc_parameter_form varchar2(4000);
vc_hidden_runtime_values varchar2(1000);
vc_report_name varchar2(50);
hold_cmd VARCHAR2(240);
/* **** This section must be commented out in 6.x, uncomment when upgrading to 7.1
obj ORA_JAVA.JOBJECT;
x VARCHAR2(100);
exc ORA_JAVA.JOBJECT;
-- Exceptions.
--
NO_OBJECT EXCEPTION;
NO_INST EXCEPTION;
NO_ACCESS EXCEPTION;
NO_PASSWORD EXCEPTION;
INVALID_VERSION EXCEPTION;
INVALID_ACCESS EXCEPTION;
NAME_MISMATCH EXCEPTION;
--
-- Exception pragmas.
--
PRAGMA EXCEPTION_INIT(NO_OBJECT,-20100);
PRAGMA EXCEPTION_INIT(NO_INST,-20101);
PRAGMA EXCEPTION_INIT(NO_ACCESS,-20102);
PRAGMA EXCEPTION_INIT(NO_PASSWORD,-20103);
PRAGMA EXCEPTION_INIT(INVALID_VERSION,-20104);
PRAGMA EXCEPTION_INIT(INVALID_ACCESS,-20105);
PRAGMA EXCEPTION_INIT(NAME_MISMATCH,-20106);
*/
begin
srw.get_report_name(vc_report_name);
-- -- Start Security Check -- Version checking not turned on at EKU so
-- -- version number not relevant but a number must be passed
-- -- In the 6x version of ekuorep, this is a dummy routine that does nothing
-- -- In 7.1, this is SCT's routine that actually sets the security
G$_REPORT_SECURITY.G$_REPORT_VERIFY_ACCESS( upper(vc_report_name), '7.1' ) ;
vc_parameter_form := GWZ$_SET_HTML (upper(vc_report_name), -- Report name
8, -- Generate PDF HTML
'delimiteddata', -- Output Format
NULL, -- ASCII Delimiter (optional)
'Output', -- Field name for java scripts (types 5-8)
'Save as PDF', -- Verbage to select PDF output (types 5-8)
'Save as Excel', -- Verbage to select Excel output (types 5-8)
'Save as Word', -- Verbage to select Word output (types 5-8)
:p_role, -- Banner role passed to report
:P_pass, -- Banner role password passed to report
:P_user_connect, -- Connect string passed to report
NULL,NULL,NULL); -- Reserved for future expansion
srw.set_before_form_html (srw.text_escape, vc_parameter_form);
return (TRUE);
--
exception
/* uncomment these exceptions when compiling in 7.1
WHEN NO_OBJECT THEN
SRW.MESSAGE(1000,'*ERROR* No parameters were passed - report terminated.');
return (FALSE);
WHEN NO_INST THEN
SRW.MESSAGE(1000,'*ERROR* No records found on GUBIPRF - report terminated.');
return (FALSE);
WHEN NO_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* User not authorized to access '
|| vc_report_name || ' - report terminated.');
return (FALSE);
WHEN NO_PASSWORD THEN
SRW.MESSAGE(1000,'*ERROR* No password found on GUBROLE - report terminated.');
return (FALSE);
WHEN INVALID_VERSION THEN
SRW.MESSAGE(1000,'*ERROR* Invalid version of '
|| vc_report_name || ' - report terminated.');
return (FALSE);
WHEN INVALID_ACCESS THEN
SRW.MESSAGE(1000,'*ERROR* Invalid password tried - report terminated.');
return (FALSE);
WHEN ORA_JAVA.EXCEPTION_THROWN THEN
SRW.MESSAGE(1000, '*ERROR* Report Server Configuration - report terminated.');
ORA_JAVA.CLEAR_EXCEPTION;
return (FALSE);
*/
WHEN OTHERS THEN
SRW.MESSAGE(1000,'ERROR: ' || SUBSTR(SQLERRM,1,190));
--SRW.MESSAGE(1000, '*ERROR* Before Parm trigger could not set database role - report terminated.');
return (FALSE);
end;
vgmigr_help string rwlo ` r 0800 0 @ 0800 P t0808r \ \ 1
$ \
AFTERPFORM Cfunction AfterPForm return boolean is
begin
return (TRUE);
end; A ͫͫͫͫͫͫͫ w SYS STANDARD $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 0 8 "PKG INIT"AFTERPFORM"" n $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 0 8 J * "FUNCTION"AFTERPFORM"RETURN"BOOLEAN"TRUE"" (
# $ ( 3 5 7 ; > B D H h , e Z O
d ͫͫͫͫͫͫͫ 0 D
% hg !l l \ D 0
AFTERPFORM X @ @ W0000 UC Cfunction AfterPForm return boolean is
begin
return (TRUE);
end;g]0808[ E E 1
$ E AFTERREPORT function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; a k ͫͫͫͫͫͫͫ w SYS STANDARD /LekuorepG$_REPORT_SECURITY $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 0 8 "PKG INIT"AFTERREPORT"" n > $ ͫͫͫͫͫͫͫͫͫͫͫͫͫͫͫ 0 8
o
$
c "FUNCTION"AFTERREPORT"RETURN"BOOLEAN"G$_REPORT_SECURITY"G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v p t r F&p'+,2p6p6p66788:8<8>8@BC DgQ_1 E Uff SL FpGOPQRST0UVW0XYZ0[\]^_xb8b8d8f8hjkplplpt tpup hG_EMPNO g =*%&4 G_EMPNO LIST_G_EMPNO /bpclmnopqprrpspwwxyz{0|0}0~000ppppppp YPRINTJOB Yes P Show Print Job Dialog /bpchijklmpnnpopwwxyz{0|0}0~000ppppppp ZMODE Default P Output Mode /bpcnopqrspvvpwpzz{|}~000000ppppppp [BACKGROUND
t No P Run in Background /bpcopqrstpzzp{p000000ppppppp \ORIENTATION No Default P Orientation /bpcklmnoppvvpwpwwxyz{0|0}0~000ppppppp ]DECIMAL Decimal Indicator /bpcmnopqrpvvpwpwwxyz{0|0}0~000ppppppp ^THOUSANDS Thousands Indicator /bpclmnopqprrpspsstu vx0y0z0{0|0}0~ppppppp _CURRENCY Currency Symbol /bpcjklmnoprrpspuuvwxy0z0{0|0}0~0ppppppp `COPIES 1 Number of Copies @ /bpcmnopqrpvvpwp||}~ 000000ppppppp aDESFORMAT dflt Destination Format _C /bpcklmnoppvvpwpwwxy z|0}0~0000ppppppp bDESNAME Destination Name
/bpcklmnoppvvpwp~~000000ppppppp cDESTYPE Screen P Destination Type x Sal !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v r /bpcrstuvwpzzp{p{{|}~000000ppppppp P_USER_CONNECT 2
P_RO P_USER_CONNECT /bpcjklmnoprrpspsstuvw0x0y0z0{0|0}p~~pppppp Output (
OUTPUT / bpdqrstuvpzzp{p{{|}~000000ppppppp P_SERVERNAME
2
OUTP P_SERVERNAME / bpdmnopqrpvvpwpwwxyz{0|0}0~000ppppppp P_ACTION d
P_ACTION t *Zp[cd(jpnpn0n0o8p8rtuvxz000000p0 0B_EMPNO ͫ0 h t *Zp[cd(jpnpn8n0p8r8tvwxx~000000p0 0~B_ENAME ͫ0 *Zp[ab(fpjpj8j0l8n8prstxz000000p0 B_JOB 0 6 0 6 *Zp[ab(fpjpj8j0l8n8prstxz000000p0 pB_MGR
0 T 0 T *Zp[fg(jpnpn8n0p8r8tvwxx~000000p0 B_HIREDATE 00 j T j n *Zp[ab(fpjpj@j0n8p8rtuvxz000000p0 RMB_SAL TE 0 j n *Zp[bc(fpjpj@j0n8p8rtuvxz000000p0 B_COMM E 0 j ~~000000ppppppp cDESTYPE Screen P Destination Type x Sal !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v r *Zp[de(fpjpj@j0n8p8rtuvxz000000p0 pB_DEPTNO 0 j / *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_1 rV r V z *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_2 IS IS x *Zp[cd(jpnpn8n8p8r8tvwxx~000000p0
PB_DEPT q
S q
S *Zp[`a(bpfpf8f8h8j8lnopxv000000p0 PB_3 U-U U S
U -U U
S
~
j
ݒ
ߜ
~ BpCST(Zp^p^0^0_@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{ |M_G_EMPNO_GRPFR p0 h 0 v BpCQR TpVpV0V0W@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tM_G_EMPNO_HDR p h v BpCMN(RpVpV0V8X@Z8^`abc0d0e0f0g0h0ij0k0lmnopqrs tR_G_EMPNO R 0 h E ~ #JpKST(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_EMPNO 0 0 j 0 ~ #JpKST(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_ENAME 0 0 m z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_JOB 00 6 p z #JpKQR(VpZpZ8Z8\8^8`bcdefghij0k0l0mpnpn0nopqrstuvw xF_MGR 00 T s ~ #JpKVW(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxyz{ |F_HIREDATE 00 j v !x Comm $ #x !Ͱ Deptno :x 8 PDF/Word/Excel output example .x , Using new version !x Dept ERR #x !$_ Output "G$_REPORT_REVOKE_ACCESS"TRUE"OTHERS"FALSE""
# $ ( 3 5 7 < ? C G H L O S W \ ] _ c f j l n h , W k e Z S e Z O
d ͫͫͫͫͫͫͫ 0 D
? ? & ' $ %$ %k k hg ! ` D 0 AFTERREPORT v v v& v2 v % & X \ @ @ 0808 function AfterReport return boolean is
begin
G$_REPORT_SECURITY.G$_REPORT_REVOKE_ACCESS;
return (TRUE);
exception
when others then
return (FALSE);
end; :0000 8& &select * from emp where deptno = :dept0 *>FNW(Z ^bg(nrw(~((( 0 SQL*ReportWriterKg REPORT EKUE gxjjwxp t $ EKUxg
EKUxi
v x" $ & ( . @ r0g25b88 5@ 0b ,00x $ & ( * A r25g25b88 @ @ ,00x $ & ( *b1 B r50g25b88 @ ,00x $ & ( *8g C r75g25b88 @ 8000 v