<< Click to Display Table of Contents >> Navigation:  Available Functions > ReportCol()

Syntax

ReportCol( <ColumnNumber> )

 

Purpose

To acquire the value of another report column during the printing of a report.

 

Parameters

<ColumnNumber> is the number of the report column to acquire the value of during the printing of a report.

 

Returns

The value of the report column given by <ColumnNumber>.

 

Usage

This is a very convenient feature of the report writer. It allows you to incorporate values from adjacent report columns into the value of the current column. This capability is very similar to that of spreadsheet programs which allow you to define "cells" in terms of the cells around them. In DonorQuest, report columns can be thought of as "cells".

 

In the report writer, the column number for each field expression is shown to the left of the field expression (see figure 13.6 of section thirteen). This is the number you must use with the ReportCol() function when referencing the value of a column in the report.

 

Example

The following examples draw on a hypothetical report of four columns containing each donor's first name, last name, donation total for current year, and donation total for last year:

 

 

See Also:

ReportColSum(), ReportLine(), ReportPage()