皕杰报表内置函数介绍

为了方便用户进行报表的开发,皕杰报表内置了丰富的函数,以下为各个分类函数的索引:

数据集函数索引

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