目前的情况是: 当同期值与查询值一一对应时 同期值与查询值无一一对应值的时候如图 查询值的数据集如下: select ${p11}, SUM(ElectricValue) AS E,sum(WaterValue) as W,sum(GasValue) as G,sum(CompressedAirValue) as C,SUM(ElectricCost) AS EC,sum(WaterCost) as WC,sum(GasCost) as GC,sum(TotalCost) as TC from dbo.RES_Energydata_copy1 where 1=1 ${if(p11='Hour',"and RES_Energydata_copy1.[day2]= '"+ date +"' and RES_Energydata_copy1.[hour] >= '"+ 开始时间 + "'and RES_Energydata_copy1.[hour] group by ${p11} order by ${p11} 希望不管同期值是否有值与查询值对应,都可以实现下图的效果 得到同期值参数的办法: 数据集查询结果: |