1
Download Stimulsoft Reports
Transcript
738
Stimulsoft Reports
the Latin letter D in uppercase before the function name. For calculations using the Int64 type it is
necessary to add Latin letter I in uppercase. For example, for calculation sum using the Int64 type it is
necessary to write:
SumI
For the Double type:
SumD
For the Decimal type:
Sum
It allows preventing losses in totals calculation.
Aggregate function spelling
Type of return value
Sum
Decimal
SumD
Double
SumI
Int64
I, D letters can be added to any functions except for: Count and CountDistinct. These functions always
return the Int64 type .
Notice: The Count and CountDistinct functions are always calculated using the Int64 type.
5.31.1.3 Expression with Aggregate Functions
To sum up all values of one column it is enough to write the following text expression of a component:
{Sum(DataSource.Column)}
Also it is acceptable to use complex expressions:
{100 + Sum(DataSource.Column) * 2}
© 2003-2013 Stimulsoft
