Report Column

Moneylender's Column Editor window for setting columns on single loan and multi-loan reports.

You can find this window from Reports > Customize, creating or editing a report, and then creating or editing a column on that report.

Column Heading – This is the text that appears on the report at the top of the column.

Format – This determines what kind of formatting will be applied to the values that are displayed in the column.

Alignment – How to align the value in within the report table’s cell. Commonly, numbers are aligned to the right so their digits line up.

Summation – What should be shown in the summation row for this column. If any column has a value other than None for the summation setting, the report will have an extra row added to the bottom which contains the values specified by the summation setting on each column. If all columns have None for summation, this extra row is omitted.

Width – enter a number for the width in points for the column. Any columns with a width of zero will share the available space equally. If the report is meant to be printed, you may wish to set the widths of the columns specifically so the report will fit on the printed page in an easy-to-interpret layout.

Defining a Column Value

Each report type has a set of record values that it can supply to the report engine. You can use these record values to define the value you wish to appear in the column. Commonly, a single record value is all that’s needed to set up a column value. If you wanted to know how much of the amount due was just principal, interest and fees to the exclusion of any escrow that was due, you might set up a column value like “SummaryOfFinances:AmountDue – SummaryOfFinances:EscrowDue” to subtract out the escrow due from the total amount due.

Record Value – Select the record value you wish to insert into the column value definition. The available record values will differ depending on the report type chosen. Record Values Available for Report Columns.

Add – once you have chosen the desired record value, click add to append it to the column value definition.

Math Buttons (plus minus multiply divide) – click one of these buttons to append the corresponding mathematical operation to the column value.

Clear – click this to reset the column value to blank so you can create a new column value definition.

Column Value – this shows the current definition of the column value.

Done – save the column as it appears on this window to the report and close the Report Column window.

Cancel – abandon the column as it appears in this window and close the window. You can also click the X in the corner of the window to accomplish the same thing.