Using Stimulsoft Reports it is possible to calculate total by a column. Just write col (from column) in lowercase before the aggregate function name. For example:
{colCount()}
- the expression will return the number of rows in one column.
There is one restriction in calculation of totals by a column in Stimulsoft Reports. Totals can only be calculated by columns on a page. It is impossible to calculate totals by columns in the Data band.
Important!
Totals can
only be calculated by columns on a page. It is impossible to
calculate totals by columns in
the Data
band.
When calculating totals by a column, the text component with aggregate function should be placed on ColumnHeader, ColumnFooter, Header of Footer bands.
Important.
For calculation aggregate
functions by column it is enough to add col
before the name of an
aggregate function.
It is possible to calculate unlimited number of totals by column. There are no limitations in this case. Also it is possible to combine totals by column with condition. For example:
{colCountIf(DataBand1, Products.UnitsInStock = 0)}
- this expression will return the number of rows, which condition is set to true, by a column.