要实现报表组织范围隔离，在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)