第一张图是我将查询条件改成当天查询出来的数据，第二张图是实际多天的数据库数据，请问用fineReport决策报表能否按照天生成柱形图轮换播放看了下文档，案例中用的是STRFTIME函数 但是我的数据库是SQL Server 好像不支持这个函数效果类似这个：不过我的数据库是sqlserver并不支持strftime函数--------------------------------------------------------------------------------------目前我把部分语句替换成了帆软中的公式但是通过UNIQUEARRAY(dd.select('日期'))依然获取不到日期数组select convert(varchar(5),ddate,10) as 日期, ds.cDCName as 区域, convert(decimal(20,2),(sum(iQuantity))) as 订货数量, convert(decimal(20,2),(sum(iNatSum))) as 订货总金额, enum.enumname as 用途from SO_SOMain as som left join SO_SODetails as sod on som.id = sod.IDleft join Customer as cr on som.cCusName = cr.cCusNameleft join districtclass as ds on cr.cDCCode = ds.cDCCodeleft join AA_enum as enum on sod.TJHG1_ipurpose = enum.EnumCode and enum.EnumType = 'TJHG1_Purposetype'where dDate between'${if (day(today())>26,todate(date(year(today()),month(today()),'25')),todate(date(year(today()),month(today())-1,'26')))}'and convert(varchar(100),GETDATE(),23)group by dDate,cDCName,enum.EnumNameorder by dDate,cDCName
