Oracle Reportsレポート作成ガイド,...

Oracle Reports

10g9.0.4

: B12385-01

2004 2

Oracle Reports , 10g9.0.4

: B12385-01

Oracle Reports Building Reports, 10g (9.0.4)

B10602-01

Vanessa Wang, Ingrid Snedecor, and Frank Rovitto

Christian Bauwens, Reena John, Shaun Lin, Rohit Marwaha, Darren McBurney, Paul Narth, Praveen Padmanabhan, Danny Richardson, Jim Safcik, Anjana Suparna Sriram, Toby Shimizu, Ravikumar Venkatesan, Philipp Weckerle, Stewart Wilson

Copyright 2002, 2003 Oracle Corporation. All rights reserved.

U.S. GOVERNMENT RIGHTS

Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation, and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.

redundancy

Oracle Oracle Corporation Oracle Corporation

......................................................................................................................................................................... xiii

................................................................................................................................................................... xiv ........................................................................................................................................................................... xiv ....................................................................................................................... xvi ............................................................................................................................... xvi .................................................................................................................................................. xvii

1 1.1 Reports Builder ....................................................................................................................................... 1-21.2 ................................................................................................................................................... 1-31.3 ............................................................................................................................... 1-61.4 ............................................................................................................................................. 1-151.5 ................................................................................................................. 1-191.6 ............................................................................................................................. 1-201.7 ......................................................................................................... 1-251.8 ................................................................................................................. 1-331.9 ............................................................................................. 1-371.10 ................................................................................................................. 1-411.11 ......................................................................................................................................... 1-431.12 ................................................................................................................................. 1-45

2 2.1 ................................................................................................................................................... 2-22.2 Web .......................................................................................................................................... 2-92.3 ......................................................................................................... 2-18

i

2.4 ................................................................................................................. 2-302.5 ............................................................................................. 2-432.6 PL/SQL .................................................................................................................................................. 2-442.7 ......................................................................................................................................... 2-622.8 ..................................................................................................................... 2-662.9 ..................................................................................................................................... 2-852.10 ................................................................................................................................. 2-88

3 3.1 Oracle Reports ................................................................................... 3-23.2 ............................................................................................................... 3-43.3 ................................................................................................................................... 3-93.4 ..................................................................................................... 3-143.5 ..................................................................................................................................... 3-163.6 Web ............................................................................................................................ 3-213.7 ......................................................................................................................... 3-433.8 ......................................................................................................................... 3-633.9 ............................................................................................................. 3-733.10 ........................................................................................................... 3-1203.11 ................................................................................... 3-1213.12 ........................................................................................................................... 3-1303.13 PL/SQL ...................................................................... 3-1363.14 ........................................................................................................................... 3-1553.15 ............................................................................................................................... 3-1663.16 Reports Builder ...................................................................................................................... 3-168

4 4.1 : ........................................................................................................ 4-24.2 : .................................................................................................... 4-54.3 : ................................................................................ 4-94.4 : .......................................................................................... 4-194.5 : .......................................................................................................... 4-214.6 : PL/SQL Java ............................................................ 4-294.7 : .......................................... 4-344.8 ..................................................................................................................................................... 4-36

ii

I

5 5.1 ................................................................................................................................... 5-35.2 ........................................................................... 5-35.3 ....................................................................................................................................................... 5-5

6 6.1 ................................................................................................................................... 6-26.2 ........................................... 6-36.3 ....................................................................................................................................... 6-66.4 ....................................................................................................................................................... 6-6

7 7.1 ................................................................................................................................... 7-37.2 ....................................... 7-37.3 ....................................................................................................................................................... 7-6

8 / 8.1 ................................................................................................................................... 8-28.2 ............................................................................................................... 8-38.3 2 ....................................................................... 8-38.4 ................................................................... 8-48.5 ................................................................... 8-68.6 ........................................................................................................................... 8-78.7 ....................................................................................................................................................... 8-8

9 9.1 ................................................................................................................................... 9-39.2 ............................................................................... 9-39.3 ........................................................................................................................... 9-79.4 ......................................................................... 9-99.5 ..................................................................................................................................................... 9-10

iii

II

10 1 10.1 ................................................................................................................................. 10-210.2 1 ..................................................................................... 10-210.3 2 ................................................................................... 10-1110.4 2 ................................................................... 10-1410.5 ................................................................................................................................................... 10-16

11 2 11.1 ................................................................................................................................. 11-311.2 ............................................................................................................. 11-311.3 ................................................................................. 11-411.4 ................................................................. 11-611.5 ......................................................................................................................... 11-911.6 ................................................................................................................................................... 11-10

12 12.1 ................................................................................................................................. 12-212.2 2 .............................................................................................................................. 12-212.3 ......................................................................................................... 12-412.4 ............................................................................................. 12-512.5 ..................................................................................................................................................... 12-6

13 13.1 ................................................................................................................................. 13-313.2 ............................................................................................................. 13-313.3 ................................................................................. 13-313.4 2 ................................................. 13-813.5 2 ................................................................................................................ 13-1113.6 ....................................................................................................................... 13-1313.7 ................................................................................................................................................... 13-14

14 14.1 ................................................................................................................................. 14-2

iv

14.2 ............................................................. 14-314.3 2 .................................................................................................................................. 14-414.4 ..................................................................................................................................................... 14-8

III

15 15.1 ................................................................................................................................. 15-215.2 ..................................................................................... 15-315.3 3 ...................................................................................................................... 15-415.4 ............................................. 15-515.5 ............................................................................................................. 15-615.6 ............................................................................................. 15-715.7 ..................................................................................................................................................... 15-8

16 / 16.1 ................................................................................................................................. 16-316.2 ............................................................................. 16-316.3 ..................................................................................................................................... 16-516.4 ..................................................................................................................... 16-616.5 ................................................................................................................. 16-716.6 ..................................................................................................................................................... 16-9

17 17.1 ................................................................................................................................. 17-217.2 ............................................................................. 17-217.3 ......................................................................................... 17-517.4 ..................................................................................................................... 17-617.5 ..................................................................................................................................................... 17-7

18 18.1 ................................................................................................................................. 18-318.2 ................................................................................................................. 18-318.3 ..................................................................... 18-518.4 ................................................................................................................................................... 18-13

v

19 19.1 ................................................................................................................................. 19-319.2 ............................................................................. 19-419.3 2 .......................................................................................................................... 19-619.4 ..................................................................................................... 19-819.5 ..................................................................................... 19-919.6 ................................................................................................................... 19-1019.7 ............................................................................................................................... 19-1219.8 ................................................................................................................................................... 19-13

20 20.1 ................................................................................................................................. 20-220.2 ................................................................................................. 20-220.3 ............................................................................................................................................. 20-520.4 ................................................................................................................................. 20-620.5 ..................................................................................................................... 20-720.6 ..................................................................................................................................... 20-820.7 ................................................................................................................................................... 20-10

21 21.1 ................................................................................................................................. 21-321.2 2 .......................................................................... 21-321.3 ..................................................................................................................... 21-521.4 ............................................................................................................. 21-721.5 ................................................................. 21-821.6 ........................................................................... 21-1021.7 ................................................................................................................................................... 21-14

22 22.1 ................................................................................................................................. 22-322.2 ................................................................................................. 22-322.3 ..................................................................................................................................... 22-522.4 ................................................................................................................. 22-722.5 ................................................................................................................................................... 22-10

vi

23 23.1 ................................................................................................................................. 23-323.2 ......................................................................................................... 23-323.3 ..................................................................................................... 23-723.4 ....................................................................... 23-1023.5 ................................................................................................................................................... 23-11

24 24.1 ................................................................................................................................. 24-224.2 2 .......................................................................... 24-324.3 ................................................. 24-524.4 ............................................................................................. 24-824.5 ..................................................................................................................................................... 24-9

IV

25 25.1 ................................................................................................................................. 25-325.2 ......................................................................................................... 25-325.3 ......................................................................................................... 25-525.4 ............................................................................... 25-1125.5 ................................................................................................................................... 25-1225.6 ............................................................................................................... 25-1325.7 ................................................................................................................................... 25-1625.8 ................................................................................................................................................... 25-17

26 26.1 ................................................................................................................................. 26-326.2 ......................................................................................................... 26-326.3 ......................................................................................................... 26-726.4 ........................................................................... 26-1426.5 ................................................................................................................................... 26-2126.6 ................................................................................................................................................... 26-22

vii

