1 / 53

Oracle Reports: Master-Detail Report Styles & Types

Learn about the different report styles and types in Oracle Reports, including tabular, master-detail, cross-tabulation, and drill-down reports.

vella
Download Presentation

Oracle Reports: Master-Detail Report Styles & Types

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. Week 6March 1 Oracle Reports: Master-Detail Report

  2. Report Styles A tabular report is the most basic type of report. Each column corresponds to a column selected from the database. A form-like report displays one record per page, inserting field values to the right of field labels. A mailing label report prints mailing labels in multiple columns on each page. You can print the labels across the page and then down, or down and then across. A form letter report contains database values embedded in boilerplate text. (Boilerplate text is any text that you enter or import into a Report Editor.)

  3. Report Styles A group left report divides the rows of a table into "sets," based on a common value in one of the columns. Use this type of report to restrict a column from repeating the same value several times while values of related columns change. A group above report contains two or more groups of data. For every value of the master group, the related values of the detail group(s) are fetched from the database. A matrix (cross-tabulation) report contains one row of labels, one column of labels, and information in a grid format that is related to the row and column labels. A distinguishing feature of matrix reports is that the number of columns is not known until the data is fetched from the database. A matrix with group report is a group above report with a separate matrix for each value of the master group.

  4. Types of Reports • Tabular • Master-detail • Cross-tabulation • Drill-down (and roll-up)

  5. Tabular Report Columns

  6. Group (Master-Detail) Report Master Detail Group totals

  7. Matrix Report Category 2 Category 1 Row totals Column totals

  8. Drill-Down Report Highest Level Report Drill-down

  9. Drill-Down Report Next Highest Level Report Drill-down

  10. Drill-Down Report Lowest Level Report Drill-down Year  Quarter  Months

  11. Oracle Reports Object Navigator Data Model Layout Model

  12. Basic Report Objects • Data Model • Layout Model • Triggers

  13. Data Model SQL

  14. Data Model Objects • Component objects: • Queries • SQL statements • Links • Establishes the relationship between the data of two queries (e.g., master/detail) • Groups • Similar to control groups in control break reports • Columns • Data on the report (vertical arrangement) • Summary, formulas or placeholders

  15. Report Layout Model Header Frame Field Body

  16. Layout Model Objects • Frames - contains groups of data and objects (similar to a block) • Repeating frames - represent one record in a group • Fields -placeholders for data • Boilerplate - labels, lines or graphics • Anchors - used for relative positioning of child to parent • Buttons • OLE2 objects

  17. Basic Tabular Report

  18. Reports • Purpose - Format a large amount of data in a reasonable fashion in a very timely manner • Components Page Header Appears only at the beginning of the report 1 Body 1 Logical pages reside within a component 2 Margin Data Model 3 4 Appears only at the end of the report 1 Trailer

  19. Creating A Report • Build the data model • Assign the fields to the report • Arrange the report in the layout model editor • Test the report • Use the report layout editor to format the report

  20. Report Styles

  21. Data Model Build the query in SQL Plus and paste it into the data model

  22. Select the Columns

  23. Select Columns to Aggregate

  24. Specify Column Widths

  25. Select Report Background

  26. Basic Report Layout

  27. Working with Frames Page Heading Page Field Repeating Group

  28. Master-Detail Report Page heading Control heading Control group Control footing

  29. Data Model Two Queries Master group Host variable

  30. Data Model Data link Detail group

  31. Data Model Queries Master group Detail group Data link

  32. Layout Model Editor Repeating Frame Frames cannot overlap! Body

  33. Test the Report

  34. Enter a Value for the Host Variable

  35. Runtime Previewer

  36. Live Previewer Run

  37. Creating a Master-Detail Report

  38. Steps • Create the data model • Master query • Detail query • Link the queries • Create the report layout • Use the Report Wizard • Test • Format the report layout • Test

  39. Basic Report Objects Data Model Layout Model Triggers

  40. Calling the Report Host (bind) variable Parameter Form This will appear automatically when a host (bind) variable appears in the query (data model)

  41. Anatomy of a Master-Detail Report Group header (master) Detail lines Group footer

  42. Master-Detail Report One-to-many relationship Master Manufacturers Have Detail Products

  43. Create the Data Model

  44. Master-Detail Report Data Model First Query Host (bind) variable Create and test the query in SQL Plus without the host variable then paste it into the data model.

  45. Master-Detail Report Data Model Data Link Second Query

  46. Create the Report Layout

  47. Create the Initial Report Layout Designate fields and values Master-detail report Wizard used in a different report

  48. Data Model Queries Master group Detail group Data link

  49. Layout Model Editor Repeating Frame Frames cannot overlap! Body

  50. Test the Report

More Related