jeecgboot
图表绑定SQL数据集，运行报错
版本号：1.5.2
问题描述：图表配置SQL数据集，点击运行报错
1、SQL数据集，数据预览是有数据的
2、选择图表并配置该数据源
点击运行后出现下图错误
错误日志&截图：
/jmreport/qurestSql接口返回数据null
导致Console出错：
重现步骤：
如上。
报表SQL： SELECT t.sDate ,t.energy_id ,t.energy_name ,t.num ,t.cost FROM ( select '2022-03' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 24.00 as num, 26.00 as cost union select '2022-03' as sDate, 354538328798208 as energy_id, '自来水' as energy_name, 20.00 as num, 22.00 as cost union select '2022-03' as sDate, 354721364814848 as energy_id, '风电 ' as energy_name, 12.00 as num, 13.00 as cost union select '2022-04' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 24.00 as num, 26.00 as cost union select '2022-04' as sDate, 354538328798208 as energy_id, '自来水' as energy_name, 20.00 as num, 22.00 as cost union select '2022-04' as sDate, 354721364814848 as energy_id, '风电 ' as energy_name, 12.00 as num, 13.00 as cost union select '2022-05' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 21.00 as num, 55.11 as cost union select '2022-06' as sDate, 354538254603264 as energy_id, '消防水' as energy_name, 67.00 as num, 71.00 as cost ) t WHERE t.sDate BETWEEN DATE_FORMAT(DATE_SUB('${statisticsDate}-01', INTERVAL 11 MONTH), '%Y-%m') AND '${statisticsDate}'
参数statisticsDate 默认上月 =dateStr('yyyy-MM', -1)
友情提示（为了提高issue处理效率）：
- 积木报表是一款免费报表产品，功能免费源码不开放;
- 未按格式要求发帖，会被直接删掉;
- 请针对问题提供报表设计SQL脚本或在官网制作报表示例并提供ID;
- 针对不好重现的问题，请录制操作视频或详细的重现步骤；
