• 
  同比柱状图

  页面条件下拉框已做好，这中同比这种图的sql怎么写，图怎么制作的，写个例子就好，谢谢各位大佬

  630个浏览 4个回答 FineReport 2019年01月22日发布
• 
  错误代码:1302 行高列宽超出页面大小设置 行15

  预览出现这个，如何怎么解决

  947个浏览 9个回答 FineReport 2018年11月06日发布
• 
  Sql嵌套报错

  select a.*,case when b.zhuanban is null then 0 else b.zhuanban end from(    select a.*,case when b.db is null then 0 else b.db end from(        select a.*,case when b.zb is null then 0 else b.zb end from (            select loginname,realname from sys_user where unitid = '0203'        )a left join (select loginname,count(1) zb from slj_info where letterstate = 8  --zhiban            group by loginname        )b on a.loginname = b.loginname    )a left join (select loginname,count(1) db from slj_info where letterstate = 9  --duban        group by loginname    )b on a.loginname = b.loginname)a left join (select loginname,count(1) zhuangban from slj_zhuanban    group by loginname )b on a.loginname = b.loginname三张表，直办督办都在info表中的状态，转办是单独一张表，怎么嵌套

  724个浏览 5个回答 SQL 2018年11月14日发布
• 
  oracle 时间转换

  怎么把毫秒转换成分钟，网上给的(CALLINTERVAL % (1000 * 60 * 60)) / (1000 * 60) 不对啊

  419个浏览 3个回答 FineReport 2018年12月24日发布
• 
  横向滚动条

  我在重复与冻结里设置了行冻结，可以有纵向滚动条，我现在设置A列冻结，为什么没有横向滚动条，大佬们，看到帮忙说出问题在哪，怎么解决

  1364个浏览 1个回答 FineReport 2018年12月03日发布
• 
  seq序列自增

  谢了seq()公式但没有自增还有这个符号怎么添加

  2457个浏览 5个回答 FineReport 2018年11月23日发布
• 
  字段合并

  序号设置成12345自增长模式，电话号码显示在日期上面但不分行效果图

  805个浏览 2个回答 FineReport 2018年11月17日发布
• 
  Sql怎么写

  select a.*,case when b.zhuanban is null then 0 else b.zhuanban end from(    select a.*,case when b.db is null then 0 else b.db end from(        select a.*,case when b.zb is null then 0 else b.zb end from (            select loginname,realname from sys_user where unitid = '0203'        )a left join (select loginname,count(1) zb from slj_info where letterstate = 8  --zhiban            group by loginname        )b on a.loginname = b.loginname    )a left join (select loginname,count(1) db from slj_info where letterstate = 9  --duban        group by loginname    )b on a.loginname = b.loginname)a left join (select loginname,count(1) zhuangban from slj_zhuanban    group by loginname)b on a.loginname = b.loginname最后一张slj_zhuanban怎么和前面的拼接在一起

  566个浏览 1个回答 FineReport 2018年11月13日发布
• 
  sql怎么写

  select a.*,b.wpj from(select a.*,b.bmy from(select a.*,b.yb  from (select a.*,b.my from (    select loginname ,realname from sys_user where unitid='0204')a left join (select LOGINANME,count(1) my from slj_callback where sat= 3 --manyi ${if(len(ks) == 0,""," AND substr(backtime,1,15)>='"+ks+"'")} ${if(len(js) == 0,""," AND substr(backtime,1,15)<='"+js+"'")}      group by LOGINANME) b on a.loginname =b.LOGINANME ) a  left join (select loginanme,count(1) yb from slj_callback where sat = 2  --yiban ${if(len(ks) == 0,""," AND substr(backtime,1,15)>='"+ks+"'")} ${if(len(js) == 0,""," AND substr(backtime,1,15)<='"+js+"'")}      group by loginanme) b on a.loginname = b.loginanme)a  left join (select loginanme,count(1) bmy from slj_callback where sat = 1  --bumanyi ${if(len(ks) == 0,""," AND substr(backtime,1,15)>='"+ks+"'")} ${if(len(js) == 0,""," AND substr(backtime,1,15)<='"+js+"'")}      group by loginanme) b on a.loginname = b.loginanme) a left join (select loginanme,count(1) wpj from slj_callback where sat = 0  --weipingjia ${if(len(ks) == 0,""," AND substr(backtime,1,15)>='"+ks+"'")} ${if(len(js) == 0,""," AND substr(backtime,1,15)<='"+js+"'")}      group by loginanme) b on a.loginname = b.loginanme 默认条件下，查询出来的空值判断设置成0

  877个浏览 4个回答 FineReport 2018年11月13日发布
• 
  自适应没反应

  121554

  393个浏览 7个回答 FineReport 2018年10月24日发布

10

3

10

10