为了方便用户进行报表的开发,皕杰报表内置了丰富的函数,以下为各个分类函数的索引:
数据集函数索引
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 |