27 27.1 ................................................................................................................................. 27-227.2 ................................................. 27-327.3 ............................................................................................................. 27-527.4 ................................................................................................................. 27-727.5 Web ........................................................................................................................ 27-827.6 ..................................................................................................................................................... 27-9

V

28 28.1 ................................................................................................................................. 28-228.2 ................................................................................................................. 28-228.3 JSP Web .................................................................................................... 28-528.4 ..................................................................................................................................................... 28-7

29 29.1 ................................................................................................................................. 29-229.2 ................................................................................................................. 29-229.3 JSP Web .................................................................................................... 29-829.4 ..................................................................................................................................................... 29-9

30 30.1 ................................................................................................................................. 30-330.2 ................................................................................. 30-430.3 ............................................................................. 30-630.4 ....................................................................................................... 30-1230.5 ....................................................... 30-1430.6 ............................................... 30-2330.7 ................................................................................................................................................... 30-33

31 31.1 ................................................................................................................................. 31-331.2 ............................................................................................. 31-331.3 ............................................................................................................. 31-9

viii

31.4 ....................................................... 31-1731.5 ..................................................................................................... 31-1931.6 ................................................................................................................................................... 31-22

32 32.1 ................................................................................................................................. 32-332.2 ............................................................................................................. 32-332.3 ................................................................................. 32-432.4 ..................................................................................................................... 32-632.5 ................................................................................................................................. 32-832.6 ................................................................................................................................. 32-932.7 ................................................................................................................................................... 32-14

33 33.1 ................................................................................................................................. 33-333.2 ................................................................................. 33-333.3 ............................................................................. 33-533.4 ......................................................................... 33-733.5 ............................................................................................................. 33-833.6 ......................................................................................... 33-933.7 ................................................................................................................................................... 33-14

34 34.1 ................................................................................................................................. 34-334.2 ......................................................................................... 34-534.3 ....................................................................................................................... 34-1534.4 ................................................................................................................................................... 34-19

35 35.1 ................................................................................................................................. 35-435.2 TOC ............................................................................... 35-535.3 After Parameter Form ............................................. 35-535.4 ..................................................................................................................... 35-935.5 ................................................................................................................................................... 35-12

ix

36 36.1 ................................................................................................................................. 36-236.2 ..................................................................................... 36-336.3 XML .......................................................................................................................... 36-536.4 ..................................................................................................................................... 36-636.5 ..................................................................................................................................................... 36-7

VI PL/SQL PL/SQL PL/SQL PL/SQL Java

37 PL/SQL 37.1 ................................................................................................................................. 37-337.2 PL/SQL .................................................................................................... 37-337.3 ............................................................................................................................. 37-537.4 ........................... 37-1237.5 ....................................................................................................... 37-1537.6 ........................................................................................... 37-1937.7 ................................................................................................................................................... 37-20

38 REF 38.1 ................................................................................................................................. 38-438.2 REF ........................................................................................................................ 38-538.3 REF ................................................................................................................ 38-738.4 ......................................................................................................................... 38-938.5 REF .......................................................................................... 38-1138.6 ............................................................................................................................... 38-1238.7 ............................................................................................................................... 38-1438.8 SELECT .................................................................................................. 38-1638.9 ................................................................................................... 38-1938.10 ................................................................................................................................................... 38-20

39 JSP Web 39.1 ................................................................................................................................. 39-439.2 HTML ........................................................................................ 39-539.3 Reports Builder HTML .......................................................... 39-639.4 ........................................................................................................... 39-10

x

39.5 JSP ................................................................................ 39-1139.6 ................................................................................................................................................... 39-15

40 40.1 ................................................................................................................................. 40-340.2 ................................................................................. 40-640.3 Web .............................................................................................. 40-1640.4 ................................................................................................................................................... 40-25

VII

41 XML 41.1 ................................................................................................................................. 41-341.2 SQL XML ......................................................... 41-441.3 ........................................................................................... 41-1541.4 ................................................................................................................................................... 41-16

42 42.1 ................................................................................................................................. 42-242.2 textpds.conf .............................................................................................................. 42-342.3 ......................................................................... 42-442.4 ..................................................................................................................................................... 42-8

43 Oracle Express 43.1 ................................................................................................................................. 43-343.2 Express ................................................................. 43-443.3 Express ...................................................................................................................... 43-743.4 ............................................. 43-943.5 ........................................................................................................... 43-1443.6 ................................................................................................................................................... 43-20

A A.1 ............................................................................................................................... A-2A.2 ................................................................................... A-4A.3 ....................................................................... A-6

xi

Reports Builder Oracle Developer Suite Oracle Reports Reports Builder

xiii

Oracle Reports Reports Builder

1 Oracle Reports

2 Oracle Reports

3 Reports Builder

4

1 5

6

7

8 /

9

2 10 1

11 2

xiv

12

13

14

3 15

16 /

17

18

19

20

21

22

23

24

4 25

26

27

5 28

29

30

31

32

33

34

35

36

xv

6 PL/SQL Java 37 PL/SQL

38 REF

39 JSP Web

40

7 41 XML

42

43 Oracle Express

A Reports Builder

OTNOracle Technology Network Web

http://otn.oracle.com/products/reportsGetting StartedGetting StartedIndex

ExamplesOracle Reports

Web zip zip

SCOTT

Human Resources Order Entry

SUMMIT

xvi

2 Oracle9i Database

Oracle Reports OTN-JOracle Technology Network JapanReports Builder Oracle Application Server Reports Services Web OTN-JOracle Technology Network

Oracle Technology NetworkOracle Technology Networkhttp://otn.oracle.com/ Oracle Technology Network Japanhttp://otn.oracle.co.jp/ Web Oracle Application Server Reports Services Web

Oracle Reports JSP Web Oracle Technology Network Japan Web Oracle Reports

Oracle Reports

Reports Builder Reports Builder

Oracle Application Server Reports Services Web Oracle Application Server CD Oracle Application Server Reports Services Reports Server

xvii

1

Oracle Reports Reports Builder Reports Builder 3.1.1

1.1 Reports Builder

1.2

1.3

1.4

1.5

1.6

1.7

1.8

1.9

1.10

1.11

1.12

1-1

Reports Builder

1.1 Reports BuilderReports Builder

Reports Builder

1.1.1 Reports Builder Reports Builder Oracle Reports DeveloperOracle Developer Suite 1 OracleJDBCXMLOracle OLAP Web JSP XML J2EE HTMLXMLPDFPostscriptPCLRTFWeb OracleAS Portal

Reports Builder Web Web E-Business Reports Builder

JDBC XML PDS

SQL

WYSIWYG

HTML JSP HTML

Web

HTMLHTMLCSSXMLPDFPCLPostScriptASCII

JavaScript

PL/SQL SQL

1-2 Oracle Reports

Oracle Reports Developer OracleAS Portal

1.1.2 Oracle Reports Web Reports Builder Web HTML PDF Web HTML

Oracle Reports 1 JavaServer PagesJSPOracle Reports JSP Web

Reports Builder

1.2 2.1

Web

1.2.1 1

PL/SQL

PL/SQL

Web JSP Web

1-3

Reports Builder

1.2.1.1 Web

1.

2.

3. Reports Builder 1.3

4.

1.2.1.2 Reports Builder Reports Builder

3.5.1

1.2.2 Web Web Oracle Reports Reports Builder Web HTML PDF Web HTML

1-4 Oracle Reports

Web Oracle Reports JavaServer PagesJSPReports Builder Web Web1 JSP Web Web Web 1 PDF JSP Web Web

Oracle Reports CGI Java Web CGI

Web

Web Web Web Web Web Web

HTML Web Web 1 Web 3.6.4 Web

Web 3.6.2 Web Oracle Reports JSP Reports Builder Oracle Reports JSP

Web Web Web Web

Oracle Reports 6i HTML 3.6.7 Web

Web Web Web

1-5

2.2 Web

1.9.4 Web

2.8.8 HTML

2.8.9 PDF

3.6.1 Web

3.7.15.4 Web

3.7.16.3 Web

1.3 Reports Builder

1.3.1

: Netscape 7.0 Netscape 7.0 netscape.exe

1-6 Oracle Reports

3.5.1

1.3.2 / 1

3.5.1

1.7.2

3.8.4

1.3.3 2

3.5.1

1.7.2

3.8.4

1.3.4 1 1

3.5.1

1-7

1.3.5

3.5.1

1.3.6

3.5.1

1.3.7 4

