User Defined Column Report

The User Defined Column report presents a printable summary of the individual values entered for a given User Defined Column. The values represented are combined totals based on the values entered in both the Direct and Overhead Cost Schedules.

This report becomes useful for reviewing the costs that have been attributed to each value entered in a specified User Column.

REPORT

This report will display the following information:

Value (unique value that has been entered into the User Defined column being reported on)
Resource Type Breakdown
Cost Total
Cost % (the percentage of the combined total of Direct and Overhead that is the specific User Define column value)
Sell Total
Sell % (the percentage of the combined Sell Total of items in the Direct Cost Schedule)
Item Count (number of individual Schedule Items that use the specific User Defined column value)

FORMATTING OPTIONS

You can change the format of the data by clicking the Change button, in the bottom left-hand corner in the Options section of the report.

User Defined Column Report - formatting options

FORMATTING OPTION	DESCRIPTION
Displayed User Defined Column	This option allows you to set which User Defined Column will be used to generate the report. Only one User Defined Column can be added to the report at a time.
Units to Display As Columns	This allows you to select which Unit summation columns should be displayed as columns on the right-hand side of the report. These columns will summarise the resource units consumed against each User Define Column value shown.
Show Displayed Unit Total	The displayed Unit Total field allows you to select a resource unit (such as mhr or m²) to include a summation column for the unit selected. Only one Unit Total column can be added to the report at a time.

FORMATTING OPTION

DESCRIPTION

Displayed User Defined Column

This option allows you to set which User Defined Column will be used to generate the report.

Only one User Defined Column can be added to the report at a time.

Units to Display As Columns

This allows you to select which Unit summation columns should be displayed as columns on the right-hand side of the report.
These columns will summarise the resource units consumed against each User Define Column value shown.

Show Displayed Unit Total

The displayed Unit Total field allows you to select a resource unit (such as mhr or m²) to include a summation column for the unit selected.

Only one Unit Total column can be added to the report at a time.

Note: General Report Options are available as standard for this report.