Defining the Print Layout (SAP Library - Administrator Workbench)

Defining the Print Layout

Use

If you want to print a query in the background, and you create a new Reporting Agent setting in order to do this (see Printing in the Background), you determine the query display on the Print Settings tabstrip (see Print Settings) and in the Print Layout tabstrip. On the Print Layout tabstrip, you determine how the InfoObjects in the query are displayed on the print-out.

The Print Layout tabstrip consists of the following areas:

Available objects

Here, you find all the InfoObjects (characteristics and key figures) for the query.

Print areas

You set up the following areas here:

Cover sheet
Page header
Table header
Table
Page footer
Last page

Procedure

Defining the layout of cover sheets, final pages, page headers, and page footers.

Choose the print area you want to use.

A double-click takes you to the Editor. Here, you determine how you want to set-up your chosen print area.

You can:

specify any number of texts
insert margins or separators
insert variables of the query

The variables are subdivided into:

General text variables (text elements of the query and print details such as date of printing or page number)
Special variables (attributes)
Characteristics
Selection parameters (variables and filter values)

Depending on what settings you made in the query definition, you may not be able to use all types of text variables.

Save your entries.

No headers or footers are printed on the cover sheet or the final page.

If you do not make any settings for headers and footers, the print title, the date, and the time of printing, are printed in the header by default. The page number appears in the footer.

If you want to print a header or footer, delete all the rows from the header or footer and press Save.

Determining how InfoObjects are displayed

Query InfoObjects are displayed in the table by default. The key figures appear in the columns, and the characteristics appear in the rows of the table.

You can determine how each of the individual InfoObjects are displayed:

Expand the Table nodes under Print areas.

Choose Display <-> Change from the toolbar.

You are now able to:

arrange the InfoObjects into the sequence you want using drag-and-drop.
drag the InfoObjects that you do not want to have displayed in the drilldown, that is in the table, to the left-hand side of the screen, and drop them under Available Objects.
drag characteristics into the cover sheet, page header, or table header areas. If the characteristic value changes, a new cover sheet, and a new page header or table header, are created.

You can make additional settings for every InfoObject:

Select the InfoObject you want to make settings for, and choose Properties from the context menu (right mouse button). Selection fields for this InfoObject appear on the right-hand side of the screen.

You can also get to the selection fields by double-clicking on the InfoObject.

Define the settings that you want to make. There are different options for characteristics and key figures:

Characteristics

TABSTRIP DISPLAY	Meaning
Layout	The following options are available: No display Key and text (default setting) Text Key Text and key Long text Medium text
Automatic column width	This function is switched on by default. Automatic column width is set at max. 60 characters for titles, and max.32 characters for keys. If you switch this function off, the field Column width, which is filled manually, appears in the field Column 1 (or Column 2). We recommend that you choose the automatic column width function for keys and specify the column width manually for characteristics with hierarchies, because the automatic column width is set to 60 characters (titles) and 32 characters (keys).
Totals row	The following options are available: Do not suppress totals (default setting) Suppress (un)conditional totals Suppress (c)onditional totals: If there is only one characteristic value for a characteristic, then no totals appear. This would only repeat the characteristic value.
Column 1	The name of the key figure appears by default as the title. You can also enter another title here. You can choose between the following settings: Align left Center Align right If you want the column to be printed on more than just the first page of the query, choose on every page. The column then appears on all the other pages.
Column 2	If you have chosen both options, key and text, then there are actually two columns for the characteristic. So for the second display option, you can choose: the alignment, and the on every page function.

TABSTRIP HIERARCHY	Meaning
Active hierarchy	If you choose active hierarchy, the characteristic values are drilled down by hierarchy (indicated by *). Otherwise, it is displayed as a list.
Hierarchy	Select the hierarchy you want to use.
Version	Choose the version of the hierarchy you want to use (if it is available).
Key date	Choose the key date for the hierarchy that you want to use (if you are working with a time-dependent hierarchy).
Level	Specify the drilldown level that you want to use.

Attributes

If the characteristic has attributes, you can choose them for the print-out as described under characteristics and display them.

You can select as many attributes as you want for the print characteristics you choose. However, the number of attributes should not be too large, so that data columns still fit on the page.

If you select too many columns to be printed on every page, it can mean that there is no room for a data column on the page and the query cannot be printed. Whether the first column with the characteristics and attributes is too wide for the print-out, depends on:

the number of columns on each page

the column width of the individual columns

the page width set up over the page margins.

If you want to display the attributes of the characteristic but not the characteristic itself in the print-out, select the characteristic as a printing characteristic and select Key as the display and 0 as the column width. The characteristic is then a printing characteristic, but is not displayed in the printed query.

Key Figures

TABSTRIP DISPLAY	Meaning
Automatic column width	see characteristics above.
Column on new page	If you select column on new page, a page break is inserted and the key figure appears on a new page.
Column 1	see characteristics above.