Compartir a través de


Create and manage column headers

You can add, modify, and delete the headers that appear across the top of the columns in a report by using the Column Header dialog box. The options in the Column Header dialog box are described in the following table.

This topic also contains the following procedures:

  • Create a column header

  • Add a column header row

  • Delete a column header row

The following table describes the options in the Column Header dialog box.

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 AutoText to select an option that updates the column header every time that the report is generated. To include multiple autotext codes, click Insert AutoText again, and then click another code in the list. For information about the available autotext variables and where they apply, see Create an automatically generated header.

Format options

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

Spread from and Spread to

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

Justification

Specifies how the Column header text will align with regard to the column or range of columns that are specified in the Spread from and Spread to boxes.

Create a column header

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

  2. In the Column Header dialog box, enter the column header text, or click Insert AutoText and select an option.

  3. Select a formatting style for the header in the Format options field. For additional formatting options, see the “Format row and column text” in Row definition.

  4. In the Spread from field, type the letter of the column over which the column header should start. In the Spread to field, 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, center, 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 Edit menu, select Insert Row. The new row is inserted above the row that you selected in step 2.

    Note

    If you have four or more rows of report headers in a report, the headers will overlap when the report is exported 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 Edit menu, select Delete Row.

See Also

Format columns