报表组织范围隔离原创
2人赞赏了该文章
117次浏览
编辑于2023年01月30日 10:40:06
要实现报表组织范围隔离,在SQL代码中添加如下条件:
where (baseunit.flongnumber like ''||( select flongnumber from T_ORG_COMPANY where fid = '@unit')||'%' or ? is null) and scmpcaltable.fperiodyear='@year' and baseunit.fid in (SELECT FOrgID FROM T_PM_OrgRange WHERE FUserID = '@ExtRptCurrentUserInfoID' AND FType = 20)
推荐阅读