1樓
liuya0428 發(fā)表于：2011/3/24 10:32:50
SELECT *
FROM tb_hr_user thu
WHERE thu.c_no IN (SELECT c_userno
FROM tb_user_post
WHERE (
c_post_guid IN (/*下屬信息*/
SELECT c_guid
FROM tb_post
WHERE c_x_higher_post IN (SELECT
c_post_guid
FROM
tb_user_post
tup
WHERE
c_userno =
'"+Parameters!用戶編號(hào)_.Value+"')
OR c_y_higher_post IN (SELECT
c_post_guid
FROM
tb_user_post
tup
WHERE
c_userno =
'"+Parameters!用戶編號(hào)_.Value+"')
OR c_next_higher_post IN (SELECT
c_post_guid
FROM
tb_user_post
tup
WHERE
c_userno =
'"+Parameters!用戶編號(hào)_.Value+"'))
OR c_userno = '"+Parameters!用戶編號(hào)_.Value+"' /*看到自己的信息*/
))
2樓
liuya0428 發(fā)表于：2011/3/24 10:35:05
可以限制報(bào)表中，當(dāng)前用戶所看到的下屬人員相關(guān)的信息。