In this section:
How to: |
You can add a page heading and/or a page footing to a report. A page heading is text that appears at the top of every page of a report. A page footing is text that appears at the bottom of every page.
You can specify whether the page heading and/or page footing is left justified, right justified, or centered. Individual lines in the page heading or footing can be assigned a different justification. For example, you can have a two-line page heading in which the first line is right justified and the second line is centered.
The heading or footing can display the current page count and total page count.
Note: The Page Heading and Page Footing are turned on by default. If you previously specified a subheading, subfooting, or subtotal, those fields also appear in Report Painter.
If you are sorting the data in a report, you can add subheading and subfootings at sort breaks. For details, see How to Add a Subheading or Subfooting at a Sort Break.
To add a heading or a footing to a report:
The Page Heading and Page Footing objects appear.
Note: If you previously specified a subheading, subfooting, or subtotal, those fields also appear in Report Painter.
If your Page Heading or Footing is not shown in Report Painter, ensure that Boundaries is selected on the Report Options View tab.
You can also perform a calculation or other operation on a field value in a page heading or footing.
Note: Report Painter shows one page vertically. If you have a large Page Heading, you may increase the virtual screen size of Report Painter to see the full report. For more information, see How to Customize the Virtual Screen Size for the Report.
Suppose that you want to see total sales at different levels within your enterprise. The following example shows how to create a report of total sales for Gotham Grinds within each region and city, and embeds the total sales quota in the page heading.
Total Budget Dollars =
Embed the total sales quota in the heading.
Note: If your Page Heading is not shown in Report Painter, ensure that Boundaries is selected on the Report Options View tab.
When the columns presented on PDF reports cannot be displayed on a single page, the pages automatically panel. Paneling places subsequent columns for the same page on additional pages until the entire width of the report is presented, after which a new page number is generated with a new set of panels.
In order to make panels following the initial panel more readable, you can repeat headings and footings on each panel page and turn on page numbering. The panel designation is shown in Report Painter and in the report output.
Note: Headings and Footings can be a Page Heading, Page Footing, Subheading, or Subfooting.
The Report Options dialog box opens at the Format tab.
Note: This step is recommended as it is easier to identify paneled pages with page numbering on.
The following example shows a PDF report when all of the columns cannot be displayed on a single page. Note the page numbers.
Page 1.1 shows the By field, Unit Sales, and the page heading.
Page 1.2 shows the last column of the report, Budget Dollars, on a paneled page so that the entire width of the report is shown.
The following image shows the same report with Repeat headings/footings per panel enabled. Page 1.1 is the same. Note that Page 1.2 shows the paneled page showing the last column of the report (Budget Dollars), and the repeated page heading.
To use the Align column titles (Section 508) option for PDF, you must:
A page heading is inserted into your report, as shown in the following image.
The Insert Alignment Grid dialog box opens.
The Properties for Page Header dialog box opens to the Style tab.
How to: |
You can add a report heading and/or report footing to a report. A report heading is text that appears above the page heading at the top of the first page of the report. A report footing is text that appears below the page footing at the bottom of the last page.
The report heading and footing options are especially useful if you only want certain text to appear at the top of the first page or at the bottom of the last page. For instance, if you are creating a sales report, you can type Sales report for [your company] in the report heading and Report created by [your name] in the report footing.
You can specify whether the report heading and/or report footing is left-justified, right-justified, or centered. Individual lines in the report heading and/or footing can be assigned a different justification. For example, you can have two lines in a report heading where the first line is right-justified and the second line is center-justified.
The Report Heading and Report Footing objects appear.
or
Select Insert Date from the Properties menu.
You can change the display of the date format. See Assigning Date/Time Formats for more information.
How to: |
You can insert the current page number and the total page count in the page heading or footing of a report.
A field marker indicates placement of the current page number.
How to: Reference: |
When creating a report with the Portable Document Format (PDF) output format, you can embed a .SWF file that is Adobe® Flash® Player compatible in the page heading.
.SWF files that are Adobe® Flash® Player compatible combine vector graphics with animation effects that are scalable and provide a perfectly smooth transition of lines and images, creating the highest quality outward-facing PDF documents with engaging functionality and better visualization of data. Adobe Flash Player must be installed to view .SWF files that are Adobe® Flash® Player compatible.
You may embed the Adobe Flash File (.SWF files that are Adobe® Flash® Player compatible) as a File, URL, or Hold File, and set the page heading properties for the source .SWF files. These options are available from the embedded Flash file tab of the Properties for Page Header dialog box in Report Painter.
Note: The embedded Flash file tab appears only if the report output is set to PDF.
The following image shows the options that are available on the embedded Flash file tab for a page header when using the PDF output format.
Right-click inside the Page Heading object in the Report Painter window and choose Options from the context menu. The Properties for Page Header dialog box opens at the Style tab. Click the embedded Flash file tab to view the embedded Flash file options.
The embedded Flash file tab appears only if the report output is set to PDF.
Indicates that no embedded Flash file is selected for the page heading. This is the default option.
Indicates the .SWF file that is Adobe® Flash® Player compatible is embedded in the page heading. Click Browse to select from a list of Shockwave® Flash Objects (.SWF files that are Adobe® Flash® Player compatible) in your project directory.
Indicates the URL source that is embedded in the page heading. Type the location of the .SWF file that is Adobe® Flash® Player compatible in the URL and click Open to verify the URL source in your Web browser.
Note: The Open button is not activated until the location of a .SWF file that is Adobe® Flash® Player compatible is included in the URL source. For example:
http://www.poodwaddle.com/worldclock.swf.
Indicates the .SWF file that is Adobe® Flash® Player compatible hold file that is embedded in the page heading. Use the drop-down list to select from the list of temporary hold files.
Enables you to set the properties for the source of the .SWF file that is Adobe® Flash® Player compatible in the page heading, if you are using a File, URL, or Hold File.
The top-left corner x-coordinate position of the embedded Flash file in inches.
The top-left corner y-coordinate position of the embedded Flash file in inches.
The width, in inches, for the embedded Flash file in the page heading. The default width is 1 inch.
The height, in inches, for the embedded Flash file in the page heading. The default height is 1 inch.
This process describes how to embed an Adobe Flash file in a page heading.
The Properties for Page Header dialog box opens at the Style tab.
Note: The embedded Flash file tab appears only if the report output is set to PDF.
To embed a file:
The Properties section of the embedded Flash file tab is activated. You may position the properties for the source of the .SWF file that is Adobe® Flash® Player compatible in the page heading, or use the default settings.
Tip: A preview of the Adobe Flash File animation appears in the Open dialog box. If you are having trouble viewing the .SWF file that is Adobe® Flash® Player compatible, ensure that Adobe Flash Player is installed.
The selected Adobe Flash File (.SWF files that are Adobe® Flash® Player compatible) appears as the File source.
To embed a URL:
The Properties section of the embedded Flash file tab is activated. You may position the properties for the source of the .SWF file that is Adobe® Flash® Player compatible in the page heading, or use the default settings.
Note: The Open button is not activated until the location of a .SWF file that is Adobe® Flash® Player compatible is included in the URL source, as shown in the following example.
To embed a hold file:
The Properties section of the embedded Flash file tab is activated. You may position the properties for the source of the .SWF file that is Adobe® Flash® Player compatible in the page heading, or use the default settings.
The Adobe logo appears where the embedded Flash file source is positioned in the page heading.
The PDF shows the Adobe Flash File in the output with its animation effects.
WebFOCUS |