做一张报表，部门和子部门联动。部门对应子部门，数据集里子部门写了一个参数DepartmentCode
部门存储过程：
select distinct DepartmentCode,DepartmentName from tblEmployee where DepartmentCode !='' and DepartmentName is not null
子部门存储过程：
select distinct SubDepartment1Code,SubDepartment1Name from tblEmployee where SubDepartment1Code !='' and SubDepartment1Name is not null and DepartmentCode=@DepartmentCode
在报表中子部门和部门怎么联动，@DepartmentCode怎么获取值？
------解决方案--------------------------------------------------------
第一次发帖就这样沉了。
------解决方案--------------------------------------------------------
该回复于2012-08-07 12:57:01被版主删除
------解决方案--------------------------------------------------------
什么情况