Calculation of totals of a column

Using StimulReport.Net you can calculate totals in a column. Just write col in lower case before the aggregate function name. For example:

{colCount()}

- this expression will return the number of strings in one column.

There is one restriction in the calculation of totals in a column in StimulReport.Net. Totals can only be calculated in columns on a page. You cannot calculate totals in columns in the Data band.

Important! Totals can only be calculated in columns on a page. You cannot calculate totals in columns in the Data band.

When calculating totals in a column it is better put both a text component with an aggregate function the ColumnHeader, ColumnFooter, Header or Footer bands.

Notice. For aggregate function calculation in a column you should write col in lower case before the aggregate function name.

You can calculate unlimited number of totals in a column. There are no any restrictions applied. Also it is acceptable to combine totals in a column with a condition. For example:

{colCountIf(DataBand1, Products.UnitsInStock = 0)}

- this expression will return the number of strings with true condition in a column.