请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
百煮味香(uid:836889)
职业资格认证:FCA-FineReport | FCA-FineBI | FCA-简道云 | FCP-报表交付工程师
  • 比如参评率目标是要达到95%,目前达到了91%,怎么单独做这两个数据的进度条?
  • 当$$$=190的时候。结果不应该是1吗?为什么是190?
  • 我要计算质量总分,公式是:I6*0.1+J6*0.1+K6*0.25+L6*0.15+M6*0.3+N6*0.1帆软上计算出来的结果如图:excel上的结果是
  • 第一次接触这种类型,不知道有没有前辈能够提供一下全面的指标明细,什么客户投诉拦截成功率啦之类的。
  • 可以截图或者发给我吗?可以把数据去掉
  • 以下是甲方旧报表的sql,他们是头部将finereport参数传给它,尾部直接调用数据库的参数,我要在sqlserver弄T+1再用KETTLE抽到MySQL中间库,最终是在帆软上调用这个mysql的中间库,难的是他们要求的时间维度有很多种,我应该怎么去改这个参数好呢?declare @startTime datetime ,@endTime datetime select @startTime='${startTime}' ,@endTime='${endTime}'--select @startTime = '2021-06-01', @endTime = '2021-06-10'SELECT f.FarmID,       f.FarmName as '猪场',       f.FarmName+line.LineName as '生产线',       ''         as '计划配种数',       (select count(*)        from (. as mating                 LEFT JOIN V_PigsArchives AS arc                           ON mating.PigsArchivesID = arc.PigsArchivesID                 LEFT JOIN Farm.T_Houses AS house                           ON house.HouseID = arc.HouseID)        where mating.FirstMatingDate between @startTime and @endTime          and house.ProductionLineID = line.ProductionLineID       )          as '实际配种数',       (select count(*)        from (. as pre                 LEFT JOIN V_PigsArchives AS arc                           ON pre.PigsArchivesID = arc.PigsArchivesID                 LEFT JOIN Farm.T_Houses AS house                           ON house.HouseID = arc.HouseID)        where pre.PregnancyTestDate between @startTime and @endTime          and house.ProductionLineID = line.ProductionLineID          and (pre.PregnancyTestResult = 2 or pre.PregnancyTestResult = 3)       )          as '返情空怀',           isnull((select count(*)        from (. as pre                 LEFT JOIN V_PigsArchives AS arc                           ON pre.PigsArchivesID = arc.PigsArchivesID                 LEFT JOIN Farm.T_Houses AS house                           ON house.HouseID = arc.HouseID                 right join . death on arc.PigsArchivesID = death.PigsArchivesID)        where pre.PregnancyTestDate between @startTime and @endTime          and house.ProductionLineID = line.ProductionLineID          and (pre.PregnancyTestResult = 2 or pre.PregnancyTestResult = 3)          and (death.DeathDate between @startTime and @endTime or arc.EliminatedDate between @startTime and @endTime)),0)                  as '妊娠期淘汰数',       (select count(*)        from (. as pre                 LEFT JOIN V_PigsArchives AS arc                           ON pre.PigsArchivesID = arc.PigsArchivesID                 LEFT JOIN Farm.T_Houses AS house                           ON house.HouseID = arc.HouseID)        where pre.PregnancyTestDate between @startTime and @endTime          and house.ProductionLineID = line.ProductionLineID          and (pre.PregnancyTestResult = 4)       )          as '流产'(select count(*)        from (. as change                 LEFT JOIN V_PigsArchives AS arc                           ON change.PigsArchivesID = arc.PigsArchivesID                 LEFT JOIN Farm.T_Houses AS house                           ON house.HouseID = arc.HouseID)        where change.ChangeHouseDate between @startTime and @endTime          and house.ProductionLineID = line.ProductionLineID       )          as '场内调动'FROM . f         right join . line                    on f.FarmID = line.FarmIDwhere f.OrganID = 1 and f.IsDeleted=0 and f.FarmName!='虚拟公猪站'${if(len(FarmID) == 0,""," and f.FarmID = '" + FarmID + "'")}${if(len(ProductionLineID) == 0,""," and line.ProductionLineID = '" + ProductionLineID + "'")}group by f.FarmID,f.FarmName, line.LineName, line.ProductionLineIDorder by f.FarmID
  • 项目经理要求是:15张报表,每个表写一段大的sql,这个sql在sqlserver里面做一个结果集,然后kettle进MySQL里的中间库,FR直接调用中间库的表。先上甲方给的旧报表sql针对这个旧报表的sql,我有几个问题。问题1:我如果要把这些sql复制到sqlserver,肯定运行不了,里面的变量@starttime and @endtime,我在sqlserver里面应该如何处理呢?

503

90

503

10

个人成就
内容被浏览200,803
加入社区3年109天
返回顶部