• 
  如何不通过插件导出所有的tab块

  现在只能单个tab块导出

  443个浏览 2个回答 FineReport 2022年07月21日发布
• 
  如下图，怎么取对应每个市场后面那两列数据的其中一行，比如说下图的市场，那么K3就是4.8/37.8

  241个浏览 1个回答 2022年10月26日发布
• 
  例如，如果登录者是001，那么单独设置权限看不到某个报表块的权限该如何设置

  例如，如果登录者是001，那么单独设置权限看不到某个报表块的权限该如何设置

  335个浏览 4个回答 2022年10月13日发布
• 
  Sql中怎么使用FR的YEARDELTA函数阿

  334个浏览 4个回答 2022年09月28日发布
• 
  如下Sql，这个if是有什么问题吗，两个判断的sql一样只是查询条件不一样

  每次不管判断条件是什么只有第一个判断的数据是正确的，后面都是错误${if(ywType="1.71"," select area_name,sarea_name,market,ccusheadcode,ccusname,cusattribute,ccusperson,sum(今年值) as 今年值,sum(去年值) as 去年值,sum(前年值) as 前年值,nameStrfrom (select a.area_name,a.sarea_name,b.market,c.ccusheadcode,d.ccusname,d.cusAttribute,d.ccusperson,SUM(ISNULL(c.inatsum_bi,0)-isnull(c.thinatsum_bi,0))*b.prop_ywy AS 今年值,0 去年值,0 前年值, CASE a.area_name WHEN '赛蒙渠道' THEN '赛蒙' ELSE '明月' END AS nameStr  from BI_sale_area_part a left join BI_cus_ywy b on a.market=b.market left join BI_sale_cinvcode_day c on b.ccusheadcode=c.ccusheadcode LEFT JOIN (select  distinct ccusheadcode ,ccusname,ccusperson,cusAttribute from  BI_customer) d ON c.ccusheadcode=d.ccusheadcodewhere 1=1 and c.cinvname_bi like '%1.71%'"+if(and(or($fr_username ="21981",$fr_username ="14433"),len(propList)=0)," and cusattribute='电商客户'",if(len(propList)=0,""," and cusattribute in ('"+replace(propList,",","','")+"')"))+"and ((convert(varchar(10),day_bi,23)>='"+stratDay+"' and convert(varchar(10),day_bi,23)<='"+day+"') ) GROUP BY b.market,c.ccusheadcode,b.prop_ywy,a.area_name,d.ccusname,d.ccusperson,d.cusAttribute,a.sarea_nameunion all select a.area_name,a.sarea_name,b.market,c.ccusheadcode,d.ccusname,d.cusAttribute,d.ccusperson,0 今年值,SUM(ISNULL(c.inatsum_bi,0)-isnull(c.thinatsum_bi,0))*b.prop_ywy AS 去年值,0 前年值, CASE a.area_name WHEN '赛蒙渠道' THEN '赛蒙' ELSE '明月' END AS nameStr  from BI_sale_area_part a left join BI_cus_ywy b on a.market=b.market left join BI_sale_cinvcode_day c on b.ccusheadcode=c.ccusheadcode LEFT JOIN (select  distinct ccusheadcode ,ccusname,ccusperson,cusAttribute from  BI_customer) d ON c.ccusheadcode=d.ccusheadcodewhere 1=1  and c.cinvname_bi like '%1.71%'"+if(and(or($fr_username ="21981",$fr_username ="14433"),len(propList)=0)," and cusattribute='电商客户'",if(len(propList)=0,""," and cusattribute in ('"+replace(propList,",","','")+"')"))+"  and ( (convert(varchar(10),day_bi,23)>='"+YEARDELTA(stratDay, -1)+"'   and convert(varchar(10),day_bi,23)<='"+YEARDELTA(day, -1)+"')) GROUP BY b.market,c.ccusheadcode,b.prop_ywy,a.area_name,d.ccusname,d.ccusperson,d.cusAttribute,a.sarea_name union all  select a.area_name,a.sarea_name,b.market,c.ccusheadcode,d.ccusname,d.cusAttribute,d.ccusperson,0 今年值,0 去年值,SUM(ISNULL(c.inatsum_bi,0)-isnull(c.thinatsum_bi,0))*b.prop_ywy AS 前年值, CASE a.area_name WHEN '赛蒙渠道' THEN '赛蒙' ELSE '明月' END AS nameStr  from BI_sale_area_part a left join BI_cus_ywy b on a.market=b.market left join BI_sale_cinvcode_day c on b.ccusheadcode=c.ccusheadcode LEFT JOIN (select  distinct ccusheadcode ,ccusname,ccusperson,cusAttribute from  BI_customer) d ON c.ccusheadcode=d.ccusheadcodewhere 1=1  and c.cinvname_bi like '%1.71%'"+if(and(or($fr_username ="21981",$fr_username ="14433"),len(propList)=0)," and cusattribute='电商客户'",if(len(propList)=0,""," and cusattribute in ('"+replace(propList,",","','")+"')"))+"  and ( (convert(varchar(10),day_bi,23)>='"+YEARDELTA(stratDay, -2)+"'   and convert(varchar(10),day_bi,23)<='"+YEARDELTA(day, -2)+"')  ) GROUP BY b.market,c.ccusheadcode,b.prop_ywy,a.area_name,d.ccusname,d.ccusperson,d.cusAttribute,a.sarea_name) aa   where 1=1      "+if(len(saleList) == 0," and area_name in ( select distinct(sa.area_name) from BI_sale_area_part sa ,  BI_sale_userRole_new sb  where 1=1 and sb.userid='" +fr_username+ "'  " +if(len(userMark) == 0," and  0 ",if(userMark==0," and 1 ",if(userMark==1," and sa.area_name ",if(userMark==2," and sa.sarea_name"," and sa.market "))))+ "= " +if(len(userMark) == 0,"   1 ",if(userMark==0,"  1 "," sb.area_name "))+ " )  "," and area_name in ('" + saleList + "')")+"      "+if(len(qyList) == 0," and sarea_name in (select distinct(sa.sarea_name) from BI_sale_area_part sa ,  BI_sale_userRole_new sb  where 1=1 and sb.userid='" +fr_username+ "'  " +if(len(userMark) == 0," and  0 ",if(userMark==0," and 1 ",if(userMark==1," and sa.area_name ",if(userMark==2," and sa.sarea_name"," and sa.market "))))+ "= " +if(len(userMark) == 0,"   1 ",if(userMark==0,"  1 "," sb.area_name "))+ ") "," and sarea_name in ('" + qyList + "')")+"       "+if(len(scList) == 0," and market in (select distinct(sa.market) from BI_sale_area_part sa ,  BI_sale_userRole_new sb  where 1=1 and sb.userid='" +fr_username+ "'  " +if(len(userMark) == 0," and  0 ",if(userMark==0," and 1 ",if(userMark==1," and sa.area_name ",if(userMark==2," and sa.sarea_name"," and sa.market "))))+ "= " +if(len(userMark) == 0,"   1 ",if(userMark==0,"  1 "," sb.area_name "))+ ") "," and market in ('" + scList + "')")+" group by area_name,sarea_name,market,ccusheadcode,ccusname,cusattribute,ccusperson,nameStr order by area_name,sarea_name,market,ccusheadcode",if(ywType="防蓝光"," select area_name,sarea_name,market,ccusheadcode,ccusname,cusattribute,ccusperson,sum(今年值) as 今年值,sum(去年值) as 去年值,sum(前年值) as  前年值 from (select  a.area_name,a.sarea_name,b.market,c.ccusheadcode,d.ccusname,d.cusAttribute,d.ccusperson,SUM(ISNULL(c.inatsum_bi,0))*b.prop_ywy AS 今年值,0 去年值,0 前年值, CASE a.area_name WHEN '赛蒙渠道' THEN '赛蒙' ELSE '明月' END AS nameStr  from BI_sale_area_part a left join BI_cus_ywy b on a.market=b.market left join BI_sale_cinvcode_day c on b.ccusheadcode=c.ccusheadcode LEFT JOIN (select  distinct ccusheadcode ,ccusname,ccusperson,cusAttribute from  BI_customer) d ON c.ccusheadcode=d.ccusheadcode  WHERE 1=1  and c.cinvname_bi like '%防蓝光%'  "+if(and(or($fr_username ="21981",$fr_username ="14433"),len(propList)=0)," and cusattribute='电商客户'",if(len(propList)=0,""," and cusattribute in ('"+replace(propList,",","','")+"')"))+"  and ( (convert(varchar(10),c.day_bi,23)>='"+stratDay+"'   and convert(varchar(10),c.day_bi,23)<='"+day+"')) GROUP BY b.market,c.day_bi,c.ccusheadcode,c.year_bi,b.prop_ywy,a.area_name,d.ccusname,d.ccusperson,d.cusAttribute,a.sarea_name union all select  a.area_name,a.sarea_name,b.market,c.ccusheadcode,d.ccusname,d.cusAttribute,d.ccusperson,0 今年值,SUM(ISNULL(c.inatsum_bi,0))*b.prop_ywy AS 去年值,0 前年值, CASE a.area_name WHEN '赛蒙渠道' THEN '赛蒙' ELSE '明月' END AS nameStr  from BI_sale_area_part a left join BI_cus_ywy b on a.market=b.market left join BI_sale_cinvcode_day c on b.ccusheadcode=c.ccusheadcode LEFT JOIN (select  distinct ccusheadcode ,ccusname,ccusperson,cusAttribute from  BI_customer) d ON c.ccusheadcode=d.ccusheadcode   WHERE 1=1  and c.cinvname_bi like '%防蓝光%'   "+if(and(or($fr_username ="21981",$fr_username ="14433"),len(propList)=0)," and cusattribute='电商客户'",if(len(propList)=0,""," and cusattribute in ('"+replace(propList,",","','")+"')"))+"  and ( (convert(varchar(10),c.day_bi,23)>='"+YEARDELTA(stratDay, -1)+"'   and convert(varchar(10),c.day_bi,23)<='"+YEARDELTA(day, -1)+"')) GROUP BY b.market,c.day_bi,c.ccusheadcode,c.year_bi,b.prop_ywy,a.area_name,d.ccusname,d.ccusperson,d.cusAttribute,a.sarea_name union all select  a.area_name,a.sarea_name,b.market,c.ccusheadcode,d.ccusname,d.cusAttribute,d.ccusperson,0 今年值,0 去年值,SUM(ISNULL(c.inatsum_bi,0))*b.prop_ywy AS 前年值, CASE a.area_name WHEN '赛蒙渠道' THEN '赛蒙' ELSE '明月' END AS nameStr  from BI_sale_area_part a left join BI_cus_ywy b on a.market=b.market left join BI_sale_cinvcode_day c on b.ccusheadcode=c.ccusheadcode LEFT JOIN (select  distinct ccusheadcode ,ccusname,ccusperson,cusAttribute from  BI_customer) d ON c.ccusheadcode=d.ccusheadcode   WHERE 1=1  and c.cinvname_bi like '%防蓝光%'   "+if(and(or($fr_username ="21981",$fr_username ="14433"),len(propList)=0)," and cusattribute='电商客户'",if(len(propList)=0,""," and cusattribute in ('"+replace(propList,",","','")+"')"))+"  and ( (convert(varchar(10),c.day_bi,23)>='"+YEARDELTA(stratDay, -2)+"'   and convert(varchar(10),c.day_bi,23)<='"+YEARDELTA(day, -2)+"')) GROUP BY b.market,c.day_bi,c.ccusheadcode,c.year_bi,b.prop_ywy,a.area_name,d.ccusname,d.ccusperson,d.cusAttribute,a.sarea_name )aa where 1=1       "+if(len(saleList) == 0," and area_name in ( select distinct(sa.area_name) from BI_sale_area_part sa ,  BI_sale_userRole_new sb  where 1=1 and sb.userid='" +fr_username+ "'  " +if(len(userMark) == 0," and  0 ",if(userMark==0," and 1 ",if(userMark==1," and sa.area_name ",if(userMark==2," and sa.sarea_name"," and sa.market "))))+ "= " +if(len(userMark) == 0,"   1 ",if(userMark==0,"  1 "," sb.area_name "))+ " )  "," and area_name in ('" + saleList + "')")+"      "+if(len(qyList) == 0," and sarea_name in (select distinct(sa.sarea_name) from BI_sale_area_part sa ,  BI_sale_userRole_new sb  where 1=1 and sb.userid='" +fr_username+ "'  " +if(len(userMark) == 0," and  0 ",if(userMark==0," and 1 ",if(userMark==1," and sa.area_name ",if(userMark==2," and sa.sarea_name"," and sa.market "))))+ "= " +if(len(userMark) == 0,"   1 ",if(userMark==0,"  1 "," sb.area_name "))+ ") "," and sarea_name in ('" + qyList + "')")+"       "+if(len(scList) == 0," and market in (select distinct(sa.market) from BI_sale_area_part sa ,  BI_sale_userRole_new sb  where 1=1 and sb.userid='" +fr_username+ "'  " +if(len(userMark) == 0," and  0 ",if(userMark==0," and 1 ",if(userMark==1," and sa.area_name ",if(userMark==2," and sa.sarea_name"," and sa.market "))))+ "= " +if(len(userMark) == 0,"   1 ",if(userMark==0,"  1 "," sb.area_name "))+ ") "," and market in ('" + scList + "')")+" group by area_name,sarea_name,market,ccusheadcode,ccusname,cusattribute,ccusperson,nameStr order by area_name,sarea_name,market,ccusheadcode ",""))}

  370个浏览 3个回答 2022年09月28日发布
• 
  如下图(绿色行)，想要实现每个市场的汇总，现在每行下面都会有一个汇总，是父格设置的有问题吗

  335个浏览 4个回答 2022年09月28日发布
• 
  如下图，这个商品类别怎么挪到市场的后面，宽度不能调吗

  244个浏览 2个回答 2022年09月26日发布
• 
  如下图，比如有四个单选按钮，每个按钮对应不同的数据集，如何使用公式判断并给单元格赋值

  339个浏览 1个回答 2022年09月25日发布
• 
  如下图，柱形图如何设置分页或者滚动条，现在这样很挤而且其他省的数据没显示

  187个浏览 1个回答 2022年09月23日发布
• 
  如下sql，propList是下拉复选框，我想再加一个如果propList全选了那么就为空

  propList是下拉复选框，我想再加一个如果propList全选了那么就为空，len(propList)=0那么为空，全选了也为空，否则再加后面这个and条件"+if(len(propList)=0,"","  and d.cinvname in ('"+replace(propList,",","','")+"')")+"

  405个浏览 2个回答 2022年09月20日发布

52

2

52

10