Adding and Deleting Columns
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.
x
Procedure: How to Add a Column From the Data Source in a Financial Report
-
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.
-
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.
x
Procedure: How to Add a Calculated Value in a Financial Report
To
add a calculated value as a new column:
-
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.
-
Create
an expression from which the calculated value will be derived.
-
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.
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.