finereport mysql_报表组件FineReport中SQL函数的介绍

若需要显示某个具体值，如：显示 Jonny 的效果(即班级为Class1的第3列第4行的值)，写法如下：

=sql("FRDemo","SELECT * FROM STSCORE where CLASSNO = 'Class1' ",3,4)

若参数值为变量如为报表参数或者是某个单元格，则写法如下：

=sql("FRDemo","SELECT * FROM STSCORE where CLASSNO = '"+$class+"' ",3,4)

或

=sql("FRDemo","SELECT * FROM STSCORE where CLASSNO = '"+A1+"' ",3,4)

如果传递的参数是获取当前单元格的值，即用$$$作为参数时，字符串类型同样需要拼接单引号，如下：

=sql("FRDemo","SELECT * FROM STSCORE where CLASSNO = '"+$$$+"' ",3,4)

注：如果参数或者单元格值有多个，那么sql函数的写法如下：

=sql("FRDemo","SELECT * FROM STSCORE where CLASSNO in ('"+$class+"') ",3,4)