Totals output in any part of a report

Usually, components in which text expressions the aggregate function call is specified, must be put in the total band or in the Data band. If the total output is to be in the Header band it is either impossible or possible using the script. But this is not all about of StimulReport.Net. The component with the aggregate function can be put in any kind of a band.

Notice. Components with aggregate functions can be put in any part of a report.

Also you can put an aggregate function on a page and other pages. For example, you can calculate the sum of values in the list and show it in the header of the list. Also you may calculate the number of strings and show its value in the beginning of a page. At that there is a restriction. You should specify to which the Data band does this aggregate function belong. For this you should specify the Data band as a function argument. For example:

{Sum(DataBand1, Products. UnitsInStock)}

- this expression will return the sum of values of the Products.UnitsInStock column for every string of the DataBand1 band. Considering the Count aggregate function:

{Count(DataBand1)}

- this expression will return the number of strings of the DataBand1 band.