1 / 29

Creating Database Reports

Creating Database Reports. Creating reports. Opening report builder. Use report wizard to create a report. Using report wizard. Click OK on the welcome page and then specify the type of report that you want to create. Using report wizard. Name your report and select the desired style.

toni
Download Presentation

Creating Database Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Creating Database Reports Eyad Alshareef

  2. Creating reports Eyad Alshareef

  3. Opening report builder Eyad Alshareef

  4. Use report wizard to create a report Eyad Alshareef

  5. Using report wizard • Click OK on the welcome page and then specify the type of report that you want to create Eyad Alshareef

  6. Using report wizard • Name your report and select the desired style Eyad Alshareef

  7. Using report wizard • Select SQL query as a basis for the report • Build your query (you may be asked to log in at this point) Eyad Alshareef

  8. Using report wizard • Designate columns as group fields Eyad Alshareef

  9. Using report wizard • Select columns to appear in the report Eyad Alshareef

  10. Using report wizard • Specify labels and field length for each of the items Eyad Alshareef

  11. Using report wizard • Select a template Eyad Alshareef

  12. Using report wizard • Finish and view your report Eyad Alshareef

  13. Viewing Web report Eyad Alshareef

  14. Reports • Snapshot summary of database data • Viewed on screen • Printed on paper • Printed to a file and distributed electronically Eyad Alshareef

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

  16. 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

  17. 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

  18. Creating a Report Using the Report Wizard • 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

  19. Creating a Master-Detail Report • Specify the master and detail records on the Report Wizard Groups page • Detail records remain in Available Fields list Master records Detail records Eyad Alshareef

  20. 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

  21. 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

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

  23. The Report Wizard Templates Page Eyad Alshareef

  24. Report Builder Windows • Live Previewer • Shows how report will look when viewed or printed • Layout Model • Shows report components symbolically • Data Model • Shows underlying report data structure Eyad Alshareef

  25. Live Previewer Eyad Alshareef

  26. Data Model • Shows report data components Query Data link Record group Eyad Alshareef

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

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

  29. Layout Model • Shows reports components symbolically Eyad Alshareef

More Related