1

1

1

1

1-1

4 1 2

1-8 Oracle Reports

1 1

1

Reports Builder 4

1.3.7.1

1.3.7.1.1 4 1 1 3 3 1 2

1-9

1-2

1

1.3.7.1.2 4

2 1 1

1

1-10 Oracle Reports

1-3

1 0 1

1-4

1-11

1.3.7.1.3

Reports Builder

1-5

G_YEAR YEAR G_DEPT DEPTNO G_JOB JOB G_CROSS

1-12 Oracle Reports

G_CROSS

1-6

G_JOB G_JOB 0

G_CROSS

1-7

G_YEAR G_YEAR 0 G_CROSS

1-8

G_YEAR G_DEPT G_DEPT G_YEAR G_YEAR G_DEPT G_YEAR G_DEPTG_YEAR

G_DEPT 0

1-13

1.3.7.2 2

1-9

3 1 1 1

1 R_SUMSAL F_SUMSAL

Job Deptno

1.3.7.2.1 2 1

: Reports Builder

1-14 Oracle Reports

1

2.3.7

WHERE

2.3.7

2.1.7

2.1.8

2.4.2

3.5.1

1.4 Reports Builder Reports Builder

1.4.1 Web Reports Builder

: Reports Builder

1-15

1.6.1

:

1.4.2 1 HTML Web Web

:

Web

1.4.3

:

1-16 Oracle Reports

1.4.4 JSP Web Reports Builder

Oracle Graphics6i Graphics Builder Reports Builder Oracle Reports 10g Oracle Graphics6i

:

1-17

3

Oracle Reports Oracle Graphics6i ORACLE_HOME Oracle Graphics6i Reports Builder Oracle Reports 10g Oracle Graphics6i

:

JSP Web :

Web

:

1.

2.

JSP Web :

Web

1-18 Oracle Reports

1.5 Reports Builder

1.5.1

PL/SQL

PL/SQL

PL/SQL

3.2.4

1.5.2

1-19

3.2.4

1.6

Web

1.6.1 Web

1.6.2

1-20 Oracle Reports

Reports Builder

:

1.6.3

:

1-21

1.6.4

NULL

Reports Builder

:

1-22 Oracle Reports

1.6.5

Reports Builder

:

1.6.6 Web Web HTML JSP Web Web

: Reports Builder

: JSP Web Reports Builder 1.9.4 Web

1-23

Web Oracle Reports JSP Web

Web

Web

Web

Web Web

1.2.2 Web

2.2.1 JavaServer PagesJSP

3.6.3 Web HTML

3.6.4 Web

3.6.5 Web

Reports Builder Oracle Reports JSP

1.6.7 Web Reports Builder

1

1-24 Oracle Reports

1

A

1.7 2.3

Query Builder

1.7.1

OracleXMLJDBCOracle OLAP ServerPDSAPI REF

1 1

1

1-25

1-10

3 3 3 Reports Builder

1-26 Oracle Reports

1

SELECT

1 2

/ 1

1-11

/ 2 /

1-27

PRODUCT_PROFILE

SQL

GROUP BY

Reports Builder 1 2 Reports Builder WHERE 2 1 Reports Builder

2.3.5

3.8.1

1.7.2 1 2

1-28 Oracle Reports

2

Reports Builder

n 5

n

PL/SQL

2.3.6

2.6.9

1.3.2

1.3.3

2.1.8

1-29

3.5.1

3.5.2

3.8.4

3.8.5

1.7.3

Reports Builder

LONG LONG RAW 1

BMPCALSCGMGIFJFIFPCDPCXPICTRASTIFF

3.8.1

3.9.8.7

2.3.4

2.3.1

2.3.2

2.3.3

1.7.4

1

1-30 Oracle Reports

1

1

SQL Reports Builder : Reports Builder

WHERE DEPTNO =DEPTNOSQL WHEREHAVINGSTART WITH SQL SELECT Reports Builder SELECT

1-12

Order IDCustomerItemProductAmount

1-31

1-13

2.3.6

2.3.5

3.8.6

1.7.5 Query Builder Query Builder

Query Builder SQLStructured Query Language

: Reports Builder SQL WHERE

1-32 Oracle Reports

Query Builder

Query Builder SQL SELECT Query Builder SELECT FROM [table.column]

3.8.3 Query Builder

1.8 2.4

1.8.1

Reports Builder 1.6.3

:

1-33

:2 2

:2 2

3.9.1.2

1.8.2 1

Reports Builder 1 1 /

1.6.3

3.9.1.2

1.8.3

20 4 10 30 1 20

1-34 Oracle Reports

1-14

x y

3.9.1.2

1.8.4

Reports Builder 1

1.9.2

3.9.1.1

3.9.2.4

1-35

1.8.5

Reports Builder 1 B_columnname ENAME Ename

1.6.4 1.6.3 1.6.5

HTML

3.9.2.5

3.9.8.9

3.6.7.1.15 HTML

1-36 Oracle Reports

URL 3.9.8.10 URL

1.9.3

3.9.2.1

3.9.2.2 2

3.9.2.4

3.9.11.8

1.9 2.5

Web

1.9.1 SELECT PL/SQL

Reports Builder PL/SQL

:

1-37

Reports Builder

1-1

COPIES

CURRENCY "$" Reports Builder

DECIMAL "." Reports Builder

DESFORMAT

PDFHTMLHTMLCSSRTFXMLDELIMITED

DESTYPE=FILE DESNAME=filename MODE=BITMAP MODE=CHARACTER .prt

DESNAME ID

DESTYPE

MODE

ORIENTATION

1-38 Oracle Reports

2.3.4.1

2.3.4

3.11.1

3.11.2

3.11.3 LOV

3.11.4

3.11.6

3.11.9

1.9.2 1.6.5 1

1.8.4

3.11.5

3.11.7

PRINTJOB

THOUSANDS 3 "," Reports Builder

1-1

1-39

1.9.3 Reports Builder

1.8.5

3.11.5

3.11.7

1.9.4 Web Web JSP Web Reports Builder

Web Web 1 Web JSP Web

JSP Web

URL URL

HTML Oracle Reports JSP

Web

1-40 Oracle Reports

JSP yourParameterList Java

JSP Web 39 JSP Web

1.2.2 Web

1.6.5

1.11.1

2.5.1 HTML

1.10 Reports Builder


: Web HTML HTML

:

PL/SQL: SRW.SET_BEFORE_FORM_HTMLSRW.SET_AFTER_FORM_HTML

1-41

1.5.1 1.6.1 2.7.5

[F1]

1.10.1.1 [Shift] [Ctrl] 2

/

2

*****

3.2.2

3.2.5 ASCII

3.2.7

3.2.8

1-2

1-42 Oracle Reports

1.11

1.11.1 SELECT

1.6.5

1.9.4 Web

3.11.7

1.11.2 1

1-3

1-43

1 1 1

:

NULL

Reports Builder

3.7.15.3

3.7.16.2

: Reports Builder

1-3

1-44 Oracle Reports

1.12 Oracle Reports

Reports Builder

3.7.2

3.7.3

1-4

rwbuilder Reports Builder

rwrun OracleAS Reports Services

rwclient Reports Server

rwcgi Web J2EE OC4J Reports Server Web Oracle Reports

rwserver Reports Server

rwservlet Web J2EE OC4J Reports Server Web

rwconverter 1 PL/SQL

1-45

1-46 Oracle Reports

2

Oracle Reports Reports Builder 3.1.1

2.1

2.2 Web

2.3

2.4

2.5

2.6 PL/SQL

2.7

2.8

2.9

2.10

2-1

2.1 1.2

2.1.1

Reports Builder

B_OR$REPORT_TITLE

B_OR$REPORT_TITLE

B_OR$REPORT_TITLE

: B_OR$REPORT_TTILE

2-2 Oracle Reports

B_OR$REPORT_TITLE Reports Builder

3.5.6

3.12.5

2.7.1

2.1.2 1 3 1

36 distribution.xml

1 HTML Postscript

2-3

22 1 1 1

2.8.3

3.10.1

3.10.2


rwconverter DUNIT

Reports Builder

2.1.4 1 1 1

2-4 Oracle Reports

1 2 2

1 6 3 2 3 2 2 3 2 3

2-1

2-5

2.1.5 Oracle Reports Oracle Application Server Reports Services Web Oracle Reports OTN-JOracle Technology Network Japan Oracle Reports

http://otn.oracle.co.jp/products/reports/index.html

