• 
  IF判断如果$XMFL控件框等于\'信息\'A2返回‘政企业务’，等于‘工程’返回‘运营商业务’？

  255个浏览 4个回答 2023年03月28日发布
• 
  数据值按纵向扩展，B4已可以按数据纵向求和，C3怎么进行横向的求和怎么设置

  530个浏览 3个回答 2023年03月27日发布
• 
  IF判断时怎么给字段别名，使用leftjion,on部分使用IF判断给on部分赋值写法是否正确？

  SELECT ${IF(LEN($AREA)>0,"地市,","")}${IF(LEN($XMFL)>0,"项目段,","")}(-),(-),(-),(-),(-),(-),(-),(-),(-),(-),(-),(-),(-)FROM(SELECT * FROM(SELECT ${IF(LEN($AREA)>0,"地市,","")}${IF(LEN($XMFL)>0,"项目段,","")}SUM(case when  科目描述 like'%实际%' then 本币余额  else 0 end)/10000  as ,SUM(case when  科目描述 like'%暂估%'   then 本币余额  else 0 end)/10000  as ,SUM(case when  <> '未核销收款'  then 本币余额  else 0 end)/10000  as ,SUM(case when <> '未核销收款'  then else 0 end)/10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0  end )/10000 as ,SUM(case when <> '未核销收款'  then  else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0 end) /10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0 end)/10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000  as ,SUM(case when <> '未核销收款'  then else 0 end )as   FROM 应收预收账龄余额表 where left(,4)='1131' and 来源='应收账款'   and 日期='2023-03-23'  and 公司段说明='分公司'  ${IF(LEN(AREA)>0," AND 地市 in ('"+AREA+"')","")}  ${IF(LEN(XMFL)>0," AND 项目段 in ('"+XMFL+"')","")}   ${IF(LEN(XMFL)>0&&LEN(AREA)>0," group by 地市,项目段","")}  ${IF(LEN(XMFL)>0&&LEN(AREA)=0," group by 项目段","")}  ${IF(LEN(XMFL)=0&&LEN(AREA)>0," group by 地市","")}) a  left JOIN  ( SELECT${IF(LEN($AREA)>0,"地市,","")}${IF(LEN($XMFL)>0,"项目段,","")}SUM(case when  科目描述 like'%实际%' then 本币余额  else 0 end)/10000  as ,SUM(case when  科目描述 like'%暂估%'   then 本币余额  else 0 end)/10000  as ,SUM(case when  <> '未核销收款'  then 本币余额  else 0 end)/10000  as ,SUM(case when <> '未核销收款'  then else 0 end)/10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0  end )/10000 as ,SUM(case when <> '未核销收款'  then  else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0 end) /10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000 as ,SUM(case when <> '未核销收款'  then else 0 end)/10000 as ,SUM(case when <> '未核销收款'  then else 0 end )/10000  as ,SUM(case when <> '未核销收款'  then else 0 end )as   FROM 应收预收账龄余额表 where left(,4)='1131' and 来源='应收账款'   and 日期='2023-02-27'  and 公司段说明='分公司'  ${IF(LEN(AREA)>0," AND 地市 in ('"+AREA+"')","")}  ${IF(LEN(XMFL)>0," AND 项目段 in ('"+XMFL+"')","")}   ${IF(LEN(XMFL)>0&&LEN(AREA)>0," group by 地市,项目段","")}  ${IF(LEN(XMFL)>0&&LEN(AREA)=0," group by 项目段","")}  ${IF(LEN(XMFL)=0&&LEN(AREA)>0," group by 地市","")}) b  on  ${IF(LEN(XMFL)>0&&LEN(AREA)>0," a.地市=b.地区,a.项目段=b.项目类","")}  ${IF(LEN(XMFL)>0&&LEN(AREA)=0," group by a.项目段=b.项目类","")}  ${IF(LEN(XMFL)=0&&LEN(AREA)>0," group by a.地市=b.地区","")})main 

  267个浏览 1个回答 2023年03月26日发布
• 
  FR跟根据起止日期扩展年月，再根据已扩展的年月查询库表中的每个月中最大的数据日期作为月度数据，怎么写

  234个浏览 1个回答 2023年03月24日发布
• 
  FR通过控件日期，返回上月最大日期的日期，怎么修改？

  sql('Szgc_Data',"select MAX(日期) from 应收预收账龄余额表  where LEFT(日期,7)='"+format($TD,"yyyy-MM")+"'",1,1)

  235个浏览 3个回答 2023年03月24日发布
• 
  帆软批量导入10万级的数据，提示timeout，当数据量大的时候该设置什么参数会好点？

  198个浏览 1个回答 2023年03月23日发布
• 
  帆软if怎么再多套一层判断，满足B单元，取AV地市关键字，AV取不到同样满足B，取J列单元格关键字？

  帆软if怎改再多套一层判断，满足B单元，取AV地市关键字，AV取不到同样满足B，取J列单元格地市关键字，满足B单元，AV,J都取不到则返回‘本级’，不满足B的条件则就返回‘其他’？IF(B4="建设有限公司分公司",IF(FIND("南宁",AV4) != 0,"南宁",IF(FIND("桂林",AV4) != 0,"桂林",IF(FIND("柳州",AV4) != 0,"柳州",IF(FIND("玉林",AV4) != 0,"玉林",IF(FIND("百色",AV4) != 0,"百色",IF(FIND("河池",AV4) != 0,"河池",IF(FIND("贵港",AV4) != 0,"贵港",IF(FIND("钦州",AV4) != 0,"钦州",IF(FIND("梧州",AV4) != 0,"梧州",IF(FIND("北海",AV4) != 0,"北海",IF(FIND("崇左",AV4) != 0,"崇左",IF(FIND("来宾",AV4) != 0,"来宾",IF(FIND("贺州",AV4) != 0,"贺州",IF(FIND("防城",AV4) != 0,"防城","本级")))))))))))))),"其他")

  783个浏览 2个回答 2023年03月20日发布
• 
  FR没有数据日期怎么置灰？比如数据库有2月28日、3月3日的数据、3月1、2日如何置灰？

  287个浏览 3个回答 2023年03月06日发布
• 
  FR填报函数now（）,精确到小数点，怎么去掉小数点后面的时间戳也能按DATETIME类型存SQL库

  317个浏览 5个回答 2023年03月03日发布
• 
  FR帆软批量导入上限能导几万+的数据？感觉导入1、2万+的数据加做一些清洗耗时及响应都比较吃力了

  十万级左右的数据导入清洗，有什么好的解决方案？

  1002个浏览 3个回答 2023年03月03日发布

97

0

97

10