FineReport使用笔记（BI典型案例分析、SQL函数）

-----------------------------------------------总结、提高------------------------------------------------------
FineReport帮助文档

• CONCAT （Finereport报表含有参数的标题）

=CONCATENATE (LEFT($dtFromDate, 4), "年", $cmbGroup, "组AOI缺陷分类表")
-- SQL中是CONCAT，同   ||

• 时间参数处理方法

SELECT 
 COUNT(CODE)QTY, ABNORMAL_DESC
  FROM IMP_PROD_ABNORMAL
WHERE SER='AOI_Abnor'
AND CLASSIFY='${cmbGroup}'
AND TO_CHAR(OCCUR_DATE,'YYYYMMDD') BETWEEN  TO_CHAR(CASE WHEN TO_CHAR(TO_DATE(REPLACE('${dtEndDate}','-',''),'yyyymmdd')-1,'D') < '4' 
THEN  TO_DATE(REPLACE('${dtEndDate}','-',''),'yyyymmdd')-7+4-TO_CHAR(TO_DATE(REPLACE('${dtEndDate}','-',''),'yyyymmdd')-1,'D')
WHEN TO_CHAR(TO_DATE(R