2.1.6

...

Windows

PL/SQL Reports Builder


3.9.1.5

2-6 Oracle Reports

2.1.7 1

3 2-2 1

26

2.3.7

1.3.7

2.1.8 1

3

2-7

2-2

/ Year 80 20 1 Year 80 Year 80

27

2.3.7

1.3.7

2-8 Oracle Reports

Web

2.2 Web 1.2.2 Web

JavaServer PagesJSP

JSP Web

HTML Web

PDF Web

1.2.2 Web

2.2.1 JavaServer PagesJSPOracle Reports Reports Builder Web JavaServer PagesJSPJavaServer PagesJSPSun Java WebJSPWeb Java HTML HTML Web Java

JSP JSP HTML Java Web Web HTML XML JSP Web JSP Java Web

JSP .jsp Web Server JSPJSP JSP JSP Java HTML XML

2-9

Web

JSP JSP /

Thin

JSP Java Web Server JSP 2 HTTP Common Gateway InterfaceCGI

JSP Web http://www.java.sun.com/products/jsp/

2.2.1.1 Oracle Reports JSP Oracle Reports JSP WebJSP Web JSP JSP JSP JSP JSP .rdf JSP XML XML XML

Oracle Reports JSP JSP JSP Web Java JSP HTML XML JSP

Web HTML XML JSP Web

Oracle Reports Web Web PDF JSP rw:field JSP

2-10 Oracle Reports

Web

10

Oracle Reports OTN-JOracle Technology Network Japan Oracle Reports


Reports Builder Oracle Reports JSP XML

2.2.2 JSP Web JSP Web Web Web WebReports Builder Web

Reports Server Reports Builder OC4JOracle Container for J2EE JSP JSP Java Reports Builder Builder OC4J Builder

JSP .java .html HTML .html .java .class %REPORTS_TEMP%/docroot%REPORTS_TEMP% Reports Builder docroot docroot Reports Builder

: Netscape 7.0 Netscape 7.0 netscape.exe

2-11

Web

Reports Builder REPORTS_TMP docroot c:/temp/docroot docrootWEBSERVER_DOCROOTJSP docrootWEBSERVER_DOCROOT

JSP .java .class .html HTML .html .java .class docroot emp.jsp docroot docroot %REPORTS_TMP%/docroot

temp docroot 3000 working directory for instance of the Builder default defaultWebApp temporary JSP working directory persistence _pages _empxxx.class compiled Java class _empxxx.java translated Java file log OC4J log directory global-application.log server.log orion-conf OC4J configuration files directory stderr.log debug log when WEBSERVER_LOG=yes stdout.log 3002 another instance's working directory css template style sheets images template images WEB-INF lib reports_tld.jar web.xml rwerror.jsp template error JSP empxxx.jsp working copy of emp.jsp empxxx.html resulting output

2-12 Oracle Reports

Web

ID emp012345678.jsp

docroot Reports Builder

3.7.15.4 Web

3.7.16.3 Web

2.2.3 HTML Web Web HTML Web

Web Web PL/SQL Reports Builder SRW.SET_ATTR

HTML Web

HTML PDF 2.2.5

Web 2.2.6

HTML 2.2.7

URLURL HTML Web Server

HTML

HTML 2.2.9

2-13

Web

HTML

HTML

HTML

HTML

HTML

2.2.4 PDF Web Web PDF PDF

PDF Web

HTML PDF 2.2.5

Web 2.2.6

PDF 2.2.7

2.2.8

Web Web PL/SQL

2-14 Oracle Reports

Web

2.2.5

Web Server HTML PDF

HTML

3.6.7.1.7

3.6.7.2.7 PL/SQL

2.2.6

3.6.7.1.8

3.6.7.2.8 PL/SQL

2.2.7

3.6.7.1.10

3.6.7.2.10 PL/SQL

3.6.7.1.11

2.2.8 PDF

2-15

Web

Web

3.6.7.1.9

3.6.7.2.9 PL/SQL

2.2.9

HTML

HTML

HTML

HTML

HTML HTML

HTML HTML

3.6.7.1.1 HTML

3.6.7.2.1 PL/SQL HTML

3.6.7.1.2 HTML


3.6.7.1.3 HTML


3.6.7.1.4 HTML


2-16 Oracle Reports

Web

3.6.7.1.5 HTML


3.6.7.1.6 HTML


2.2.10 HTML HTML HTML

Web

HTML HTML

HTML

HTML

2-17

3.7.15.4 Web

3.7.16.3 Web

2.3 1.7

2.3.1 %

3.8.7

: 1 1

2-18 Oracle Reports

3.8.8

2.3.2 :ITEMTOT *.07 1 :SAL + :COMM 2 PL/SQL PL/SQL

3.8.7

2.6.8

2.3.3 PL/SQL n

Before Report

3.8.9

2.6.8

2.3.4

:

2-19

2.3.4.1 SQL PL/SQL 1 SELECTWHEREGROUP BYORDER BYHAVINGCONNECT BYSTART WITH FROM

:SELECT Reports Builder

SQL Oracle9i SQL

1:SELECT COMMPLAN NULL DFLTCOMM

SELECT CUSTID, NVL(COMMPLAN, :DFLTCOMM) COMMPLANFROM ORD;

2:WHERE CUST 1

SELECT ORDID, TOTALFROM ORDWHERE CUSTID = :CUST;

3:GROUP BY SELECT NVL(COMMPLAN, :DFLTCOMM) GROUP BY

SELECT NVL(COMMPLAN, :DFLTCOMM) COMMPLAN, SUM(TOTAL) TOTALFROM ORDGROUP BY NVL(COMMPLAN, :DFLTCOMM);

4:HAVING MINTOTAL

SELECT CUSTID, SUM(TOTAL) TOTALFROM ORDGROUP BY CUSTID HAVING SUM(TOTAL) > :MINTOTAL;

2-20 Oracle Reports

5: ORDER BY SORT SHIPDATE ORDERDATE ORDER BY 1 :SORT SELECT DECODE DECODE ORDER BY

SELECT ORDID, SHIPDATE, ORDERDATE, TOTALFROM ORDORDER BY DECODE(:SORT, 1, SHIPDATE, 2, ORDERDATE);

6: CONNECT BY START WITH CONNECT BY START WITH WHERE HAVING

7: PL/SQLprocedure double is begin; :my_param := :my_param*2; end;

my_param2 my_param

2.3.4.2 SELECT SELECTFROMWHEREGROUP BYORDER BYHAVINGCONNECT BY START WITH

PL/SQL PL/SQL SQL

&

NULL

Reports Builder

PL/SQL

CHARACTER

2-21

SELECT

SELECT

SELECT

Reports Builder SQL WHERE

:

SELECT DEPTNO FROM EMP

:

SELECT &PARM_1 COL_1, &PARM2 COL_2FROM EMPWHERE &PARM_1 = :DEPTNO

WHERE DEPTNO DEPTNO

After Form WHERE

SELECT ENAME, SAL FROM EMP&where_clause

WHERE_CLAUSE After Form Before Report

WHERE SAL = :new_bindAfter Form

2-22 Oracle Reports

1:SELECT SELECT &P_ENAME NAME, &P_EMPNO ENO, &P_JOB ROLE

FROM EMP;

P_ENAMEP_EMPNO P_JOB P_EMPNO DEPTNO SELECT Reports Builder

2:FROM SELECT ORDID, TOTAL

FROM &ATABLE;

ATABLE ATABLE ORD SELECT

3:WHERE SELECT ORDID, TOTAL

FROM ORDWHERE &CUST;

CUST ORD WHERE

4:GROUP BY SELECT NVL(COMMPLAN, DFLTCOMM) CPLAN, SUM(TOTAL) TOTAL

FROM ORDGROUP BY &NEWCOMM;

NEWCOMM GROUP BY

5:HAVING SELECT CUSTID, SUM(TOTAL) TOTAL

FROM ORDGROUP BY CUSTID HAVING &MINTOTAL;

MINTOTAL

2-23

6:ORDER BY SELECT ORDID, SHIPDATE, ORDERDATE, TOTAL

FROM ORDORDER BY &SORT;

SORT SHIPDATEORDERDATEORDID CONNECT BY START WITH

7:CONNECT BY START WITH CONNECT BY START WITH WHERE HAVING

8: SELECT &COLSTABLE;

COLSTABLE SELECT FROM COLSTABLE DNAME ENAME, LOC SAL FROM DEPT

