Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11
g
Release 1 (11.1.1)
Part Number B32122-02
Home
Book List
Contents
Index
Master Index
Contact Us
Previous
Next
PDF
·
Mobi
·
ePub
List of Figures
1-1 Example matrix report
1-2 Matrix data models
1-3 Conceptual matrix
1-4 Matrix data model relationships
1-5 Sample nested matrix report
1-6 Matrix summary settings
1-7 Matrix summary settings
1-8 Matrix summary settings
1-9 Matrix Layout Model view
1-10 Formatting the same data in different ways
1-11 Unrelated queries
1-12 Sample data link
1-13 Sample data link output
1-14 Repeating frame sizing
2-1 Report dimensions
2-2 Sample matrix with group and nested matrix report
2-3 Default master/detail and group report that query same data
2-4 Master/detail/detail report
2-5 Parent object above child object
2-6 Parent object to the right of child object
2-7 Object in push path of two other objects
2-8 Delimited output of A above B
2-9 Delimited output of frame enclosing repeating frame
2-10 Delimited output of two frames enclosing repeating frames
2-11 Delimited output of boilerplate outside matrix
3-1 Final output of the tabular report example
3-2 Final output of the mailing label report example
3-3 Final output of the form letter example
3-4 Final output of the first master/master report example
3-5 Final output of the second master/master report example
3-6 Final output of the summary report example
3-7 Final output of the single-query group report example
3-8 Final output of the two-query group report example
3-9 Final output of the across group report example
3-10 Final output of the group left summary report example
3-11 Final output of the group left formula report example
3-12 Final output of the wrapped field report example
3-13 Final output of the header and footer report example
3-14 Final output of the header with database values report example
3-15 Final output of the graphics, text, and color example
3-16 Final output of the renumbering pages by repeating frame example
3-17 Final output of the intermixed fields report example
3-18 Final output for the suppressing labels example
3-19 Final output for the first conditional form letter report example
3-20 FInal output for the second conditional form letter report example
3-21 Final output of the conditional highlighting report example
3-22 Final output of the dynamic graphics report example
3-23 Final output of the matrix report example
3-24 Final output of the nested matrix report example
3-25 Final output of the matrix with group above report example
3-26 Final output of the time series calculations report example
3-27 Final output of the Microsoft Excel report
3-28 Final output of the aggregate data report example
3-29 Final output of the check printing report with spelled-out cash amounts
3-30 Final output of the preprinted forms example
3-31 Final output of the invoice report example
3-32 Final output of the ranking report example
3-33 Simple table of contents
3-34 Index
3-35 Multilevel table of contents
3-36 Multibyte character set UTF8 report in Japanese
3-37 Final output of the PL/SQL report example
3-38 Final output for the REF CURSORs example
3-39 JSP Parameter Form
3-40 JSP-based Web report based on a user parameter
3-41 Final output of the barcode report with paper layout
3-42 Final output of the barcode report with Web layout
3-43 Final output of the XML PDS example
3-44 Final output for the text PDS example
4-1 Example matrix object
5-1 Tabular report output
5-2 Paper Design view for the tabular report
6-1 Mailing label report output
6-2 Paper Design view for the mailing label report
6-3 Final mailing label report with vertical spacing
7-1 Form letter report output
7-2 Paper Design view for the form letter report
8-1 Master/Master report output
8-2 Master/Master report output
8-3 Data model with two unrelated queries
8-4 Paper Design view for the Master/Master report
8-5 Paper Layout view with two layouts and white space added
8-6 Paper Design view with monetary values formatted
9-1 Summary report output
9-2 Groups page of the Report Wizard
9-3 Totals page of Report Wizard
9-4 Summary report output with monetary values formatted
9-5 Summary report with report total formatted
10-1 Group report output
10-2 Groups page of the Report Wizard
10-3 Fields page of the Report Wizard
10-4 Paper Design view for the single-query group left report
10-5 Salaries formatted
10-6 Property Inspector for master repeating frame
10-7 Paper Design view after white space is added
10-8 Group left report output with two break columns
10-9 Data model with two break columns
10-10 Group left report output with two break groups
11-1 Group above report output, two queries
11-2 Two-query data model without a link
11-3 Two-query data model with a data link
11-4 Fields page of the Report Wizard
11-5 Paper Design view for the two-query group report
11-6 Group above report output with monetary values formatted
12-1 Across group report output
12-2 Data Model for Query 1
12-3 Data Model of the two linked queries
12-4 Paper Layout view for the across group report
12-5 Paper Design View of the Across Group Report
13-1 Group left summary report output
13-2 Groups page of the Data Wizard
13-3 Two-query data model with summaries
13-4 Two-query data model with a data link
13-5 Fields page of Report Wizard
13-6 Paper Design view for the group left layout with two group columns
13-7 Paper Layout view with two layouts
13-8 Paper Layout view with two layouts merged into one
13-9 Paper Design view with two layouts merged
13-10 Combined group left and tabular report output
14-1 Formula report output
14-2 Paper Design view for the formula report
14-3 Data Model of the Formula Report
14-4 Data Model with Formula Columns
14-5 Final formula report output
15-1 Wrapped field report output
15-2 Data Model for the query
15-3 Data model with groups
15-4 Data model with new G_Name group
15-5 Data Model with Three Summary Columns
15-6 Paper Design view for the wrapped field report
15-7 Paper Design view for the wrapped field report
16-1 Group left report output with header and footer
16-2 Group left report output with footer for master repeating frame
16-3 Group left report output with summary closer to label
16-4 Group left report output with page heading
16-5 Group left report output with values formatted
17-1 Group left report output with database values in header
17-2 Group left report output with values formatted
17-3 Data Model with Summary Columns for Header
17-4 Group left report output with database values in the header
18-1 Graphics, text, and color report output
18-2 Paper Design view for the graphics report with one query
18-3 Paper Layout View of Adjusted Report Layout
18-4 Paper Layout View with Expanded Repeating Frame
18-5 Paper Layout View with Expanded R_G_DEPARTMENT_ID Repeating Frame
18-6 Preview of the Report with a Border
18-7 Paper Design View of the Report with New Fonts
18-8 Paper Design View of the Report with Bullets
18-9 Paper Layout View with Line Separator
18-10 Paper Design View of Report with Line Separator
18-11 Paper Design View of Report with Title
19-1 Pages renumbered by repeating frame report output
19-2 Selecting group fields in the Report Wizard
19-3 Specifying labels and widths in the Report Wizard
19-4 Report layout in the Paper Design view
19-5 Revised report layout in Paper Design view
19-6 Page number source fields in top margin of report
19-7 Page number source and reference fields in top margin of report
19-8 Final pages renumbered by repeating frame report output
20-1 Group with master record in the middle of report output
20-2 Group page of Report Wizard
20-3 Paper Design view for intermixing fields report
20-4 Paper Design view of the intermixing fields report
20-5 Output displayed in Paper Design view
20-6 New Program Unit dialog box
20-7 Final report output displayed in the Paper Design view
21-1 Suppressed labels report output
21-2 Data Model view of the Suppress Labels report
21-3 Data Model view with formula and summary columns
21-4 Paper Design view for the suppress labels report
21-5 Navigating to M_G_DEPTNO1_HDR
21-6 Selected objects in the Object Navigator
21-7 Selected objects brought forward in the Object Navigator
21-8 Final Paper Output of the Suppressing Labels Report
22-1 Conditional highlighting report output
22-2 Paper Design view for the initial tabular report
22-3 Formatted salary column
22-4 Paper Design view of the tabular report
22-5 Format Exception dialog box
22-6 Conditional Formatting dialog box
22-7 FInal Conditional Formatting report
22-8 PL/SQL code for the new format triggers
23-1 Conditional form letter report output, base version
23-2 Conditional form letter report output, alternate version
23-3 Property Inspector with anchor properties displayed
23-4 Paper Layout view of modified report
24-1 Dynamic graphics report output
24-2 Data Model view for the dynamic graphics report
24-3 Initial Paper Layout view for the dynamic graphics report
24-4 Paper Layout view of the modified layout
24-5 Final Dynamic Graphics Report
25-1 Matrix report output
25-2 Paper Design view for the matrix report
25-3 Three query data model, queries unrelated
25-4 Three query data model with cross product group
25-5 Three query data model with cross product group and data links
25-6 Groups page of the Report Wizard
25-7 Fields page of the Report Wizard
25-8 Paper Design view for the matrix report
25-9 Matrix report in Paper Design view with monetary values formatted
25-10 Object Navigator with new object selected
25-11 Object Navigator with repeating frame and field selected
25-12 Matrix report output with zeroes replacing blanks
25-13 Matrix report output with a grid
26-1 Nested matrix report output
26-2 First matrix row in the Report Wizard
26-3 Second matrix row in Report Wizard
26-4 Paper Design view for the nested matrix report
26-5 Data model with four queries
26-6 Data Model with four queries and a cross product group
26-7 Nested matrix data model
26-8 Groups page of the Report Wizard
26-9 Fields page of the Report Wizard
26-10 Paper Design view for the nested matrix output
26-11 Data model with three queries
26-12 Data Model with three queries and a cross product group
26-13 Nested matrix data model
26-14 Groups page of the Report Wizard
26-15 Fields page of the Report Wizard
26-16 Paper Design view for the final nested matrix report output
26-17 Nested matrix report output with formatted monetary values
27-1 Matrix with group above report output
27-2 Paper Design view for matrix with group above report
27-3 Matrix with group above report output with summary labels
27-4 Layout model with lines above column summaries
27-5 Matrix group above report output with added space
28-1 Time series calculations report output
28-2 Paper Design view of the Time Series Calculations report
28-3 Data Model view of the Time series Calculations report
28-4 Time Series Calculations JSP-based Web Report
29-1 Enhanced Spreadsheet report output
29-2 Paper Design Output
29-3 Web Design Output
29-4 Microsoft Excel Output of Your Report
30-1 Aggregate data report output
30-2 Paper Design view for the aggregating data report
30-3 Paper Layout view of the Aggregating Data report
30-4 Paper Layout view with new boilerplate text
30-5 Paper Design view
30-6 Data Model for the aggregating data report
30-7 Aggregating Data JSP-based Web Report
31-1 Check printing report output
31-2 Paper Design view of the simple report
31-3 PL/SQL Editor displaying the SPELL function
31-4 Object Navigator with SPELL PL/SQL function
31-5 Data Model view
31-6 Resized Data Model view
31-7 Data Model with SPELLED_AMOUNT formula column
31-8 Data Model with two queries
31-9 Data Link between two queries
31-10 Paper Layout view of your report
31-11 Paper Layout view with resized margin
31-12 Partial Paper Layout view with F_ORDER_TOTAL1
31-13 Partial Paper Layout view with F_ORDER_DATE1
31-14 Partial Paper Layout view with F_CUSTOMER_NAME1
31-15 Partial Paper Layout view with F_CHECK_NO1 and F_CHECK_NO2
31-16 Partial Paper Layout view with F_1 field
31-17 Partial Paper Design view of the check report
31-18 Amount area on blank check
31-19 Check image with fields positioned
31-20 Formatted Check
31-21 Partial Paper Design view of the check report with horizontal guideline
31-22 Partial Paper Design view of the check with Order No. boilerplate text
31-23 Order No. and F_ORDER_ID fields in the Paper Design view
31-24 Order Date field in the Paper Design view
31-25 F_ORDER_DATE1 field next to Order Date text
31-26 Partial check stub in Paper Design view
31-27 Second vertical guideline in the Paper Design view
31-28 Customer field in the Paper Design view
31-29 Customer and F_CUSTOMER_NAME1 fields
31-30 Partial check stub in the Paper Design view
31-31 Formatted check stub
31-32 Check printing report with non-formatted order details
31-33 Final check report with spelled-out cash amounts and stub
32-1 Printing reports on preprinted forms
32-2 Data Model view of the first query
32-3 Data Model view with two queries
32-4 Data Model view of the linked queries and break group
32-5 Complete Data Model view of the preprinted forms example
32-6 Paper Layout view of the initial layout
32-7 Report Block boilerplate object in the Object Navigator
32-8 Paper Layout view of the preprinted form example with mailing label and order item details
32-9 Selected frame in the Object Navigator
32-10 Selected repeating frame in the Paper Layout view
32-11 F_PAGE_TOTAL and F_ORDER_TOTAL fields in the Paper Layout view
32-12 Final preview of your preprinted form report
32-13 Final report printed on a sample preprinted form
32-14 Paper Design view of the preprinted form report with page numbers
33-1 Invoice report output
33-2 Queries in the Data Model view
33-3 Data Model view with data link, summary, and formula columns
33-4 Invoice report layout
33-5 Final invoice report output
34-1 Tabular report output, ranked by number and percentage of customers
34-2 Paper Design view for the ranking report
34-3 Tabular report output restricted to top three customers
34-4 Tabular report output with parameter value displayed
34-5 Data Model view of the Ranking Report
34-6 Tabular report output restricted by number and percentage of customers
35-1 Simple table of contents for a large report
35-2 Simple index for a large report
35-3 Simple table of contents
35-4 Data model for the group above report
35-5 Paper Layout view of the group above report
35-6 Data model with second query
35-7 Paper Layout view of the Header Section
35-8 Table of contents page of the report
35-9 Results for customers in Argentina
35-10 Sample index for the paper report
35-11 Data model view of the index
35-12 Index page of the report
36-1 Multilevel table of contents
36-2 Main category with sub-category sample page in the report
36-3 Data model for the multilevel TOC report
36-4 Paper Layout view of the Header Section
36-5 Table of contents page of the report
36-6 Results for the BOYS product department and SHIRTS sub-category
37-1 Deleting the repeating frame
38-1 Output of the multibyte character set UTF8 report in Japanese
38-2 Output of the same multibyte character set UTF8 report in Polish
38-3 uifont.ali file edited to include the TrueType font file name
38-4 Paper design view of the report without Japanese characters in default setting
38-5 Paper design view of the report with Japanese characters
38-6 Paper design view of the report with Polish characters
38-7 PDF file of the report with Polish characters
39-1 Plotting Irregular Time Period
39-2 New Chart Styles
39-3 Funnel Graph
39-4 Curved LIne Graph
40-1 PL/SQL report output
40-2 Object Navigator
40-3 Data Model view of the PL/SQL report
40-4 Data Model with expanded G_FIRST_NAME
40-5 Data Model with unnamed formula column
40-6 Data Model with BONUS formula column
40-7 Object Navigator with FINAL_CALC function
40-8 Data Model with BONUS and TOTAL_COMP formula columns
40-9 Displays Fields list
40-10 Paper Layout view of the PL/SQL example report
40-11 Object Navigator with M_NAME repeating frame
40-12 Paper Design view of modified report
40-13 User Parameter in the Object Navigator
40-14 Data Model with new summary column
40-15 Layout with added vertical space
40-16 Final PL/SQL example report
41-1 REF CURSOR report output
41-2 Overview of the REF CURSOR example
41-3 Data model with three queries
41-4 Query with group
41-5 Data model with group
41-6 Data model with links
41-7 Data model with summary columns
41-8 Paper Design view for the REF CURSOR report
42-1 JSP Parameter Form
42-2 JSP-based Web report based on a user parameter
42-3 Sample HTML Parameter Form
42-4 Data Model view of the Parameter Form
42-5 Parameter form with values
42-6 JSP Parameter Form with selections
42-7 Sample employee report based on user parameters
43-1 Barcode JavaBean Web report output
43-2 Data Model for the query
43-3 Data Model with two new formula columns
43-4 Paper Design view of the barcode paper report
43-5 Data Model for the JSP-based Web report query
43-6 Data Model with the three formula columns
43-7 Snapshot of the final JSP-based Web report with barcode
45-1 Report output using an XML PDS
45-2 Data Model for the XML PDS example SQL query
45-3 Data model for the XML PDS example with XML and SQL queries
45-4 Data Model with a data link between a SQL query and an XML query
45-5 Paper Design view for the XML PDS report
45-6 XML PDS Report with Alternating Row Colors
45-7 Data Model with Group Hierarchy
45-8 Final Paper Design view of the XML PDS example report
46-1 Report output using a Text PDS
46-2 Snapshot of the textpds.conf entry
46-3 Paper Design view for the Text PDS report
A-1 Main toolbar
A-2 Data Model view tool palette
A-3 Paper Layout view tool palette
Scripting on this page enhances content navigation, but does not change the content in any way.