FineReport 日常使用记录

取当月的第一天： date(year(today()),month(today()),1)

截取：Left Right

 

简单加参数示例：

select * from n8yu8p
${if(productName!=''," where 产品名 in ('"+productName+"')","")}