SELECT * FROM EMP &WHEREORD;

WHEREORD WHERE ORDER BY &WHEREORD WHERE SAL > 1000 ORDER BY DEPTNO

9:PL/SQL SQLSELECT &BREAK_COL C1, MAX(SAL)

FROM EMPGROUP BY &BREAK_COL;

BREAK_COL SELECT GROUP BY &BREAK_COL JOB GROUP_BY_COLUMN CHARACTER

GROUP_BY_COLUMN PL/SQL GROUP_BY_COLUMN

procedure conv_param (in_var IN char) isbegin

if upper(in_var) in ('DEPTNO','EMPNO','HIREDATE') then:break_col := 'to_char('||in_var||')' ;

else:break_col := in_var;

end if;end;

2-24 Oracle Reports

PL/SQL 1 TO_CHAR SQL BREAK_COL PL/SQL BREAK_COL

2.3.4.3 SQL PL/SQL 1 SELECTWHEREGROUP BYORDER BYHAVINGCONNECT BYSTART WITH FROM

SELECT ORDID,TOTALFROM ORDWHERE CUSTID = :CUST

SELECT SELECTFROMWHEREGROUP BYORDER BYHAVINGCONNECT BY START WITH PL/SQL

SELECT ORDID, TOTALFROM &ATABLE

2.3.5 Reports Builder WHERE

2 WHERE SELECT WHERE 3.8.6

ADDRESS.STREET LOC1 SQL

SELECT * FROM EMP E WHERE E.ADDRESS.STREET = :LOC1

2-25

1.7.4

1.7.1

2.3.4.1


2 1 / 1 2 / 2 / 40 / (+) SELECT

2-26 Oracle Reports

2-3 /

/ / 3 2 / / 1 3 2

2-27

2-4 / /

1.7.2

1.7.4

2.3.7 2 Reports Builder 1

1

1 Reports Builder

2-28 Oracle Reports

2

2 1

Group1 C_DEPTNO C_DEPTNO DEPTNO Group2 C_JOB C_DEPTNO1 C_JOB JOB C_DEPTNO1 Group1 Group3 SUMSAL SAL

Job Analyst Clerk Manager

10 $1300 $2450Dept 20 $6000 $1900 $2975 30 $ 950 $2850

Group2

2-29

Group1

Group4Group1 Group2

Group1 Group2 Group1 LOC

Job Loc Dept Analyst Clerk Manager

New York 10 $1300 $2450 Dallas 20 $6000 $1900 $2975 Chicago 30 $ 950 $2850

1.3.7

2.1.7

2.1.8

3.9.1.3

3.8.5

3.5.3

2.4 1.8

2-30 Oracle Reports

2.4.1

Reports Builder

PL/SQL

Reports Builder

3.5.4

3.10.2

2.6.12.2

Reports Builder

2.4.2 1 Reports Builder Reports Builder Reports Builder

2-31

1

3.5.5

Reports Builder

1.

90

2.

: CHAR LONG

3.

: CHAR LONG

2-32 Oracle Reports

4. M_groupname_FTR

5. Reports Builder 1

%

6. M_groupname_FTR

3.5.4

3.10.2

2.4.3

3.9.8.7

2-33

3.9.8.6

3.9.8.9

HTML URL URL 3.9.8.8 URL 3.9.8.10 URL

Oracle Reports 10g9.0.4REPORTS_OUTPUTIMAGEFORMAT OUTPUTIMAGEFORMAT JPEGPNGBMPTIFFGIFCGMOGD UNIX PostScript screenprinter.ppd

HTML URL URL PDF URL Reports Builder URL HTML

256 OUTPUTIMAGEFORMAT REPORTS_OUTPUTIMAGEFORMAT GIF Oracle Reports GIF 256

UNIX HTML CGM OGDOracle6i Graphics Windows

3.9.8.6

3.9.8.7

2-34 Oracle Reports

3.9.8.8 URL

3.9.8.9

3.9.8.10 URL

2.4.4

2

Reports Builder

2-35

X Y

:

2 Object 1

X X50%Object 1 75% Reports Builder Object 1 25%

2-5

:

2 2 80% Reports Builder 2 80% Y 2 2

2 Object 1

2-36 Oracle Reports

2-6

2.4.4.1 Reports Builder

1.

A A

2

2-37

2

2

2. A B

3. A B

A

2

2

0% 0%

0% 0%

1 1

1

2-38 Oracle Reports

: 2 2

2

2-7 2

M_Sums B_Text1 R_Ename M_Sums B_Text1 R_Ename M_Sums B_Text1 M_Sums R_Ename M_Sums B_Text1 R_Ename

2 B_Text3 M_Emp M_Emp R_MgrB_Text3 M_Emp R_Mgr B_Text3 M_Emp B_Text3 R_Mgr

2-39

B_Text3 R_Ename B_Text2 R_Mgr M_Emp B_Text3 M_Emp

2

Reports Builder B A A A A A

3.9.5.1

3.9.5.2

3.9.5.3

2.4.5 1

Reports Builder

: Windows

2-40 Oracle Reports

3 / / Reports Builder 1

PL/SQL SRW

SRW.SET_BACKGROUND_BORDER_COLOR

SRW.SET_BACKGROUND_FILL_COLOR

SRW.SET_FOREGROUND_BORDER_COLOR

SRW.SET_FOREGROUND_FILL_COLOR

SRW.SET_TEXT_COLOR

SRW.SET_FILL_PATTERN

SRW.SET_BORDER_PATTERN

3.2.6 3.9.6.5

: Windows

2-41

3.9.6.6

3.9.6.2

3.9.6.3

3.9.6.4 PL/SQL

3.9.4.2

Reports Builder Oracle CDE1

Reports Builder PL/SQL SRW

Reports Builder

2.4.6

3.9.12.1

3.9.12.2

3.9.11.3

: g p 2 X Y

2-42 Oracle Reports

2.4.7

1

3.9.4.3

3.9.11.7

3.9.11.2

3.9.11.1

3.9.11.6

2.5 1.9

2.5.1 HTML HTML Web HTML JavaScript Web

HTML HTML 3.6.7.1.14HTML

JavaScript 3.11.12 HTML

HTML

2-43

PL/SQL

3.6.7.1.5 HTML 3.6.7.2.5 PL/SQL HTML

HTML 3.6.7.1.6 HTML 3.6.7.2.6 PL/SQL HTML

1.2.2 Web

1.9.4 Web

2.2.3 HTML Web

2.6 PL/SQLReports Builder PL/SQL

PL/SQL

PL/SQL

PL/SQL

REF

2-44 Oracle Reports

PL/SQL

2.6.1 PL/SQL PL/SQL PL/SQL

*PL/SQL

PL/SQL

PL/SQL

3.13.3.1


3.13.3.2


3.13.2.4 PL/SQL

2-45

PL/SQL

2.6.4 PL/SQL

PL/SQL 37 PL/SQL

PL/SQL

PL/SQL

: PL/SQL

Groups Columns Summary -----------------------------------------RGN REGION RGNSUMSAL SUM(DEPTSUMSAL) COSTOFLIVING DEPT DNAME DEPTNO DEPTSUMSAL SUM(EMP.SAL) JOB JOB HEADCOUNT COUNT(EMP.EMPNO) EMP ENAME EMPNO SAL COMM

: PL/SQL 3.13.5.1 PL/SQL

2-46 Oracle Reports

PL/SQL

COSTOFLIVING PL/SQL

function CompSal(salary number) return number isbegin return (salary*CostofLiving);end;

2 PL/SQL

CompSal(:RGNSUMSAL)

CompSal(:SAL) + COMM

3.13.3.1

2.6.5 Oracle

PL/SQL 1

Oracle PL/SQL PL/SQL PL/SQL

2-47

PL/SQL

3.13.3.2

2.6.6 PL/SQL PL/SQL PL/SQL Before Report PL/SQL

PL/SQL

3.13.5.1 PL/SQL

2.6.7 PL/SQL MYLIB ADDXY PL/SQL ADDXY

PL/SQL

PL/SQL PL/SQL PL/SQL


2-48 Oracle Reports

PL/SQL

2

3.13.5.5 PL/SQL

2.6.8 PL/SQL PL/SQLPL/SQL

PL/SQL

NUMBER NUMBER DATE DATE CHARACTER CHARACTERVARCHAR VARCHAR2

COMP IF :COMP = 10COMP := 15

Reports Builder

