This section provides procedures for creating and modifying objects in your report layout. The procedures are grouped into the following sections: Show
4.9.1 General Layout ObjectsThis section provides procedures for the following tasks that you may perform as you work with container objects:
4.9.1.1 Creating a field objectTo create a field object manually in the report layout:
See also Section 1.8.4, "About fields" Section 1.9.2, "About Parameter Form fields" 4.9.1.3 Creating a matrix objectNote: This procedure provides steps to create a matrix object manually. The recommended method for creating a matrix object is to use the Report Block Wizard (choose Insert > Report Block in the Paper Layout view). To create a matrix object:
See also Section 2.3.7, "About matrix objects" Section 1.3.7, "About matrix reports" Section 2.1.7, "About nested matrix reports" Section 2.1.8, "About matrix with group reports" Section 4.8.8, "Creating a matrix (cross-product) group" Section 4.5.3, "Creating a nested matrix report" 4.9.1.4 Creating a barcode using a barcode fontTo create a barcode using a barcode font:
4.9.1.5 Applying conditional formatting to a layout objectTo apply conditional formatting to a layout object:
Usage notes
See also Section 2.1.6, "About conditional formatting" Chapter 4, "Highlighting a value" Chapter 4, "Highlighting a row" 4.9.2 Text ObjectsThis section provides procedures for the following tasks that you may perform as you work with text objects:
4.9.2.1 Creating a boilerplate object for textTo create a boilerplate object for text:
See also Section 1.8.5, "About boilerplate objects" 4.9.2.2 Creating a boilerplate object for text that displays every other pageTo create a boilerplate object for text that displays every other page:
See also Section 1.8.5, "About boilerplate objects" 4.9.2.3 Creating a boilerplate text object for HTML tagsNote: This procedure applies to paper-based reports. To create a boilerplate text object for HTML tags:
Usage notes When the text object's Contains HTML Tags property is set to Yes, HTML tags and attributes are formatted in your report output as follows:
Example 1: Turning formatting on and off Consider a text boilerplate object that is defined as follows: <i><b>Design time format</b> is merged with <span style="font-family:Arial; color:#00F">run time formatting instructions.</span></i> With its Contains HTML Tags property set to Yes, this will format as: Design time format is merged with run time formatting instructions. With its Contains HTML Tags property set to No, this will format in the report output as:
Example 2: Boilerplate text object tagged as a hyperlink In a boilerplate text object, you can type the following text: <a href=http://your_webserver/reports/my_report.html><img src=oracle.gif> </a>
With the Contains HTML tags property set to Yes, this object will appear in HTML/HTMLCSS report output as a graphic (oracle.gif) , which the end user can click to link to my_report.html. Example 3: Parameter values output to HTML In a boilerplate text object, you can type the following Java Applet, called <base href=http://cagney.uk.oracle.com/java/NervousText/> <applet code="NervousText.class" width=&ObjectWidth height=&ObjectHeight> <param name=text value="&deptno"> </applet> With the Contains HTML tags property set to Yes, this object will be interpreted with the parameters replaced with their actual values, as follows: <base href=http://cagney.uk.oracle.com/java/NervousText/> <applet code="NervousText.class" width=84 height=72> <param name=text value="10"> </applet> See also Section 1.8.5, "About boilerplate objects" Section 2.5.1, "About Parameter Form HTML extensions" 4.9.2.4 Editing textTo insert and replace text:
To delete text:
To cut, copy, or paste text:
4.9.2.5 Referencing a field in boilerplate textTo reference a field in boilerplate text:
Usage notes
See also Section 1.8.4, "About fields" Section 1.8.5, "About boilerplate objects" 4.9.2.6 Linking a boilerplate text object to a fileNote: This procedure applies paper-based reports. File Link objects are not implemented in JSP-based Web reports. To link a boilerplate text object to a file:
See also Section 1.8.5, "About boilerplate objects" 4.9.2.7 Linking an HTML text object to a fileNote: This procedure applies to paper-based reports. File Link objects are not implemented in JSP-based Web reports. To link an HTML object to a file:
Usage notes When the text object's Contains HTML Tags property is set to Yes, HTML tags and attributes are formatted in your report output as follows:
See also Section 1.8.5, "About boilerplate objects" 4.9.2.8 Wrapping text in a fieldTo wrap text in a field:
4.9.2.9 Changing text attributesTo change the font, justification, spacing, or reading direction of a text object:
4.9.2.10 Changing text attributes using PL/SQLTo change the font or justification of a text object using PL/SQL instead of the user interface:
See also Topic "SRW built-in package" in the Reference > PL/SQL Reference > Built-in Packages section of the Oracle Reports online Help. 4.9.3 Page Numbers or Date/Time StampsThis section provides procedures for the following tasks that you may perform as you work with page numbers or date/time stamps:
4.9.3.1 Creating page numbersTo create default page numbers:
To create customized page numbers:
Usage notes
4.9.3.2 Resetting page numbersTo reset default page numbers (created with Insert > Page Number):
4.9.3.3 Creating a time or date stampTo add a date or time stamp to your report:
4.9.4 BordersThis section provides procedures for the following tasks that you may perform as you work with borders:
4.9.4.1 Showing or hiding object bordersTo show or hide the borders around an object:
4.9.4.2 Changing object border attributesTo change the borders around an object:
See also Section 2.4.5, "About changing colors and patterns" Section 4.12.8, "Modifying the color, pattern, or border of body objects in a template" 4.9.4.3 Changing the current mode (Confine or Flex)To set or override Confine mode:
To set or override Flex mode:
See also Section 2.4.7, "About moving and layering objects in the Paper Layout view" Chapter 4, "Adjusting parent borders automatically" Chapter 4, "Moving an object outside its parent" 4.9.5 AnchorsThis section provides procedures for the following tasks that you may perform as you work with anchors:
See also Section 2.4.4, "About anchors" 4.9.5.1 Anchoring objects togetherAnchoring objects assures that the anchored object will move with the parent object. An object can be anchored to only one other object. To anchor objects together:
4.9.5.2 Viewing implicit anchorsBy default, you see the explicit anchors created in the Paper Layout view of the Report Editor. To view information on both implicit and explicit anchors:
See also Section 2.4.4.1, "Implicit anchoring algorithm"
4.9.5.3 Moving an anchorMoving an anchor changes how the objects will be displayed in relationship to each other. To move an anchor:
To move an anchor along an object edge:
To change the position of the anchor on the object edge, as a percentage down or across from top to bottom or left to right:
To change the edge on which the anchor is positioned:
4.9.6 Colors, Patterns, and HighlightingThis section provides procedures for the following tasks that you may perform as you work with colors, patterns, and highlighting:
4.9.6.2 Changing colorsTo change the color of an object or text:
See also Section 2.4.5, "About changing colors and patterns" Section 4.12.8, "Modifying the color, pattern, or border of body objects in a template" 4.9.6.3 Changing patternsTo change the pattern of an object:
See also Section 2.4.5, "About changing colors and patterns" Section 4.12.8, "Modifying the color, pattern, or border of body objects in a template" Topic "Pattern color palette" in the Reference > Color and Pattern Palettes section of the Oracle Reports online Help. 4.9.6.4 Changing colors and patterns using PL/SQLTo change the color of an object using PL/SQL instead of the user interface:
See also Section 2.4.5, "About changing colors and patterns" Topic "SRW built-in package" in the Reference > PL/SQL Reference > Built-in Packages section of the Oracle Reports online Help. 4.9.6.5 Modifying the color paletteTo modify the color palette:
Note: A report can have only one color palette. See also Section 2.4.5, "About changing colors and patterns" Topics "Oracle CDE1 color palette", "Default color palette", and "Grayscale color palette" in the Reference > Color and Pattern Palettes section of the Oracle Reports online Help. 4.9.6.6 Importing or exporting a color paletteTo import or export a color palette:
Note: A report can have only one color palette. See also Section 2.4.5, "About changing colors and patterns" Topics "Oracle CDE1 color palette", "Default color palette", and "Grayscale color palette" in the Reference > Color and Pattern Palettes section of the Oracle Reports online Help. 4.9.6.7 Highlighting a valueTo highlight a value in a report:
Example The following code determines the monthly compensation and changes the background color to red if the compensation has exceeded four thousand dollars a month and the employee is not a manager. function R_G_EMPNOFormatTrigger return boolean is varcomm number; begin if :comm is null then varcomm := 0; else varcomm := :comm; end if; if (:sal * 2 + varcomm > 4000) and :job != 'MANAGER' then srw.set_background_fill_color('red'); end if; return (TRUE); end; See also Section 2.1.6, "About conditional formatting" Section 4.9.1.5, "Applying conditional formatting to a layout object" 4.9.6.8 Highlighting a rowTo highlight an entire row:
Example The following code determines the monthly compensation and changes the background color to red if the compensation has exceeded four thousand dollars a month and the employee is not a manager. function R_G_EMPNOFormatTrigger return boolean is varcomm number; begin if :comm is null then varcomm := 0; else varcomm := :comm; end if; if (:sal * 2 + varcomm > 4000) and :job != 'MANAGER' then srw.set_background_fill_color('red'); end if; return (TRUE); end; See also Section 2.1.6, "About conditional formatting" Section 4.9.1.5, "Applying conditional formatting to a layout object" 4.9.7 Format MasksThis section provides procedures for the following tasks that you may perform as you work with format masks:
4.9.7.1 Specifying date and time format masksThe following tables describe the date and time format masks, and the suffixes you can add to date format masks: Table 4-2 Date and time format masks
The following suffixes may be added to the format masks: Table 4-3 Date format mask suffixes
Examples Table 4-4 Date format mask examples
4.9.7.2 Specifying number format masksThe following table describes the tokens you can use in creating a number format mask: Table 4-5 Tokens for number format masks
Restrictions
Examples Table 4-6 Number format mask examples
* The quotation marks will not appear in your output. They are used here to make it clear where there are leading or trailing spaces. 4.9.7.3 Applying a format mask to a numeric object
4.9.7.4 Applying a format mask to a date objectTo apply a format mask to a date object:
4.9.7.5 Adding a custom format maskTo add a custom format mask to the default format masks list:
4.9.7.6 Changing the format mask for multiple fieldsTo change the format mask for multiple fields at one time:
4.9.8 Graphic or Image ObjectsThis section provides procedures for the following tasks that you may perform as you work with graphic or image objects:
4.9.8.1 Adding an imageTo add an image to your report, perform the steps in any of the topics listed below. For paper-based reports and JSP-based Web reports:
For paper-based reports only:
See also Section 2.4.3, "About images" 4.9.8.1.1 Importing an imageNote: This procedure applies to paper-based reports. For JSP-based Web reports, see the Usage notes, below. These steps allow you to include images in the following formats: TIFF, JFIF, BMP, TGA, PCX, PICT, GIF, CALS, RAS, OIF, PCD. For images in other formats supported by Oracle Reports, including JPEG (all types, such as Progressive JPEG and Exif JPEG), PNG, BMP, TIFF, GIF, and CGM, see Section 4.9.8.1.2, "Linking an image object to a file" or Section 4.8.5, "Selecting an image from the database". To import an image:
Usage notes This procedure is for paper-based reports only. If you want to include static images in your JSP-based Web reports, you can add HTML 4.9.8.1.2 Linking an image object to a fileNotes: This procedure applies to paper-based reports. File link objects are not implemented in JSP-based Web reports. These steps, and the steps in Section 4.8.5, "Selecting an image from the database", allow you to include images in a wide variety of formats supported by Oracle Reports, including JPEG (all types, such as Progressive JPEG and Exif JPEG), PNG, BMP, TIFF, GIF, and CGM. For paper-based reports, you can also use Insert > Image to import an image from a file into the report layout for images in the following formats: TIFF, JFIF, BMP, TGA, PCX, PICT, GIF, CALS, RAS, OIF, PCD (see Section 4.9.8.1.1, "Importing an image", above). To link an image object to a file:
4.9.8.1.3 Linking an image object to a URLNotes: This procedure applies to paper-based reports output to an HTML or HTMLCSS file. This is unrelated to HTML that might be generated when you run a JSP-based Web report (when you click the Run Web Layout button in the toolbar, or choose Program > Run Web Layout). Additionally, file link objects are not implemented in JSP-based Web reports. These steps, and the steps in Section 4.8.6, "Selecting an image URL from the database", allow you to include images in a wide variety of formats supported by Oracle Reports, including JPEG (all types, such as Progressive JPEG and Exif JPEG), PNG, BMP, TIFF, GIF, and CGM. For paper-based reports, you can also use Insert > Image to import an image from a file into the report layout for images in the following formats: TIFF, JFIF, BMP, TGA, PCX, PICT, GIF, CALS, RAS, OIF, PCD (see Section 4.9.8.1.1, "Importing an image", above). To link an image object to a URL that points to an image to include in an HTML report:
Example 1: Image URL HTTP://www.oracle.com/images/logo.gif Example 2: Image URL containing user parameter HTTP://&<P_SERVER_NAME>/images/logo.gif where At runtime, the end user can specify a value for the parameter (for example, Example 3: URL to a file FILE://c:/images/logo.gif Note: If you click Browse to find a file, Oracle Reports automatically prepends 4.9.8.2 Adding a graphTo add a graph to your report, follow the steps in either of the following topics:
Usage notes Inserting a graph with a once-per-group position in the Paper Design view of a matrix with group report causes Oracle Reports Builder to fail. As a workaround, insert the graph in the Paper Layout view, rather than the Paper Design view, when adding a graph to a matrix with group report. See also Section 1.6.6, "About the Web Source view" Chapter 39, "Building a Report with Graphs" 4.9.8.2.1 Adding a graph to a paper-based reportTo add a graph to your paper-based report:
4.9.8.2.2 Adding a graph to a JSP-based Web reportTo add a graph to a JSP-based Web report:
Note: The
4.9.8.3 Editing a graphTo add a graph to your report, follow the steps in either of the following topics:
See also Section 1.4.4, "About Graphs and the Graph Wizard" Section 1.6.6, "About the Web Source view" 4.9.8.3.1 Editing a graph in a paper-based reportTo edit a graph in a paper-based report:
4.9.8.3.2 Editing a graph in a JSP-based Web reportTo edit a graph in a JSP-based Web report, do any of the following in the Web Source view:
Note: The
4.9.8.4 Adding a graph hyperlinkYou can add a graph hyperlink to a graph in your paper-based Web report (output to PDF or HTML), or JSP-based Web report. When end users display the report on the Web, they can click the areas of the graph to drill down to additional linked information. To add a graph hyperlink to a graph, follow the steps in either of the following topics:
See also Section 2.2.6, "About graph hyperlinks" Section 1.4.4, "About Graphs and the Graph Wizard" Section 1.6.6, "About the Web Source view" 4.9.8.4.1 Adding a graph hyperlink to a paper-based reportFor a paper-based Web report (for HTML or PDF output), you can add a graph hyperlink to a graph in either of the following ways:
To specify a graph hyperlink in a paper-based report using the Property Inspector:
To specify a graph hyperlink in a paper-based report using the Graph Wizard:
After you have defined the graph hyperlink, generate your report to HTML, HTMLCSS, or PDF to test the graph hyperlinks. Refer to Section 4.7.5, "Generating HTML or HTMLCSS output" and Section 4.7.6, "Generating PDF output". 4.9.8.4.2 Adding a graph hyperlink to a JSP-based Web reportTo add a graph hyperlink to a graph in a JSP-based Web report:
After you have defined the graph hyperlink, click the Run Web Layout button in the toolbar (or choose Program > Run Web Layout) to display your report and graph in your Web browser, and click the graph hyperlinks to test them. 4.9.8.5 Creating a drawing objectTo create a drawing object:
4.9.9 Page or Group Headers or FootersThis section provides procedures for the following tasks that you may perform as you work with page or group headers or footers:
4.9.9.1 Creating a text headingTo create an object or heading in the margin of a report:
4.9.9.2 Creating a heading that includes database valuesTo create a heading that includes database values:
See also The example report in Chapter 17, "Building a Header with Database Values Report". 4.9.9.3 Creating a group header or footerTo create a header or footer above or below each group of records:
4.9.10 Margin, Header Page, or Trailer Page ObjectsThis section provides procedures for the following tasks that you may perform as you work with margin, header page, or trailer page objects:
4.9.10.1 Creating a margin objectTo create an object or heading in the margin of a report:
4.9.10.2 Creating a header page or trailer page objectWith report sectioning, Header and Trailer pages are identical to Body pages. In effect, this means that the Header, Trailer, and Body are three sections of a report. The names of the sections are exposed under the Paper Design node in the Object Navigator as Header Section, Main Section, and Trailer Section. You can use the margin and body of the Header and Trailer sections to create a Header and Trailer "page" as in earlier releases of Oracle Reports.
4.9.11 Move ObjectsThis section provides procedures for the following tasks that you may perform as you move your report objects:
4.9.11.1 Moving multiple objectsTo move multiple objects:
See also Section 2.4.7, "About moving and layering objects in the Paper Layout view" 4.9.11.2 Moving an object outside its parentTo move a child object outside its enclosing parent object:
See also Section 2.4.7, "About moving and layering objects in the Paper Layout view" 4.9.11.3 Adjusting parent borders automaticallyTo adjust parent borders as you move child objects:
See also Section 2.4.6, "About resizing objects" 4.9.11.6 Aligning objectsTo align objects:
See also Section 2.4.7, "About moving and layering objects in the Paper Layout view" 4.9.11.7 Changing object layeringTo change the order in which objects are layered on top of each other:
See also Section 2.4.7, "About moving and layering objects in the Paper Layout view" 4.9.11.8 Rotating a boilerplate objectYou can only rotate boilerplate text and graphics. You cannot rotate other layout objects (repeating frames or fields). To rotate a boilerplate object:
See also Section 1.8.5, "About boilerplate objects" 4.9.12 Resize ObjectsThis section provides procedures for the following tasks that you may perform as you resize your report objects:
4.9.12.1 Resizing objectsTo resize one or more objects:
See also Section 2.4.6, "About resizing objects" Section 1.8.3, "About frame and repeating frame sizing" 4.9.12.2 Making multiple objects the same sizeTo make multiple objects the same size:
4.9.13 Change SpacingThis section provides procedures for the following tasks that you may perform as you change spacing between your report objects:
4.9.13.1 Changing columns labels or widthsTo change column labels or widths:
See also Chapter 4, "Moving a column in report output" 4.9.13.2 Changing spacing within a text objectTo change spacing within a text object:
4.9.13.3 Changing the default layout spacingTo change the default layout spacing used by the Report Wizard when defaulting the report layout:
See also Chapter 4, "Moving a column in report output" 4.9.13.4 Changing the spacing between all rowsTo change the spacing between all rows using the Paper Design view:
To change the spacing between all rows using the Property Inspector:
4.9.13.5 Adding blank lines between groups of rowsTo add blank lines between groups of rows:
4.9.14 Modify the Page LayoutThis section provides procedures for the following tasks that you may perform as you modify the page layout of your report:
4.9.14.1 Adjusting marginsTo adjust margins:
4.9.14.2 Adding a page breakTo add a page break:
Usage notes If you want to set a page break at a specific row of report output, you can create a hidden object (for example, a rectangle with No Fill and No Line) that formats only at the specific row. If you set the Page Break Before property to Yes for the rectangle object, you will get a page break after the row. How do you edit a report in Access?Modify your report in Design view. On the Design tab, in the Controls group, click Text Box.. Click in an open area of the section where you want the line numbers to appear. ... . Click the label (just to the left of the new text box), and press DELETE.. How do you switch to the view where you can modify the structure?Switch to the view where you can modify the structure of the report without viewing any live data. In the Home Ribbon Tab in the Views Ribbon Group, you clicked the View button arrow. In the View menu, you clicked the Design View menu item.
How do I format a report in Access?Right-click the report in the Navigation Pane, and then click Layout View on the shortcut menu. Click the text box that displays the rich text field, and then, on the Format tab, in the Font group, click the formatting style that you want to apply.
What are the steps involved in creating a report in MS Access?How to Create a Report in Access. Select the table or query you want to base the report on.. Click the Create tab on the ribbon.. Click the Report button. ... . Click the Save button.. Give the report a name and click OK.. |