请上传宽度大于 1200px,高度大于 164px 的封面图片
    调整图片尺寸与位置
    滚轮可以放大缩小图片尺寸,按住图片拖动可调整位置,多余的会自动被裁剪掉
取消
dingliping(uid:80239)
职业资格认证:FCA-FineReport
  • 情况是这样的,我在原始表a 里向下级钻取,传递的参数是年份,月份,和系列到b 表,这是第一层没有问题,从b图表到c 表也要传递参数,但是问题是b表中没有月份,这样向c 传递参数的时候就传不了了,有啥办法能解决吗? 这个钻取层级就像是国家--省--县这样的,如果国家直接到县虽然可以解决,但是不太完美
  • 我写了一个语句,用了switch 函数,想问问switch里面还能再嵌套函数吗 select useyear,usemonth, ${switch(p_jb,1,"syb as bm ",2,"dept1 as bm",3,"dept2 as bm"), count(fnumber) from hr_entryjob_v a where ${switch(p_jb,1,"syb ='"+${s_syb}+"' ",2,"dept1 ='"${+s_syb}+"' ",3,"dept2 ='"+${s_syb}+"'")--这个地方如果能嵌套格式是什么样呢 and useyear=to_number(to_char(to_date('${s_day}','yyyy-mm-dd'),'yyyy')) and usemonth=to_number(to_char(to_date('${s_day}','yyyy-mm-dd'),'mm')) and FEnterDate <=to_date('${s_day}','yyyy-mm-dd') and (FLeftDate >to_date('${s_day}','yyyy-mm-dd') or FLeftDate is null) and deptid in( select deptid from pub_dept start with deptid='${p_deptid}' connect by parentdeptid=prior deptid) group by useyear,usemonth,${switch(p_jb,1,"syb ",2,"dept1 ",3,"dept2")} order by useyear,usemonth
  • 用了${switch} 但是想起个别名,不知道怎么办,求大神帮助 select useyear,usemonth, ${switch(p_jb,1,"syb ",2,"dept1 ")} ---这里想起个别名用在图表系列里,不知道怎么弄的都不对就像${switch(p_jb,1,"syb ",2,"dept1 ")} as"dept" ,count(fnumber) as rs from hr_entryjob_v where syb not in('null') and useyear=${s_year} and usemonth=${s_month} and deptid in( select deptid from pub_dept start with deptid='${p_deptid}' connect by parentdeptid=prior deptid) group by useyear,usemonth,${switch(p_jb,1,"syb ",2,"dept1 ")} order by useyear,usemonth

3

21

3

10

没有更多
个人成就
内容被浏览7,559
加入社区7年256天
返回顶部