SRW.DO_SQL Reports Builder Reports Builder Reports Builder Reports Builder

2-49

PL/SQL

1:

function salcomm return NUMBER isbegin return(:sal + :comm);end;

2: NULL

function calcomm return NUMBER istemp number;begin if :comm IS NOT NULL then temp := :sal + :comm; else temp := :sal; end if; return (temp);end;

2.3.2

3.13.4.3

3.13.4.4

2.6.9 n n PL/SQL PL/SQL PL/SQL

TRUE FALSE TRUE FALSE

2-50 Oracle Reports

PL/SQL

PL/SQLReports Builder 8 8

Reports Builder COUNT1 IF :COUNT1 = 10:COUNT1 := 10PL/SQL

function filter_comm return boolean isbegin if :comm IS NOT NULL then if :comm < 100 then return (FALSE); else return (TRUE); end if; else return (FALSE); -- for rows with NULL commissions

2-51

PL/SQL

end if;end;

3.13.4.2

2.6.10 REF REF PL/SQL REF PL/SQL REF REF SELECT SELECT

REF

REF Oracle

REF

1. SQL

2.

3. Form Builder

4.

5.

REF Oracle

REF PL/SQL

1:REF /* This package spec defines a ref cursor** type that could be referenced from a** ref cursor query function.** If creating this spec as a stored** procedure in a tool such as SQL*Plus,** you would need to use the CREATE

2-52 Oracle Reports

PL/SQL

** PACKAGE command.*/

PACKAGE cv IStype comp_rec is RECORD (deptno number, ename varchar(10), compensation number);type comp_cv is REF CURSOR return comp_rec;END;

2:REF /* This package spec and body define a ref** cursor type as well as a function that** uses the ref cursor to return data.** The function could be referenced from** the ref cursor query, which would** greatly simplify the PL/SQL in the** query itself. If creating this spec** and body as a stored procedure in a** tool such as SQL*Plus, you would need** to use the CREATE PACKAGE and CREATE** PACKAGE BODY commands.*/

PACKAGE cv IStype comp_rec is RECORD (deptno number, ename varchar(10), compensation number);type comp_cv is REF CURSOR return comp_rec;function emprefc(deptno1 number) return comp_cv;END;

PACKAGE BODY cv ISfunction emprefc(deptno1 number) return comp_cv is temp_cv cv.comp_cv;begin if deptno1 > 20 then open temp_cv for select deptno, ename, 1.25*(sal+nvl(comm,0)) compensation from emp where deptno = deptno1; else open temp_cv for select deptno, ename, 1.15*(sal+nvl(comm,0)) compensation from emp where deptno = deptno1;

2-53

PL/SQL

end if; return temp_cv;end;END;

3:REF empCur rcPackage.empCurType;BEGIN OPEN empCur FOR SELECT * FROM emp; RETURN empCur;END;

/* Note, rcPackage is a local program unit defined as: */

PACKAGE rcPackage IS TYPE empCurType IS REF CURSOR RETURN emp%ROWTYPE;END;

4:REF /* This ref cursor query function would be coded** in the query itself. It uses the cv.comp_cv** ref cursor from the cv package to return** data for the query.*/function DS_3RefCurDS return cv.comp_cv is temp_cv cv.comp_cv;begin if :deptno > 20 then open temp_cv for select deptno, ename, 1.25*(sal+nvl(comm,0)) compensation from emp where deptno = :deptno; else open temp_cv for select deptno, ename, 1.15*(sal+nvl(comm,0)) compensation from emp where deptno = :deptno; end if; return temp_cv;end;

5:REF /* This ref cursor query function would be coded** in the query itself. It uses the cv.comp_cv** ref cursor and the cv.emprefc function from** the cv package to return data for the query.** Because it uses the function from the cv

2-54 Oracle Reports

PL/SQL

** package, the logic for the query resides** mainly within the package. Query** administration/maintenance can be** done at the package level (e.g.,** modifying SELECT clauses could be done** by updating the package). You could also** easily move the package to the database.** Note this example assumes you have defined** a user parameter named deptno.*/

function DS_3RefCurDS return cv.comp_cv is temp_cv cv.comp_cv;begin temp_cv := cv.emprefc(:deptno); return temp_cv;end;

3.8.1.9 : REF

2.6.11 PL/SQL 2

PL/SQL PL/SQL Reports Builder SRW

2.6.11.1 Reports Builder SRWReports Builder SRW PL/SQL

SRW PL/SQL SQL

SRW SQL*Plus

2-55

PL/SQL

Reports Builder SRW

2.6.11.2 PL/SQL STANDARD TEXT_IO.PUT_LINE

DDE

Reports Builder DDE

DEBUG

PL/SQL

EXEC_SQL

Reports Builder PL/SQL SQL

LIST

VARCHAR2PL/SQL 1

ORA_FFI

C

ORA_JAVA

PL/SQL Java

ORA_NLS

2-56 Oracle Reports

PL/SQL

ORA_PROF

PL/SQL

TEXT_IO

Text_IO

FILE_TYPE FOPEN IS_OPEN FCLOSE FILE_TYPE

PUTPUTFPUT_LINE NEW_LINE PL/SQL

GET_LINE

TOOL_ENV

Oracle

TOOL_ERR

DEBUG

DEBUG

n-1n TOOL_ERR

TOOL_RES

PL/SQL

2-57

PL/SQL

Oracle Reports

ORA_DE

Reports PL/SQL

STPROC

JNI

PL/SQL Java


2.6.12 PL/SQL

PL/SQL

INSERTUPDATE DELETE

2.6.12.1 PL/SQLPL/SQL TRUE FALSE Reports Builder

2-58 Oracle Reports

PL/SQL

5

Before Report

After Report

Between Pages

Before Parameter Form

After Parameter Form

Reports Builder

Before Report

1.

2. Before Report

3.

After Parameter Form DML DDL Before Report Reports Builder Before Report Reports Builder

3.13.3.5

3.13.3.6

2.6.12.2 PL/SQL 1,000,000


2-59

PL/SQL

Reports Builder 2

Reports Builder SRW PL/SQL

Reports Builder

3.13.4.1

2.6.12.3 PL/SQL

TRUE FALSE

: JSP Web Reports Builder OracleAS Reports Services FALSE REP-0546: 1.9.4 Web

2-60 Oracle Reports

PL/SQL

Reports Builder

3.11.4

2.6.12.4 INSERTUPDATE DELETE INSERTUPDATE DELETE

SQL PL/SQL SQL

Oracle

60 61 PL/SQL

EMP UPDATE EMP AFTER UPDATE

Oracle9i Oracle9i

2-61

3.13.3.7

2.7 Reports Builder

2.7.1

.tdf

2 1

: REPORTS_PATH ORACLE_HOMEreportstemplates

2-62 Oracle Reports

3.12

2.7.2 -

/

CharacterCharacter

NumberNumber

DateDate

CharacterCharacter

NumberNumber

DateDate

CharacterCharacter

NumberNumber

DateDate

CharacterCharacter

NumberNumber

DateDate

2-63

1

:

:

:1 1 2 2

: 2 1 1 1 1

: 1 1

3.12.2

3.12.3

2.7.3

2-64 Oracle Reports

/

2 1

3.12.4

2.7.4


2-65

2.7.5

:

:

2.8 Reports Builder

2-66 Oracle Reports

Pluggable Destinations

XML

HTML

PDF

RTF

ASCII

2.8.1 Oracle Reports 3

SRW.SET_FORMAT_ORDER

TOCTOC TOC TOC TOC TOC

:

2-67

TOC

TOC 34 35

2 8 3 - - 121312345678910112

2.8.2 rwrun

Reports Server BACKGROUND=YES rwclientrwcgi rwservlet

3.7.2

3.7.3

BATCH BACKGROUND Reports Builder

2.8.3 1

2-68 Oracle Reports

1 HTML PostScript

Oracle Application Server Reports Services Web XML OTN-JOracle Technology Network Japan Oracle Reports


DST XML DESTINATION

36 distribution.xml

3.7.11

1 MODE 1 DEFAULTBITMAP CHARACTER1

2.8.3.1 DST DST DESTINATION

:

: DST XML

2-69

DST

DST

dist_ID: output_def

dist_ID

output_def rwrun rwclient

LEVEL

LEVEL

REPORT

Header_Section

Main_Section

Trailer_Section

REPORT

: XML Oracle Application Server Reports Services Web OTN-JOracle Technology Network Japan Oracle Reports


