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
In Report Designer, open the column definition to modify. Double-click a header cell.
In the Column Header dialog box, enter the column header text, or click Insert AutoText and select an option.
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.
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.
Under Justification, select whether the column header text to should be left, center, or right justified.
Click OK.
Add a column header row
In Report Designer, open the column definition to modify.
Select a cell in the header row.
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
In Report Designer, open the column definition to modify.
Select a cell in the header row to delete.
On the Edit menu, select Delete Row.