HAND : : 2000 11 28 : 2000 11 28 : MD060 : 1 : 1 2
MD060 2000/02/2 1 1 1 1 ii
MD060...ii...4...4...4...4...4...4...4...4 Date Model...4...4...4...4...4...4...4...4 Layout...4...4...4...4...4...4 Parameter Form...4...4 Report Triggers...4...4...4 Program Units...4 Attached Libraries...4 PL/SQL...4 PL/SQL...4...4...4...4...4 iii
MD060...4 Reports Applications...4 Report...4 Application Reports...4 Reports...4 iv
MD060 Oralce Reports Hand 5
MD060 Oracle SQL PL/SQL Oracle 6
MD060 Developer 2000 1.6 Oracle Reports 2.5 Oracle Applications 11 Oracle Forms & Reports 6I 6 I Oracle Applications 11 I 2.5 6I 7
MD060 Oracle Reports2.5 Oracle Reports 1 Oracle Oracle 2 Developer/2000-Reports 2.5 8
MD060 3 Oracle network/admin SQLNET.ORA TNSNAMES.ORA SQL*NET Oracle SQLNET.ORA TRACE_LEVEL_CLIENT = OFF names.directory_path = (TNSNAMES) names.default_domain = world name.default_zone = world TNSNAMES.ORA SSE.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = ) (COMMUNITY = tcp.world) (PROTOCOL = TCP) (Host = 10.7.100.7) (Port = 1521) 9
) MD060 (CONNECT_DATA = (SID = ora816) ) ) 4 Reports Designer File/Connect Oracle Reports 10
MD060 1 SQL VIEW CAT VIEW SQL> desc cat; ------------------------------- -------- ---- TABLE_NAME NOT NULL VARCHAR2(30) TABLE_TYPE VARCHAR2(11) SELECT TABLE_NAME,TABLE_TYPE FROM CAT; 2 Reports Designer \ \Developer 2000 for NT\ Reports Designer Reports Designer File\Connect Connect 3 Date Model Date Model SQL Q_1Q_1 Q_1 Select Statement SELECT TABLE_NAME,TABLE_TYPE 11
FROM CAT; MD060 OK 4 Layout Date Model Default Layout Style Tabular 12
MD060 Data/Selection Report Down Column TABLE_NAME Label TABLE_TYPE OK 13
MD060 5 File\Save test1.rdf 14
6 MD060 Object Navigator Run Run Report rdf rep 1 Object Navigator File \Administration\Generate rdf rep test1.rep 15
2 MD060 \ \Developer 2000 for NT\Reports Runtime Reports Runtime File \Connect File\Run rep Run Report Print Reports R untime Windows C:\ORANT\BIN \R25RUN32.EXE d:\test1.rdf system/manager@meng_prod Forms application Application Report Server Web 16
MD060 Date Model Queries Groups Columns Links Parameter Queries Groups Columns Links Parameter 17
MD060 18 SQL SELECT Tabular Mailing Label Form Letter
MD060 q_ g_ q_emp g_emp First Filter n Last Filter n PL/SQL PL/SQL PL/SQL PL/SQL PL/SQL 1 SELECT 19
MD060 RAW LONG RAW URL REF Read from File Yes Report Builder REPORT30_PATH Read from File No BMPCALSCGMGIFJFIF PCD PCXPICTRASTIFF 2 1 Formula Column SAL*1.2 SAL SAL+COMM SALCOMM PL/SQL CF_n PL/SQL PL/SQL 2 Placeholder Column PL/SQL CP_n n Before Reports PL/SQL 3 Summary Column Oracle Reports 20
MD060 1 Name 30 SELECT CF_n CP_n CS_n n Comment 64K Datatype CharacterDateLongLong Raw NumberRawRefVarcharVarchar2 Num ber Number Width Value if Null 2 Break Order PL/SQL PL/SQL Formula PL/SQL 3 PL/SQL PL/SQL Formula PL/SQL 4 Function Source Computer At Reset At Product Order Product Order 21
MD060 // SQL WHEREHAVINGSTART WITH SQL / SQL HAVING START WITHWHERE =< <=>>=<> 22
MD060 SELECT PL/SQL 11 BACKGROUN D COPIES YesNo No 1 CURRENTY DECIMAL. DESFOMAT DESNAME DfltPslan80 Dflt Dflt DESTYPE FileMailScreen Screen Printer MODE ORIENTATIN PRINT JOB BitmapCharacter Landscape Portrait Landscape Portrait YESNO PRINT JOB Default Landsca pe Portrait YES THOUSANDS, SELECT WHERE SELECT SELECT SELECT 23
MD060 1 SQL PL/SQL : SELECT FROM 2 SELECT FROM WHERE GROUP BY ORDER BY HAVING CONNECT BY START WITH & PL/SQL PL/SQL 3 WHEREGROUP BYORDER BY HAVING CONNECT BYSTART WITH & SELECT 24
MD060 25
MD060 Layout 26
MD060 Header 27
Body Margin MD060 Frames Repeating Frames Fields Boilerplate Anchors Buttons OLE2 Oracle Graphics Frames M_n n Boilerplate 28
MD060 SELECT SELECT Reporting Frames / Source Print Drection / / Maximum Record per Page 3 Minimum Widow Records 3 Column Mode 2 3 3 2 29
MD060 / / Fields 1 ¤t date&logical page number &panel number &physucal page number &total logical pages &total panel &total physical pages CopiesBackground &fieldname Boilerplate 30
MD060 26-1 ok 4 GMG Oracle 31
MD060 32 GGMOracle URL Anchors 26-6 26-2 26-6 F_2 1 26-7 2
MD060 26-8 50% 75% 26-9 50% 75% PL/SQL 33
MD060 PL/SQL PL/SQL PL/SQL OLE2 OLE2 OLE2 OLE2 OLE2 OLE2 OLE2 OLE2 OLE2 Insert Object 26-10 OK OLE2 OLE2 Oracle Graphics Oracle Graphics Oracle Graphic 31 31.3 Builder 8 Tabular 34
MD060 35 Form-like Mailing Label Form Letter Fieldname 26-14 (Group Left) Group Above
MD060 26-16 Matrix Matrix Crosstab Reports Cross-Product Group Matrix With Group 36
MD060 Parameter Form 1 37
MD060 Report Triggers PL/SQL Before Parameter Form PL/SQL 38
After Parameter Form MD060 Befor Reort Between Pages After Report Oracle*Mail 39
MD060 Program Units PL/SQL PL/SQL 40
MD060 Attached Libraries PL/SQL PL/SQL PLL PL/SQL PL/SQL PLL Reports Designer 41
MD060 1 PL/SQL Libraries PL/SQL Libraries Program Units Attached Libraries 2 Program Units 3 4 PL/SQL PL/SQL PL/SQL Oracle 1 Attached Libraries Attach library 42
MD060 2 PL/SQL Find PL/SQL Attach PL/SQL 3 Yes REPORTS25_PATH Reports 2.5 REPORTS60_PATH Reports 6I No PL/SQL PL/SQL 43
MD060 1 2 3 4 1 2-3 - select dept,job,sum(sal) from emp group by dept,job order by dept,job ; Q_1 G_1 44
4 G_1 DEPT JOB G_2G_3 MD060 5 G_2G_3 6 Matrix Date/Select G_3 Repeat Across 45
MD060 46
MD060 7 select disti nct dept from emp; 47
select distinct job from emp; MD060 select dept,job,sum(sal) from emp group by dept,job order by dept,job; G_1G_2 G_1 dept G_3 dept1 G_2 job G_3 job1 48
MD060 6 Matrix Date/Select G_2 Repeat Across dept1 job1 49
MD060 50
MD060 create table emp( dept varchar2(10), job varchar2(10), sal number) ; insert into emp(dept,job,sal) values('dept1','job1',10); insert into emp(dept,job,sal) values('dept1','job2',70); insert into emp(dept,job,sal) values('dept1','job3',60); insert into emp(dept,job,sal) values('dept2','job1',50); insert into emp(dept,job,sal) values('dept2','job2',40); insert into emp(dept,job,sal) values('dept2','job3',30); insert into emp(dept,job,sal) values('dept3','job1',10); insert into emp(dept,job,sal) values('dept3','job2',20); insert into emp(dept,job,sal) values('dept3','job3',100); commit; 51
MD060 52
MD060 Reports Applications Report Report Reports Designer Report Report FTP rdf reports CUX Application Reports / 53
MD060 / 54
Reports / / Report / /
MD060 56