: 3.14.19 DST DST

2-70 Oracle Reports

HTML 3 PDF

;dst file (specified via the DESTINATION keyword on the command line)DEST1: DESNAME=testdst1.HTM DESTYPE=fileDESFORMAT=HTML COPIES=1 LEVEL=ReportDEST2: DESNAME=\\luna\2op813 DESTYPE=printerDESFORMAT=BITMAP COPIES=3LEVEL=Main_SectionDEST3: DESNAME=SECTION1.pdf DESTYPE=fileDESFORMAT=pdf COPIES=1LEVEL=Header_Section

2.1.2

2.8.4 Pluggable Destinations Pluggable Destinations Oracle Reports Reports Server Oracle Reports

Web

OracleAS Portal

Oracle Reports Java API Reports Server

Oracle Application Server Reports Services Web OracleAS Reports Services OTN-JOracle Technology Network Japan Oracle Reports


2-71

2.8.5 AQ /

Oracle Application Server Reports Services Web OTN-J

Oracle Technology Network Japan Oracle Reports http://otn.oracle.co.jp/products/reports/index.html

2.8.6 Before Report Between Pages

SRW.SET_PRINTER_TRAY

3.7.16.5

2.8.7 XML Oracle Reports Extensible Markup LanguageXML

XML Web Reports Builder Oracle Reports XML

XML

XML PDS 41XML

XML XML

2-72 Oracle Reports

EDI

XML XML 3Reports Builder XML XML 3.7.7 XML

XML XML Oracle Application Server Reports Services Web XML OTN-JOracle Technology Network Japan Oracle Reports


3.7.7 XML

3.7.1

Reports Builder XML PDS

2.8.8 HTML Reports Builder Hypertext Markup LanguageHTML Hypertext Markup LanguageHTMLCSSHTML Microsoft Front Page Web Web HTML HTMLCSS OracleAS Portal Web HTML

: HTML HTMLCSS HTML JSP Web Web Web HTML

2-73

Web HTML HTMLCSS HTML HTMLCSS

HTML 2 1 1 1 1 HTML DESNAMEdesnameb.htmdesnamed.htm

GIF HTML GIF GIF

GIF 1 1 GIF

HTML GIF desname0.gif ... desname17.gif

HTML 7 HTML

2-1 HTML

HTML

7 1

8 9 2

10 12 3

13 15 4

16 20 5

21 30 6

31 7

2-74 Oracle Reports

HTML HTML SRW.SET_AFTER_PAGE_HTML

HTMLCSS

HTML HTMLCSS Reorts Builder HTML HTMLCSS

HTML HTMLCSS 2.8.8.1 HTML

2

GIF

HTML HTML

: HTML TeleType

2-75

HTML

HTML HTML HTML

HTML

PDF HTML

HTML

1.2.2 Web

2.2.3 HTML Web

3.7.5 HTML HTMLCSS

2.8.8.1 HTML HTML HTML/HTMLCSS Web 1

PL/SQL Before Report SRW.SET_PAGE_NAVIGATION_HTML

2-76 Oracle Reports

HTML HTML HTML myreport.htm

myreport.htm

myreportb.htm HTML

myreport_1.htm myreport_n.htm

myreportj.htm JavaScript

HTML HTML Before ReportAfter ReportSRW.SET_BEFORE_REPORT_HTML SRW.SET_AFTER_REPORT_HTML PL/SQL HTML SRW.SET_BEFORE_PAGE_HTML PL/SQL Reports Builder HTML

HTML HTMLCSS PAGESTREAM=YES Reports Builder

3.7.15.5 HTML

3.6.7.1.12 HTML


2-77

2.8.9 PDF Reports Builder PDF PDF OracleAS Portal Web PDF

Oracle Reports PDF Oracle Application Server Reports Services Web Oracle Reports PDF OTN-JOracle Technology Network Japan Oracle Reports


Web PDF PDF

PDF Acrobat 4.0 CID Acrobat 4.0 CID

PDF PostScript

1.2.2 Web

2.2.4 PDF Web

3.7.6 PDF

: Oracle Reports PDF Windows UDC 1 TTF TTC

2-78 Oracle Reports

2.8.10 RTF Reports Builder Rich Text FormatRTFRTF Microsoft Word RTF OracleAS Portal Web RTF

90

PDF

3.7.8 RTF

3.7.1


Oracle Reports

DelimitedData

desformat=DELIMITED DELIMITER

: Office 95 Microsoft Word

2-79

DelimitedData DelimitedData

(1,000,000),(3,6000),(543),(2,003,500)

Microsoft Excel .csv Microsoft Excel Excel Excel Oracle Reports .csv Windows

Microsoft Excel .csv :

1. Microsoft Excel

2. root_directoryoperating_systemProfilesuser_nameApplication DataMicrosoftExcelXlstartroot_directoryProgram FilesMicrosoft OfficeOfficeXLStart personal.xls

3. Excel personal.xls

: personal.xls personal.xls

: XLStartXLStartMicrosoft Excel XLStartExcel

2-80 Oracle Reports

4. Oracle Reports .csv Excel

A B A B Reports Builder A B

2-8 B A

ABA B

2-81

2-9

CDB A D C

2-82 Oracle Reports

2-10 2

Reports Builder

2-83

2-11

"ID"Microsoft Excel Excel

ID, name, title, dept

ID id

3.7.9

3.7.1

1.2.2 Web

2.8.12 Reports Builder MODE=CHARACTER MODE MODE=BITMAP MODE PostScript PostScript PostScript

2-84 Oracle Reports

3.7.10

2.8.13 ASCII ASCII

3.5.9 ASCII

3.2.5 ASCII

3.7.1

2.9 Oracle Reports 3.15.1 Oracle

Reports Builder

2-2

/ ASCII

2-85

Oracle Net Services

Oracle Call InterfaceOCI

Reports Builder

PDS

2.9.1

Reports Runtime rwrun

Reports Builder DBA

: .rep .rdf Reports Runtime

2-86 Oracle Reports

3.16.1

2.9.2 Oracle Net Services Oracle Net Services Oracle Oracle Net Services Oracle Net Services Net8 SQL*Net

2.9.3 Reports Builder Reports Builder Reports Builder LONG RAW PL/SQL ORACLE Precompiler ORACLE Call InterfaceOCI ORACLE

ORA_JAVA Java Importer JavaORA_FFI C Oracle Reports

2.9.4 Oracle Call InterfaceOCIOracle Call InterfaceOCIOracle Reports 3GL C Reports BuilderReports Runtime Reports Converter Pro*FORTRAN Reports Builder Reports Runtime RWCRRB

OCI rwclient JSP

2-87


PL/SQL

PL/SQL

2.10.1

3.14.1

3.14.2

2.10.2 PL/SQL PL/SQL PL/SQL SQL

PL/SQL 2

:

: Reports Builder PL/SQL

2-88 Oracle Reports

: PL/SQL

2.10.3 PL/SQL

2.10.4 PL/SQL PL/SQL

2-3

|

=>

-

B(n) n ID

T(n) n ID

2-4 PL/SQL

CREATE

DELETE

2-89


ID ID Reports Builder

1 ID

2

PL/SQL

DESCRIBE

EXPORT 1

LIST

LOG PL/SQL

RESET

SET SET

PL/SQL SET

SHOW

2-4 PL/SQL

2-90 Oracle Reports

10 20

PL/SQL GO STEP RESET


PL/SQL

1. 5 23

2. PL/SQL

3. PL/SQL

DEBUG/BREAK my_proc 10 NUMBER my_sal 5,000

PL/SQL>line 10 is+> IF Debug.Getn('my_sal') > 5000 THEN+> Raise Debug.Suspend;+> END IF;

2.10.5.1 PL/SQL


PL/SQL

PL/SQL 1

2-91

NULL

3.14.3

3.14.4

2.10.6 PL/SQL PC

PL/SQL PL/SQL

LIST

.LIST PC

2.10.7 PL/SQL 1 PL/SQL

3.14.14


2-92 Oracle Reports

PL/SQL

0 1 1 2

PL/SQL PL/SQL PL/SQL 1

(debug 1)PL/SQL>

2.10.9

Reports Builder

3.14.13

: RESET

2-93

2-94 Oracle Reports

3

Oracle Reports Reports Builder 3.1.1

3.1 Oracle Reports

3.2

3.3

3.4

3.5

3.6 Web

3.7

3.8

3.9

3.10

3.11

3.12

3.13 PL/SQL

