• 
  填报页面，日期只能选择每月10、20、30号

  在填报页面时，日期控件只能选择每月10、20、30号，例如5.10、5.20、5.30；6.10、6.20、6.30

  325个浏览 2个回答 FineReport 2020年09月22日发布
• 
  报表父格问题，如何按照需要形式显示

  现在显示的是行政分类3对应着人力分类里的6条数据，如何显示成一条对应一条的数据，如Excel显示

  244个浏览 3个回答 FineReport 2020年06月15日发布
• 
  同一数据集，如何把纵向数据横向显示

  现在效果是第一张图片，用ID作为单元格过滤条件，想让人力的数据，从第一行开始显示，设备的数据也从第一行显示。第二张是数据库数据存储格式，第三章是设计器里样式

  753个浏览 2个回答 FineReport 2020年06月15日发布
• 
  求助！！！！！移动端用户新建问题！！！急！！！！！！！！！

  已经建了用户，在网页端也能登陆，为什么在移动端显示该用户不存在呢

  406个浏览 2个回答 FineMobile（移动客户端） 2019年06月01日发布
• 
  为什么消息模板没有微信和钉钉设置

  499个浏览 2个回答 FineReport 2020年07月04日发布
• 
  填报提交后，触发消息提醒，如何实现！急急急！！！！！！！

  填报提交后，触发消息提醒，如何实现。不是设置定时调度定期更新那种！

  1034个浏览 2个回答 FineReport 2020年07月04日发布
• 
  填报成功后，执行定时调度

  通过帆软填报，数据提交后到数据库，此时定时调度在决策系统中发出通知，如何实现呢

  642个浏览 2个回答 FineReport 2020年05月22日发布
• 
  SQL视图查询运行很快，但是模板数据集加载不出，

  代码如下：with A  as(select '工种' as 工种,case when INSTR(工种,'、')=0 then 工种 else SUBSTR(工种,0,INSTR(工种,'、')-1) end as 种类,1 as 数量 from 班组资源库),B as(select  工种,sum(数量) as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='木工'GROUP BY 工种union allselect  工种,0 as 木工,sum(数量) as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='铝模'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,sum(数量) as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='钢筋工'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,sum(数量) as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='混凝土'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,sum(数量) as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='架子工'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,sum(数量) as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='砌筑'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,sum(数量) as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='抹灰'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,sum(数量) as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='瓦工'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,sum(数量) as 机电,0 as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='机电'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,sum(数量) as 大白,0 as 粉刷石膏,0 as 其他from A where 种类='大白'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,sum(数量) as 粉刷石膏,0 as 其他from A where 种类='粉刷石膏'GROUP BY 工种union allselect 工种,0 as 木工,0 as 铝模,0 as 钢筋工,0 as 混凝土,0 as 架子工,0 as 砌筑,0 as 抹灰,0 as 瓦工,0 as 机电,0 as 大白,0 as 粉刷石膏,sum(数量) as 其他from AGROUP BY 工种)select "工种",sum(木工) as 木工,sum(铝模) as 铝模,sum(钢筋工) as 钢筋工,sum(混凝土) as 混凝土,sum(架子工) as 架子工,sum(砌筑) as 砌筑,sum(抹灰) as 抹灰,sum(瓦工) as 瓦工,sum(机电) as 机电,sum(大白) as 大白,sum(粉刷石膏) as 粉刷石膏,sum(其他)-(sum(木工)+sum(铝模)+sum(钢筋工)+sum(混凝土)+sum(架子工)+sum(砌筑)+sum(抹灰)+sum(瓦工)+sum(机电)+sum(大白)+sum(粉刷石膏)) as 其他 from B group by 工种

  366个浏览 1个回答 FineReport 2020年03月09日发布

8

0

8

10