You can add, modify, and delete the headers that appear across the top of the columns in a report by using the Column Headerdialogue box.

You can also configure conditional spanning column headers based on the Periodfield, which is indicated in Column Definitions, and the Base Period, which is indicated in Report Definitions. The Base Periodis a time-saving feature when you create rolling forecast reports. For more information, see Conditional spanning headers .

Column Header dialogue box options

Option

Description

Column header text

This text appears in the column header. You can type text directly into this box, or you can click Insert AutoTextto select an option that updates the column header each time that the report is generated. To include multiple autotext codes, click Insert AutoTextagain, and then click another code in the list. For information about the available autotext variables and where they apply, see Column header autotext codes .

Format options

Lists formatting options that can be applied to a column header, such as box or underline.

Spread fromand Spread to

Defines the column or columns that the header text applies to.

Justification

Specifies how the Column header textwill align with respect to the column or range of columns that are specified in the Spread fromand Spread toboxes.

Create a column header

  1. In Report Designer, open the column definition to modify. Double-click a header cell.

  2. In the Column Headerdialogue box, enter the column header text, or click Insert AutoTextand select an option.

  3. Select a formatting style for the header in the Format optionsfield. For additional formatting options, see Manage font styles .

  4. In the Spread fromfield, type the letter of the column over which the column header should start. In the Spread tofield, type the letter of the column over which the column header should end.

  5. Under Justification, select whether the column header text to should be left, centre, or right justified.

  6. Click OK.

Add a column header row

  1. In Report Designer, open the column definition to modify.

  2. Select a cell in the header row.

  3. On the Editmenu, select Insert Row. The new row is inserted above the row that you selected in step 2.

Note Note

If you have four or more rows of report headers in a report, the headers will overlap when the report is export to a Microsoft Excel worksheet. To view all headers in the report, increase the top margin in the report definition.

Delete a column header row

  1. In Report Designer, open the column definition to modify.

  2. Select a cell in the header row to delete.

  3. On the Editmenu, select Delete Row.

See Also