Specifications

CrosstabCount
658 InfoMaker
Return value
Decimal. Returns the average of the crosstab values returned by expression n
for all the column values or, optionally, for a subset of column values.
Usage Use this function instead of CrosstabAvg when you want to return a decimal
datatype instead of a double datatype. For more information, see
CrosstabAvg.
See also CrosstabMaxDec
CrosstabMinDec
CrosstabSumDec
CrosstabCount
Description Counts the number of values returned by an expression in the values list of the
crosstab. When the crosstab definition has more than one column,
CrosstabCount can also count the number of the expression’s values for groups
of column values.
For crosstabs only
You can use this function only in a crosstab report.
Syntax CrosstabCount ( n {, column, groupvalue } )
Return value
Long. Returns the number of values returned by expression n for all the column
values or, optionally, for a subset of column values.
Usage This function is meaningful only for the count of the values of the expression
in a row in the crosstab. This means you can use it only in the detail band, not
in a header, trailer, or summary band.
Null values are ignored and are not included in the count.
Argument Description
n The number of the crosstab-values expression for which you want
the total number of returned values.
column
(optional)
The number of the crosstab column as it is listed in the Columns box
of the Crosstab Definition dialog for which you want intermediate
calculations.
groupvalue
(optional)
A string whose value controls the grouping for the calculation.
Groupvalue is usually a value from another column in the crosstab.
To specify the current column value in a dynamic crosstab, rather
than a specific value, specify @ plus the column name as a quoted
string.