为了方便用户进行报表的开发,皕杰报表内置了丰富的函数,以下为各个分类函数的索引:
数据集函数索引
| avg | colcount | count | countEx | first | getfield |
| getone | group | groupEx | last | max | min |
| rgroup | rselect | select | selectEx | split | sum |
| top |
单元格函数索引
| avg | balance | call | case | col | count |
| customcell | ds | dsunion | eval | filedata | filename |
| filepath | if | list | loc | map | max |
| min | nvl | query | rank | lookup | row |
| sort | sublist | subreport | sum | uuid | uniquelist |
| zone |
字符串函数索引
| asc | char | decrypt | encrypt | fill | left |
| len | like | lower | mid | parting | pos |
| right | rplc | space | trim | upper | urlenc |
| wordcap |
日期时间函数索引
| dateafter | dateDiff | day | dayname | daynum | Days360 |
| dayscount | hour | lastday | lastmonth | lastyear | minute |
| month | monthbegin | monthend | now | quaterbegin | quaterend |
| second | timeafter | timeDiff | weekbegin | weekend | year |
数理统计函数索引
| abs | ceil | cos | exp | fact | floor |
| int | log | log10 | median | mod | pi |
| power | round | small | sign | sin | sqrt |
| stdev | stdevp | tan | var | varp |
分页运算函数索引
| pageavg | pagebottom | pagecount | pagemax | pagemin |
| pagenumber | pagepre | pagepreall | pagesum | pagetop |
转换及判断函数索引
| isdate | isEmpty | isinclude | isnumber | istime | tobigint |
| tochn | todatetime | todate | todecimal | todouble | tofloat |
| toint | tojson | tolong | tolunar | tonumber | tormb |
| toroman | tostr | totime |