Oracle_ch7_Morrison

Oracle_ch7_Morrison - ORACLE 7 Creating Database Reports...

Info iconThis preview shows pages 1–27. Sign up to view the full content.

View Full Document Right Arrow Icon
ORACLE – 7 Creating Database Reports Jason C. H. Chen, Ph.D. Professor of MIS School of Business Administration Gonzaga University Spokane, WA 99258 chen@jepson.gonzaga.edu
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-2 Term Project r 1. Follow the format and requirements stated on the syllabus and samples. . 2. SDLC approach . 3. Database design requirements . ER-D, Functional dependency, normal forms . 4. Oracle implementation . Make up 3-5 good queries such as MVC mini project . Database creation, report and integrated database applications (chapter 8) . Create custom Forms with button (chapters 5, 6) . The more good features you learned yourself and added to the proejct the better your project grade will be.
Background image of page 2
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-3 Lesson A Objectives r Understand Reports Builder report styles . Use the Report Wizard to create a report . Configure the appearance of a report . View a report in a Web browser . Create a master-detail report . Create a custom template . Apply a custom template to a report
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-4 SQL PL/SQL GUI Components (reports, forms, graphics etc.) D.B. ORACLE (programming language components)
Background image of page 4
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-5 Introduction to Reports Builder Database Reports r Reports Builder allows developers to distribute reports as: . Web pages . pdf files . Printed . And other formats . Layout styles include: . Tabular (Figure 7-1) . Form (one record per page) . Mailing Label (multiple columns on each page) . Form Letter (recipient’s name and address and others) . Group left and group above (Figures 7-2,7-3; master-detail relationship) . Matrix (Figures 7-4, 7-5)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-6 Tabular report in a Web browser (p.514)
Background image of page 6
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-7 Group left report (p.515)
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-8 Group above report (p.516)
Background image of page 8
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-9 Sample Matrix Report (p. 517)
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-10 Using the Report Wizard to Create a Report r Basic three steps using Report Wizard: . Specify the data that the report displays . Select the report style . Configure the report properties and layout Step 1 Run the following script files (p.520) @ c:\oradata\chapter7\northwoods.sql @ c:\oradata\chapter7\clearwater.sql Step 2 Start Reports Builder (Select Oracle Developer Suite Report Developer Report Builder)
Background image of page 10
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-11 Step 3 (p.521)
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-12 Step 3 (p.521)
Background image of page 12
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-13 Step 4 (p.521)
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-14 Step 5: Specify the title, style, and data source (p.521)
Background image of page 14
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-15 Step 6
Background image of page 15

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-16 Steps 7, 8 (p.521)
Background image of page 16
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-17 Steps 7, 8 (p.521)
Background image of page 17

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-18 Step 1 (p.521)
Background image of page 18
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-19 Step 2 (p.521) – The Totals page.
Background image of page 19

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-20 Step 3 (p. 522) – after modifying the field labels and widths.
Background image of page 20
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-21 Step 4 (p.522) – The Template page (Select Peach )
Background image of page 21

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Business Database Systems (A Guide to Oracle 9i) - Dr. Chen TM Oracle-22 Step 4 (p.522)
Background image of page 22