• 
  可以在第二页加标题吗，询问笔录（副页）

  询问笔录（副页）

  322个浏览 2个回答 FineReport 2021年05月25日发布
• 
  帆软可以做这个时间格式吗加下划线的

  472个浏览 2个回答 FineReport 2021年05月24日发布
• 
  这个时间控件上传日期怎么取本月第一天，结案日期怎么设置初始值为空值

  上传日期 dateStart_c_c  结案日期 dateStart_c_c_c 结束dateEnd_c_c_c

  448个浏览 2个回答 FineReport 2021年05月21日发布
• 
  sql拼接时间我直接传入参数，是正常的，但是通过选择控件日期以后查询就报错了

  447个浏览 2个回答 FineReport 2021年05月21日发布
• 
  在sql里面判断时间控件为啥会报错呢？

  SELECTCASE WHENt1.areaCode THEN( SELECT sc.areaName FROM s_citycounty sc WHERE sc.areaCode = t1.areaCode ) END AS areaName,t1.countall,t2.zcall,t2.anjuan,t3.lhzctall,t3.xzchjds,t3.czjcd,t1.penalty AS penalty1,t2.penalty AS penalty2,t3.penalty AS penalty3 FROM(SELECTsubstr( bb.areaCode, 1, 4 ) AS areaCode,count( bci.id ) AS countall,sum( bb.penalty ) AS penalty FROMs_project spLEFT JOIN bwsn_count_integrity bci ON sp.id = bci.pidLEFT JOIN bwsn_basicinfo bb ON sp.id = bb.pid WHEREbb.ishistory = 1 AND bb.historytype = "案件上传" AND sp.STATUS = "结案" if(len(dateStart_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateStart_c_c}")if(len(dateEnd_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c}")if(len(dateStart_c_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateStart_c_c_c}")if(len(dateEnd_c_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c_c}")GROUP BYsubstr( bb.areaCode, 1, 4 ) ) t1LEFT JOIN (SELECTsubstr( bb.areaCode, 1, 4 ) AS areaCode,count( bci.id ) AS zcall,sum( bci.num & 1 = 1 ) AS anjuan,sum( bb.penalty ) AS penalty FROMs_project spLEFT JOIN bwsn_count_integrity bci ON sp.id = bci.pidLEFT JOIN bwsn_basicinfo bb ON sp.id = bb.pid WHEREbb.ishistory = 1 AND bb.historytype = "案件上传" AND bb.caseType = "治超" AND sp.STATUS = "结案" if(len(dateStart_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateStart_c_c}")if(len(dateEnd_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c}")if(len(dateStart_c_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateStart_c_c_c}")if(len(dateEnd_c_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c_c}")GROUP BYsubstr( bb.areaCode, 1, 4 ) ) t2 ON t1.areaCode = t2.areaCodeLEFT JOIN (SELECTsubstr( bb.areaCode, 1, 4 ) AS areaCode,count( bci.id ) AS lhzctall,sum( bci.num & 2 = 2 ) AS xzchjds,sum( bci.num & 4 = 4 ) AS czjcd,sum( bb.penalty ) AS penalty FROMs_project spLEFT JOIN bwsn_count_integrity bci ON sp.id = bci.pidLEFT JOIN bwsn_basicinfo bb ON sp.id = bb.pid WHEREbb.ishistory = 1 AND bb.historytype = "案件上传" AND bb.caseType = "联合治超" AND sp.STATUS = "结案" if(len(dateStart_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateStart_c_c}")if(len(dateEnd_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c}")if(len(dateStart_c_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateStart_c_c_c}")if(len(dateEnd_c_c_c)=0,"",AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c_c}")GROUP BYsubstr( bb.areaCode, 1, 4 ) ) t3 ON t1.areaCode = t3.areaCode

  501个浏览 3个回答 FineReport 2021年05月21日发布
• 
  怎么把金额转换成图上这种

    1.当事人赔（补）偿：人民币${=if(len(ds2.select(penalty))=0,"",ds2.select(penalty))}(${=REPLACE(if(len(ds2.select(penalty))=0,"",CNMONEY(ds2.select(penalty))),"圆","元")})；

  514个浏览 2个回答 FineReport 2021年05月20日发布
