Formula Sample
This report shows only a few of the possibilities given by the powerful formula language supported by i-net Clear Reports. Among other things, it is additionally possible to store values in variables, run through loops and conditional branches, as well as read from files. This creates an exciting potential for analyzing and organizing your data in new and more powerful ways.
Math Formulas
204.00
Integer division
4711 \ 23
Description
Example code
Result
Decimal division
4711 / 23
204.83
Remainder
19.00
4711 mod 23
8.46
0.35
Logarithm
Sine function
log(4711)
sin(34.2)
9.00
Variance
variance
 ([100,97,103])
2.81
Exponentiating
1.035 ^ 30
6.00
String Formulas
Description
Example code
Result
Index of one string in another
IndexOf ("Cost: $234.40","$")
Extract characters from the left
Left("Test", 3)
Tes
Length of a string
Length
 ("T e s t")
7.00
abcde
Convert string to lower case
Lowercase
 ("AbCdE")
es
Extract characters from the middle
Mid
 ("test",2,2)
two thousand four hundred forty-one and 60 / 100
Convert number to words
ToWords
 (2441.6)
Result
Example code
Description
Date and Time Formulas
CDateTime ("1/14/2007 3:14 pm")
Conversion to a date from a string
printdate in calendar1stQtr
Checking for date ranges
DatePart('ww', PrintDate)
Information about a date (e.g. which calendar week)
DateAdd('m',3, PrintDate)
Changing a date by an interval
Date(2007,1,24)
Specifying a date
PrintDate
Print Date
1/14/07  3:14:00 PM
19.00
8/8/24
1/14/07
5/8/24
False
TotalPageCount
Total number of pages in the report
ReportTitle
Report Title
PrintTime
Time of report rendering
FileFormat
Export File Format (empty if no export)
FileCreationDate
Report Creation Date
FileAuthor
Report Author
Result
Example code
Description
Document Property Formulas
i-net software
12/11/06
rtf
6:13:21 AM
Formula Sample
1.00

© 2005-2024, i-net software GmbH
Page 1