回答:你要发截图你配置的信息,这样更直观
回答:这个没办法控,你选哪个就是哪个,但是下拉的数据源可以排序,这样可以展示的时候有序
回答:发文件我帮你看看
回答:多个IF嵌套,if(逻辑1,执行1,if(逻辑1,执行2.。。。))
回答:你要把具体的数据,报表截图出来,总体思路应该没有问题
回答:可以直接用sql函数
回答:卸载干净软件,重新安装吧
回答:先按月汇总后,然后过滤出来周一就行group by DATENAME(weekday,z1stmp),convert(varchar(7),z1stmp,120) having DATENAME(weekday,z1stmp)='Monday'
回答:SELECT c.item_midclsno as item_clsno_second, month(a.oper_date) mon, (select item_clsname from t_bd_item_cls where item_clsno = c.item_midclsno) as item_clsname, sum(a.sale_qty), sum(a.sale_amt), sum(a.ret_qty), sum(a.ret_amt), sum(a.giv_qty), sum(a.giv_amt) FROM t_rm_daysum a, t_bd_item_cls b, (select substring(item_clsno,1,2 * convert(int, (select sys_var_value from t_sys_system where sys_var_id = 'gl_itm_cls_nolen'))) as item_midclsno, * from t_bd_item_info) c WHERE b.item_clsno = c.item_midclsno and a.item_no = c.item_no and a.oper_date BETWEEN '2022-01-01' AND '2022-11-30' and c.item_clsno like '%' and a.branch_no like '%' and a.supcust_no like '%' and b.item_flag = '0' GROUP BY item_midclsno,month(a.oper_date)
9
9
1
10
没有更多