3.14

3.15


3-1

Oracle Reports

3.1 Oracle Reports Oracle Reports


[F1]

[F1]

3.1.2

3-1 Oracle Reports

Oracle Reports Getting Started with Oracle ReportsOTNOracle Technology Network Oracle Reports

http://otn.oracle.com/products/reports/index.html

: Reports Builder

3-2 Oracle Reports

Oracle Reports



:



:

Web

Oracle Reports OTN-JOracle Technology Network Japan Oracle Reports http://otn.oracle.co.jp/products/reports/index.html

[F1]

[F1]

OracleAS Reports ServicesReports Server

Oracle Application Server Reports Services Web OTN-JOracle Technology Network Japan Oracle Reports


Oracle Reports Application Program InterfaceAPI

Oracle Reports SDKOTNOracle Technology Network Oracle Reports http://otn.oracle.com/products/reports/index.html

3-1 Oracle Reports

3-3

3.2

ASCII

3.2.1 :

Getting Started with Oracle ReportsOTNOracle Technology Network Oracle Reports

http://otn.oracle.com/products/reports/index.htmlIndexOracle Reports

Oracle Developer Suite CD

Express

Bean

XML

Oracle Reports

OTN-JOracle Technology Network Japanhttp://otn.oracle.co.jp

3-1 Oracle Reports

3-4 Oracle Reports

1.10.1

3.2.2 :

1.

2.

3.2.3 :

1.

2.

3.

4.

3.2.4 :

3-5

1.

2.

3. OK

1.5.1

3.2.5 ASCIIASCII :

1.

2.

3.

4.

132180 66 102 85 116

5.

6. MODE

Character

7.

1

:

3-6 Oracle Reports

OK

8.

9.

10

OK

10.Courier12

3.5.9 ASCII

3.2.6 :

1.

2.

: Reports Builder

- :

- :

3-7

3. Reports Builder

2.4.5

3.9.6.6

3.9.6.5

3.9.6.2

Reports Builder Oracle CDE1

3.2.7 :

1.

2.

3.

4.

1 DATE ORACLE DD-MON-YY

:

3-8 Oracle Reports

1.10.1.1

3.2.8 :

1. 1

2.

3. 2

2 2 1 2 1

3.3 Reports Builder

Oracle Reports 10g Oracle Software Configuration ManagerSCM

3-9

3.3.1 Reports Builder :

1.

2.

:

rwbuilder rwrunUSERID

USERID=username[/password][@database]USERID Reports Builder

3.3.2 :

1.

2. Reports Builder

3.3.3 :

1.

2.

3.3.4 :

1.

2.

3.

3-10 Oracle Reports

3.3.5 :

1.

2.

:

1. Windows Windows Explorer

2.

3.

3.3.6 :

1.

2.

:

1. Windows Windows Explorer

2.

3.

3.3.7 Oracle Reports 10g Oracle Software Configuration ManagerSCM

SCM SCM / Oracle Reports Oracle SCM

3-11

3.3.8

3.3.8.1 :

:

1.

2.

3.3.8.2 :

[Shift]

[Ctrl]

:

1.

2.

[Shift]

3-12 Oracle Reports

3.3.8.3 :

1.

2.

3.3.8.4

3.3.8.5

3.3.8.6 :

1.

2.

3.

3.3.8.7 :

[Ctrl]

:

3-13

[Shift]

3.3.8.8 :

3.3.9 :

1.

2.

3.3.10 :

3.4

: 1 [Shift]

3-14 Oracle Reports

1.5.1

3.4.1

1.6.2

1.6.3

1.6.5

1.6.6 Web

3.4.2 1

:

3-15

3.4.3 :

1.

2.

3.

3.4.4 :

:

1.5.2

3.4.5 3.2.4

3.5 Web

3-16 Oracle Reports

ASCII

3.5.1 :

1.

2. OK

3.

4. Web

:

5. 1 3.8.1.2 :

6. 3.5.4

1.2.1

1.3.1

1.3.2

1.3.3

1.3.4

1.3.5

1.3.6

1.3.7

2.1.7

3-17

2.1.8

3.5.2 11 2

3.5.3 26

3.5.4 :

1.

2. 1

3.

2.4.2

3.10.2

3.9.13.3

3.5.5 :

:

3-18 Oracle Reports

1.

2.

3.

4.

5.

3.5.6 :

1.

2.

3.

4. 3.12.5

2.1.1

2.7.1

3.5.7 TOCSRW.SET_FORMAT_ORDER TOC TOC TOC TOC

:

3-19

TOC TOC

34 35 2

2.8.1

3.5.8

34

3.5.9 ASCIIASCII :

1.

2.

3.

4.

(RDF)

5.

6. OK

7.

3-20 Oracle Reports

Web

2.8.13 ASCII

3.2.5 ASCII

3.5.10 1 GUI

: GUI 2

GUI GUI

uifont.ali

: GUI GUI GUI

DPI: DPI DPI DPI DPI

3.5.11 National Language SupportNLSReports Builder

3.6 Web Web

Web

Web

Web HTML

3-21

Web

Web

Web

Web

Web

1.2.2 Web

3.6.1 Web Web

3.5.1 Web Web

Web Web 3.6.3 Web HTML 3.6.4 Web

Web Oracle Reports JSP Reports Builder

Web Web Web Web

Web 3.6.6 Web

3.6.2 Web Web :

Web Web

Reports Builder Oracle Reports JSP

3-22 Oracle Reports

Web

3.6.3 Web HTML Web HTML :

1.

2. Web HTML

3. HTML REP1

4.

Web

3.6.4 Web

3.6.4 Web Web :

1.

2. Web HTML

3. HTML REP1

4. Web

5. Web Web Web

6.

: Web

3-23

Web

7.

8.

3.6.5 Web 3.9.8.4 Web

3.9.8.5 Web

3.9.8.2

3.6.6 Web Web :

1. Web

HTML 3.6.7.1.1

HTML 3.6.7.1.2

HTML 3.6.7.1.3

HTML 3.6.7.1.4

HTML 3.6.7.1.5

HTML 3.6.7.1.6

3.6.7.1.7 3.6.7.1.8

PDF 3.6.7.1.9

3.6.7.1.10

2.

3. Web 3.7.15.4 Web

: Place the report block here Web

3-24 Oracle Reports

Web

1.2.2 Web

2.2.3 HTML Web

2.2.4 PDF Web

3.6.7 Web HTML PDF JSP Web Web Web HTML

Web

PL/SQL

3.6.7.1 Reports Builder Web

HTML

HTML

HTML

HTML

HTML

HTML

HTML

3-25

Web

URL

HTML

HTML

HTML

1.2.2 Web

2.2.3 HTML Web

2.2.4 PDF Web

2.2.9

3.6.7.1.1 HTML

HTML HTML :

1.

2.

3. ... HTML HTML


3.6.7.1.2 HTML

HTML HTML :

1.

: HTML

: HTML

3-26 Oracle Reports

Web

2.

3. ... HTML HTML


3.6.7.1.3 HTML

HTML :

1.

2.

3. ... HTML HTML

HTML 1 :


3.6.7.1.4 HTML

HTML :

1.

2.

: HTML

: HTML

3-27

Web

3. ... HTML HTML

HTML 1 :


3.6.7.1.5 HTML

HTML :

1.

2.

3. ... HTML HTML

2.5.1 HTML


3.6.7.1.6 HTML

HTML :

1.

2.

: HTML

: HTML

3-28 Oracle Reports

Web

3. ... HTML HTML

2.5.1 HTML


3.6.7.1.7

:

1. Web

2. Web

3. Web

4. Web

Reports Builder

5. HTML

2.2.5

3.6.7.2.7 PL/SQL

:

: PDF

3-29

Web

3.6.7.1.8

:

1. Web

2. Web

3. Web

2.2.6

3.6.7.2.8 PL/SQL

3.6.7.1.9

:

1.

2.

3. Web

:

: PDF

:

3-30 Oracle Reports

Web

Web

2.2.8

3.6.7.2.9 PL/SQL

3.6.7.1.10

HTML PDF :

1.

2.

Web

2.2.7

3.6.7.2.10 PL/SQL

3.6.7.1.11

HTMLCSS PDF :

: PDF

:

3-31

Web

1.

2.

3. OK

2.2.7

3.6.7.2.10 PL/SQL

Oracle Reportsレポート作成ガイド,...

Documents

Transcript of Oracle Reportsレポート作成ガイド,...