Reporting in Clausion FPM System > Printing Templates

Location: template window

Before printing, define Page Setup settings.

Note! The options available in the Page Setup dialogue box depend on the default printer defined in the Windows printer settings.

Table 5: Page tab settings

Setting

Description

Orientation

Options for page orientation: Portrait and Landscape

Scaling

Adjust to: You can adjust the printout size to a specific percentage of the normal size. The minimum is 10 % of the normal size.

Fit to page(s): You can define the number of pages to which the printout will be fit. Note that if page breaks are set in the Excel file, the Fit to page(s) setting is ignored.

Exceptions to default settings: In the Page Setup dialogue box, the Fit to page(s) setting is always selected as the default scaling option with XLSX files, even if it has not been defined to be used in the XML or Excel file.

Paper size

The size of the printout paper.

Exceptions to default settings: All settings defined in the Excel file are not shown as the default in the Page Setup dialogue box.

Table 6: Margins tab settings

Setting

Description

Margins

The margins for the printout.

Exceptions to default settings: In the Excel file, the margins are set according to the system of measurement based on Windows regional settings (metric or inches). In the input or report template Page Setup dialogue box, the unit of measurement is always inches.

Center on page

Center the content on the page horizontally and/or vertically.

Exceptions to default settings: If the Horizontal option has been selected for the template in the workbook settings, this option is not shown as the default in the Page Setup dialogue box.

1.Select Header or Footer.

2.Set the options for the header/footer under Sections:

•To use a predefined header or footer, select options from the Left, Center, and Right drop-down lists.

•You can also type directly in the text boxes below the drop-down lists or use the buttons to insert data. The buttons listed in the following table are available. The default values are retrieved from the workbook settings.

Note! The &[Tab] (Insert Sheet Name), &[File] (Insert File Name), &[Path]&[File] (Insert File Path), and &[Picture] (Insert Picture) options available in Excel are not displayed in Clausion Financial Performance Management report templates.

Table 7: Header/Footer tab settings

Button	Description
	First select or type the value in the text box, then use this button to define the font for it. Do not select the text in the text box before defining the font, otherwise an empty page will be printed. When you select a value from a drop-down list, the text is automatically selected in the text box. Click outside the text to deselect it.
	Select text and use this button to define font color. Exceptions to default settings: The settings defined in the Excel file do not work. The color is not shown correctly and the code of the selected color is shown next to the text. In this case, delete the color code and then define the color again.
	Add page numbers.
	Add the number of pages.
	Add the date in a short format.
	Add the date in a long format.
	Add the time in a short format.
	Add the time in a long format.
	Add an image.

Table 8: Sheet tab settings

Setting

Description

Print Type

All: If the template contains only one worksheet and a print area has been defined, the print area is printed. If the template contains more than one worksheet and the print area has been defined on the first worksheet, other sheets are printed as a whole. If no print area has been defined, the whole worksheet is printed.

Selected: If the template contains only one worksheet and a print area has been defined, the print area is printed. If the template contains more than one worksheet and the print area has been defined on the first worksheet, other sheets are printed as a whole. If no print area has been defined, the whole sheet is printed even if an area has been selected.

Print Titles

The print titles setting is used to specify the areas that are printed on every template print page when the printout does not fit on a single sheet of paper.

•-1: Print titles are not defined

•0: 1st row/column

•1: 2nd row/column

•etc.

Exceptions to default settings: The settings defined in Excel 2007 are not shown as the default in the Page Setup dialogue box.

Note that if Freeze Panes is used in the Excel file, it is not applied in printing (the frozen section is not printed on every page).

If you want to print the sheet with gridlines, select the Gridlines check box. Note that in addition to this selection, gridlines must be visible in the Excel file (View tab > Show group > Gridlines check box selected).

If you use a color printer but want to use black and white only, select the Black and White option. If you use a printer that prints black and white only, you do not need to select this option. Note that colors are shown in print preview (in Input and Report Template management) or when you print to file (in Input and Reporting).

If you want to print the column and row headings (the row numbers and column letters), select the Row Headings and/or Column Headings check boxes.