Creating Database Reports Eyad Alshareef Edited by Dr

Creating Database Reports Eyad Alshareef, Edited by: Dr. Mostafa Ali 1

Creating reports Eyad Alshareef, Edited by: Dr. Mostafa Ali 2

Opening report builder Eyad Alshareef, Edited by: Dr. Mostafa Ali 3

Use report wizard to create a report Eyad Alshareef, Edited by: Dr. Mostafa Ali 4

Using report wizard n Click OK on the welcome page and then specify the type of report that you want to create Eyad Alshareef, Edited by: Dr. Mostafa Ali 5

Using report wizard n Name your report and select the desired style Eyad Alshareef, Edited by: Dr. Mostafa Ali 6

Using report wizard n n Select SQL query as a basis for the report Build your query (you may be asked to log in at this point) Eyad Alshareef, Edited by: Dr. Mostafa Ali 7

Using report wizard n Designate columns as group fields Eyad Alshareef, Edited by: Dr. Mostafa Ali 8

Using report wizard n Select columns to appear in the report Eyad Alshareef, Edited by: Dr. Mostafa Ali 9

Using report wizard n Specify labels and field length for each of the items Eyad Alshareef, Edited by: Dr. Mostafa Ali 10

Using report wizard n Select a template Eyad Alshareef, Edited by: Dr. Mostafa Ali 11

Using report wizard n Finish and view your report Eyad Alshareef, Edited by: Dr. Mostafa Ali 12

Viewing Web report Eyad Alshareef, Edited by: Dr. Mostafa Ali 13

Reports § Snapshot summary of database data § § § Viewed on screen Printed on paper Printed to a file and distributed electronically Eyad Alshareef, Edited by: Dr. Mostafa Ali 14

Introduction to Reports Builder Database Reports n Reports Builder n n Allows application developers to create reports that display data from Oracle 10 g database Developer 10 g n Reports Builder allows developers to preview and distribute reports in variety of different formats including: n Web pages n Portable document format (. pdf) files Eyad Alshareef, Edited by: Dr. Mostafa Ali 15

Report Uses § A report can: § § Display SQL query data Display summary columns Display calculated values based on formulas applied to database data Be formatted to look like an invoice or other business document Eyad Alshareef, Edited by: Dr. Mostafa Ali 16

Report Styles § § § Tabular (table-format) Form-like (looks like a form) Mailing labels Form letters Group left and Group above § § Displays master-detail relationships Matrix and Matrix with group § Data value appears at the intersection of a column and row heading Eyad Alshareef, Edited by: Dr. Mostafa Ali 17

Creating a Report Using the Report Wizard 1. 2. 3. 4. 5. Enter the SQL query to retrieve all of the report data Choose the display fields Specify the report master-detail groups Specify the field prompts Select a predefined template Eyad Alshareef, Edited by: Dr. Mostafa Ali 18

Creating a Master-Detail Report n Specify the master and detail records on the Report Wizard Groups page n Detail records remain in Available Fields list Master records Detail records Eyad Alshareef, Edited by: Dr. Mostafa Ali 19

Using Format Masks in Reports Format masks can be applied to: § § NUMBER fields DATE fields Format masks cannot be applied to text fields Eyad Alshareef, Edited by: Dr. Mostafa Ali 20

Report Templates Specify report appearance characteristics § § § § Font sizes, types and colors Graphic images Background shading Page numbering Date report is created Stored in a file with a. tdf extension Eyad Alshareef, Edited by: Dr. Mostafa Ali 21

Applying Templates to Reports n Use the Report Wizard Templates page to specify: The name of a predefined template n The file path specification to a custom template n n To register a template file as a custom template, modify the Developer global preferences file (cagprefs. ora) Eyad Alshareef, Edited by: Dr. Mostafa Ali 22

The Report Wizard Templates Page Eyad Alshareef, Edited by: Dr. Mostafa Ali 23

Report Builder Windows n Live Previewer n n Layout Model n n Shows how report will look when viewed or printed Shows report components symbolically Data Model n Shows underlying report data structure Eyad Alshareef, Edited by: Dr. Mostafa Ali 24

Live Previewer Eyad Alshareef, Edited by: Dr. Mostafa Ali 25

Data Model § Shows report data components Query Data link Record group Eyad Alshareef, Edited by: Dr. Mostafa Ali 26

Data Model Components Record group: set of records with the same column headings § § Column Master-detail reports have multiple record groups Default record group name: G_first_column_name Individual fields are called columns Eyad Alshareef, Edited by: Dr. Mostafa Ali 27

Report Column Types n Database – Scalar n n Summary n n Discrete data value retrieved from database Data value calculated by applying a summary function to a report column Formula n Data value calculated by applying a user-defined PL/SQL function to a report column Eyad Alshareef, Edited by: Dr. Mostafa Ali 28

Layout Model § Shows reports components symbolically Eyad Alshareef, Edited by: Dr. Mostafa Ali 29