EK RTF report components for .Net
PreviousUpNext
Sum, count data inside a cycle

Optional functions may be used with commands "scan", "scanentry", "scanfooter", "endscan". 

 

These functions are SUM, CTN, CTS. You may use these functions to sum or count values of data fields and report variables. Common format is: 

 

\scancommand, ...., function1(source,destination)...functionN(...)\ 

 

Each function is performed when report generator gets corresponded scan command. 

 

The first argument in each function is "source" data field or report variable. Result of each function is stored in a report variable, which is "destination" argument. Function may have noreset option - in this case its result will not be initiated with zero value if function was computed at least once. If result variable does not exists it will be created automatically. 

 

Besides SUM, CTN, CTS functions you may call user defined functions

 

Sometimes it is necessary to declare report variable inside the report template, especially if this variable is an argument for user defined function. For this use VAR function.

Name 
Description 
SUM(source, destination [, noreset]) - totals data field or report variable.

source - data field or report variable to sum.
destination - report variable to store result of the function.... more 
CTN(source, destination [, noreset]) - counts data field or report variable for values <> 0

source - data field or report variable to count.
destination - report variable to store... more 
CTS(source, destination [, noreset]) - counts data field or report variable for not empty string values. String values containing only spaces are considered as empty.

source - data field or... more 
VAR(VAR1, ... , VAR N) - creates variables VAR1, ... VAR N if they don't exist.

Initial value for each new created variable is empty string. If report variable exists,... more 
Copyright (c) 2007. All rights reserved.