• 
  查询结果与后台数据不匹配

  后台原始数据：报表查询结果：  每一个单据编号后面都会跟所有数据，以此类推：填报属性：查询界面：

  175个浏览 2个回答 2023年09月20日发布
• 
  当月剩余天数怎么计算？

  想根据月计划和月累计销售，除以“月剩余天数”来计算出每天所需的销售额。。

  238个浏览 2个回答 2023年09月18日发布
• 
  单元格怎么取FTP服务器存放的图片

         填报报表在提交时会把图片上传到FTP服务器里。  但在查询表里怎么把对应的图片显示出来呢？  插入超链接么？ 

  266个浏览 1个回答 2023年09月11日发布
• 
  为啥会查出两条数据。。。《实际完成总销售》里的33300不知道怎么出来的。。单用语句查就无问题

  1： 用语句跑就是一条数据：2：用报表就会多一条33300的数据， 不知道咋出来的

  307个浏览 3个回答 2023年09月01日发布
• 
  语句报错，看不出问题来：

  报错信息为：inserted value too large for column: search table error:  value conversion failed;exception 70004013: cannot convert "100" to the type VARCHAR(2) for column PM,Exception in executor plan337098564@hanaphn01原语句：原语句.zipSELECT A.*,B.DTXS,A.TB-1 AS TBZF,A.HB-1 AS HBZF,TB.TBSJXSJS,HB.HBSJXSJS,DY.SJXSJS,QN.QNSJXSJE ,JN.JNSJXSJE FROM (SELECT * FROM "_SYS_BIC"."CB.AL.YW/ZAL_BMYXSJDB"(PLACEHOLDER."$$CALMONTH$$"=>'202308',PLACEHOLDER."$$CALDAY$$"=>'20230813')WHERE 1=1 --AND ZICZS0000 IN (${GET_ZICZS0000}) ) ALEFT JOIN (SELECT ZICZS0000,SUM(SJXSJE) AS DTXS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJEFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALDAY='20230813'  AND A.ZICZS0008<>'8009194' --屏蔽大客户) GROUP BY ZICZS0000) B ON A.ZICZS0000=B.ZICZS0000 LEFT JOIN  ( SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS TBSJXSJS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJSFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALMONTH='20220813'  AND A.ZICZS0008<>'8009194' --屏蔽大客户) GROUP BY ZICZS0000,YF  ) TB ON A.ZICZS0000=TB.ZICZS0000 LEFT JOIN  (  SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS HBSJXSJS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJSFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALMONTH='20230713'  AND A.ZICZS0008<>'8009194' --屏蔽大客户)GROUP BY ZICZS0000,YF  ) HB ON A.ZICZS0000=HB.ZICZS0000   LEFT JOIN  (  SELECT ZICZS0000,YF AS TBYF,SUM(SJXSJS) AS SJXSJS FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAJ022 AS SJXSJSFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALMONTH='202308'  AND A.ZICZS0008<>'8009194' --屏蔽大客户)GROUP BY ZICZS0000,YF  ) DY ON A.ZICZS0000=DY.ZICZS0000 LEFT JOIN  (  SELECT ZICZS0000,SUM(SJXSJE) AS QNSJXSJE FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJEFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALYEAR='2022' AND A.CALDAY<='20220813'  AND A.ZICZS0008<>'8009194')GROUP BY ZICZS0000  ) QN ON A.ZICZS0000=QN.ZICZS0000     LEFT JOIN  (  SELECT ZICZS0000,SUM(SJXSJE) AS JNSJXSJE FROM(SELECT  A.ZICZS0000,A.CALMONTH AS YF,A.ZIFXAV010 AS SJXSJEFROM "_SYS_BIC"."CB.BL.YW/ZBL_ZDDSD001" A INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICZA0000" B ON A.ZICZA0000=B.ZICZA0000INNER JOIN "_SYS_BIC"."CB.BL.MD/MD_ZICXA0001" C ON A.ZICXA0001=C.ZICXA0001WHERE (ZICXA0004='21' OR ZICXA0004='22' OR  ZICXA0004='20' OR ZICXA0004='23') AND B.ZICZB0075<>'N' AND C.ZICXA0005='Y' AND A.CALYEAR='2023'  AND A.CALDAY<='20230813' AND A.ZICZS0008<>'8009194')GROUP BY ZICZS0000 ) JN ON A.ZICZS0000=JN.ZICZS0000 WHERE  JN.JNSJXSJE<>0 OR A.ZIFYY0801>0ORDER BY A.ZICZS0000

  301个浏览 3个回答 2023年08月14日发布
• 
  H3 公式问题

  为啥G3=00:00时，公式没有显示成“没刷卡”啊

  178个浏览 2个回答 2023年08月07日发布
• 
  帆软里，字段ZDGSJ1_1的内容固定为六位数字，如何只取前4位并且在第二位和第三位之间增加一个冒号

  帆软里，字段ZDGSJ1_1的内容固定为六位数字，如何只取前4位并且在第二位和第三位之间增加一个冒号 ?

  180个浏览 2个回答 2023年08月07日发布
• 
  两个相同的数据集，只是WHERE的科目条件不同，都是求费用合计，为甚么“临时费用”不显示值？

  两个数据集单独运行都是有结果的， 但在报表上"临时费用"就没有结果：

  216个浏览 2个回答 2023年07月27日发布
• 
  查询3个部门的销售，为何后面会多了2个单元格？

  父格设置的是A列。。门店店长首页.zip

  254个浏览 2个回答 2023年07月24日发布
• 
  条件属性怎么写？

  B列默认隐藏（列宽为0），A列是个下拉框控件，下拉内容为“正常”、“不正常”。 B列的条件属性能否设置为当A列的值下拉值为“不正常”时，B列列宽设置为20 。下拉值为“正常”时，列宽为0保持不变

  181个浏览 1个回答 2023年07月24日发布

341

43

341

10