.NET 报表服务器项目
做一张报表,部门和子部门联动。部门对应子部门,数据集里子部门写了一个参数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被版主删除
------解决方案--------------------什么情况