Adding and Deleting Columns

How to:

Although you initially define the columns in your report in Report Painter, as you refine your financial report, you can include additional columns or delete columns directly from the Financial Report Painter.

You can include a field from the data source as a new column or create a column as a calculated value.


Top of page

x
Procedure: How to Add a Column From the Data Source in a Financial Report
  1. Right-click a column title or number and select Add Column or Insert Column from context menu. The Add Columns or Insert Columns dialog box opens.
  2. Select a field name from the Select columns to insert box and click OK. The field is either added as the last column in the report or inserted before the column in which you click.

Top of page

x
Procedure: How to Add a Calculated Value in a Financial Report

To add a calculated value as a new column:

  1. Select Computes from the Reports menu, or click the Computes icon from the Setup toolbar.

    The Report Options dialog box opens at the Computes tab.

  2. Create an expression from which the calculated value will be derived.
  3. Click Apply to add the calculated value to the Object Inspector, then click OK to close the Computes tab and return to the matrix. The new column is displayed as the last column in the matrix.

    Tip: You can drag this column to a different position in the report.

For details about calculated values, see Creating Temporary Fields in the Creating Reporting Applications With Developer Studio manual.


Top of page

x
Procedure: How to Delete a Column

Right-click a column title or number and select Delete column from context menu.

The column is removed from the matrix.


WebFOCUS