• 
  sql里面判断传入的这个时间控件的值，怎么判断控件有值的时候，才使用这个条件？

  SELECTCASE WHEN t1.areaCode THEN ( SELECT sc.areaName FROM s_citycounty sc WHERE sc.areaCode = t1.areaCode )  END AS areaName, t1.countall, t2.zcall, t2.anjuan, t3.lhzctall, t3.xzchjds, t3.czjcd, t1.penalty AS penalty1, t2.penalty AS penalty2, t3.penalty AS penalty3  FROM ( SELECT substr( bb.areaCode, 1, 4 ) AS areaCode, count( bci.id ) AS countall, sum( bb.penalty ) AS penalty  FROM s_project sp LEFT JOIN bwsn_count_integrity bci ON sp.id = bci.pid LEFT JOIN bwsn_basicinfo bb ON sp.id = bb.pid  WHERE bb.ishistory = 1  AND bb.historytype = "案件上传"  AND sp.STATUS = "结案"  AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c}" AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') <="${dateStart_c_c}" AND DATE_FORMAT(sp.endTime,'%Y-%m-%d')>="${dateEnd_c_c_c}" AND DATE_FORMAT(sp.endTime,'%Y-%m-%d')<="${dateStart_c_c_c}" GROUP BY substr( bb.areaCode, 1, 4 )  ) t1 LEFT JOIN ( SELECT substr( bb.areaCode, 1, 4 ) AS areaCode, count( bci.id ) AS zcall, sum( bci.num & 1 = 1 ) AS anjuan, sum( bb.penalty ) AS penalty  FROM s_project sp LEFT JOIN bwsn_count_integrity bci ON sp.id = bci.pid LEFT JOIN bwsn_basicinfo bb ON sp.id = bb.pid  WHERE bb.ishistory = 1  AND bb.historytype = "案件上传"  AND bb.caseType = "治超"  AND sp.STATUS = "结案"  AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c}" AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') <="${dateStart_c_c}" AND DATE_FORMAT(sp.endTime,'%Y-%m-%d')>="${dateEnd_c_c_c}" AND DATE_FORMAT(sp.endTime,'%Y-%m-%d')<="${dateStart_c_c_c}" GROUP BY substr( bb.areaCode, 1, 4 )  ) t2 ON t1.areaCode = t2.areaCode LEFT JOIN ( SELECT substr( bb.areaCode, 1, 4 ) AS areaCode, count( bci.id ) AS lhzctall, sum( bci.num & 2 = 2 ) AS xzchjds, sum( bci.num & 4 = 4 ) AS czjcd, sum( bb.penalty ) AS penalty  FROM s_project sp LEFT JOIN bwsn_count_integrity bci ON sp.id = bci.pid LEFT JOIN bwsn_basicinfo bb ON sp.id = bb.pid  WHERE bb.ishistory = 1  AND bb.historytype = "案件上传"  AND bb.caseType = "联合治超"  AND sp.STATUS = "结案"  AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') >="${dateEnd_c_c}" AND DATE_FORMAT(sp.createTime,'%Y-%m-%d') <="${dateStart_c_c}" AND DATE_FORMAT(sp.endTime,'%Y-%m-%d')>="${dateEnd_c_c_c}" AND DATE_FORMAT(sp.endTime,'%Y-%m-%d')<="${dateStart_c_c_c}" GROUP BY substr( bb.areaCode, 1, 4 )  ) t3 ON t1.areaCode = t3.areaCode

  905个浏览 2个回答 FineReport 2021年05月19日发布
• 
  序号怎么根据左边的数据自动生成并且排序？

  503个浏览 2个回答 FineReport 2021年05月19日发布
• 
  这个序号怎么根据左边的数据自动生成排序

  503个浏览 1个回答 FineReport 2021年05月18日发布
• 
  完整率怎么计算用什么公式案件数量案卷上传数量完整率

  711个浏览 2个回答 FineReport 2021年05月18日发布

157

11

157

10