Cost Register


A cost register report is a tabular report consisting of rows and columns of data. You can control the fields (columns) and the records (rows) included in the report, as well as all aspects of formatting. You can optionally have a header block containing general parameters such as unit prices and tax rates.


The cost register report is closest to what most people think of as a costing spreadsheet. The difference is that, with a simple costing spreadsheet the database and report are one and the same, and the data shown cannot easily be modified in terms of fields and records. In the case of a Mandrel cost register, the database is contained elsewhere in your datafile and the report is simply an extract from that database converted into a report. Consequently, you have complete control over what the report contains and how it is laid out and formatted.


Field Independence

A significant characteristic of a cost register is that every cost field is calculated independently of every other field. If you have a right hand column, for example, giving the overall cost for each cost item, its values will not be altered if you add or remove other columns from the report.


Rolled-Up Costs

Cost register reports can show individual cost items, or they can show rolled-up costs, i.e. costs combined into larger groupings. You can show costs rolled up to a given level in the cost breakdown structure, or you can show them rolled up by some field you have defined yourself, such as Task Manager or Responsible Organization.



A cost register, like all Mandrel reports, is inherently read-only. While it is possible to manually alter the data displayed in a report, such changes will not be reflected back into the database. To make such changes you must use the in-line editing process.