Creating Column Headings

You define the column headings for a report within the related column set. You can create custom column headings or modify default headings to meet your specific reporting needs. Your column headings can be static, or you can use relative headings to create dynamic column headings whose content changes depending on the period you specify when you run the report.

Note: You can also create and edit column headings with the Column Set Builder.

To create column headings:

  1. Navigate to the Column Set window.

  2. Query a column set Name.

  3. Choose Create Heading.

  4. Optionally, choose Create Default Heading to modify the default column headings. FSG builds default headings based on the amount type and period offset defined for your columns. If no amount types or period offsets are defined, the default heading displays your runtime period.

  5. Enter or change the heading for each column, using the displayed ruler as a guide. If desired, you can enter relative headings to create dynamic column headings. See: Relative Headings.

    Note: The ruler appears above the heading, displaying X's for allocated character positions and spaces, 9's for number positions, and periods for the required minimum one space between each column. These settings are determined automatically from the starting positions and format masks of your column definitions.

    Note: If you wish to publish a FSG report using BI Publisher, BI publisher displays as many heading lines as your report template allows. If you have a report template that allows less column heading lines than is defined for your column set, the report only displays the heading lines as defined by the template.

    When positioning your column headings using the Column Headings window, you must use character spaces, such as the space bar or arrow keys, to position your headings. You cannot use the tab key to position your headings. Make sure your column headings are positioned as defined for the columns. For example, if your column starting position is set to 45 character spaces, make sure your column heading begins at 45 character spaces.

    Make sure you include enough space in your column definition to print all the numbers and special characters defined by the format mask.

  6. Choose Apply to save your heading and continue working in this window.

  7. Choose OK to save your work and close the column headings window.

Related Topics