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 │ String Formulas │ │Description Example code Result │ Description Example code Result │ │ │ │ ────────────────────────────────────────── ───────────────────────────────────────── │Integer div 4711 \ 23 204.00 │ Index of one IndexOf 6.00 │ │ │ string in an ("Cost: $234.4 │ │Decimal divi 4711 / 23 204.83 │ │ │ │ Extract Left("Test", Tes │ │Remainder 4711 mod 23 19.00 │ characters fr 3) │ │Exponentiati 1.035 ^ 30 2.81 │ Length of a Length 7.00 │ │ │ string ("T e s t") │ │Logarithm log(4711) 8.46 │ Convert Lowercase abcde │ │Sine functi sin(34.2) 0.35 │ string to ("AbCdE") │ │ │ lower case │ │Variance variance 9.00 │ Extract Mid es │ │ ([100,97,103] │ characters fro ("test",2,2) │ │ ) │ Convert ToWords two │ │ │ number to wor (2441.6) thousand │ │ │ four │ │ │ hundred fo │ ───────────────────────────────────────────────────────────────────────────────────── │ │ │ │ Date and Time Formulas │ Document Property Formulas │ │ Example code Result │ Description Example code Result │ │Description │ │ ────────────────────────────────────────── ───────────────────────────────────────── │Print Date PrintDate 4/26/24 │ │ │ │ Report FileAuthor i-net │ │ │ Author software │ │Specifying a Date 1/14/07 │ Report FileCreationDa 12/11/06 │ │date (2007,1,24) │ Creation Date te │ │Changing a DateAdd('m',3, 7/26/24 │ Export File FileFormat txt │ │date by an in PrintDate) │ Format (empty │ │ │ if no export) │ │Information DatePart('ww', 17.00 │ Time of PrintTime 3:36:43 PM │ │about a date PrintDate) │ report │ │(e.g. which │ rendering │ │calendar week │ Report Title ReportTitle Formula │ │Checking for printdate in False │ Sample │ │date ranges calendar1stQtr │ Total number TotalPageCount 1.00 │ │Conversion to CDateTime 1/14/07 │ of pages in │ │a date from a ("1/14/2007 3:14:00 PM │ the report │ │string 3:14 pm") │ │ │ │ │ ───────────────────────────────────────────────────────────────────────────────────── Page 1 © 2005-2024, i-net software