Hi Chirag

Thanks for the response!!!

The first procedure you suggested me works fine, but with a bit enhancement.

I have made a full outer join between the tables and made a single select query within the stored procedure.

SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.SAL,

EMP.DEPTNO, DEPT.DEPTNO,

DEPT.DNAME, DEPT.LOC FROM EMP

full outer join DEPT on DEPT.DEPTNO = EMP.EMPNO

The stored procedure returns a result set like below...

EMPNO ENAME JOB SAL COMM DEPTNO DEPTNO DNAME LOC

NULLNULLNULLNULLNULL10ACCOUNTINGNEW YORK

NULLNULLNULLNULLNULL20RESEARCHDALLAS

NULLNULLNULLNULLNULL30SALESCHICAGO

NULLNULLNULLNULLNULL40OPERATIONSBOSTON

NULLNULLNULLNULLNULL50MARKETINGLOS VEGAS

NULLNULLNULLNULLNULL60FISHINGCALIFORNIA

NULLNULLNULLNULLNULL70APPLELAS VEGAS

5555SRIKARNULLNULL77NULLNULLNULL

7369SMITHCLERK800.0020NULLNULLNULL

7499ALLENSALESMAN1600.0030NULLNULLNULL

7521WARDSALESMAN1250.0030NULLNULLNULL

7566JONESMANAGER2975.0020NULLNULLNULL

7654MARTINSALESMAN1250.0030NULLNULLNULL

7698BLAKEMANAGER2850.0030NULLNULLNULL

7782CLARKMANAGER2450.0010NULLNULLNULL

7788SCOTTANALYST3000.0020NULLNULLNULL

7839KINGPRESIDENT5000.0010NULLNULLNULL

7844TURNERSALESMAN1500.0030NULLNULLNULL

7876ADAMSCLERK1100.0020NULLNULLNULL

7900JAMESCLERK950.0030NULLNULLNULL

7902FORDANALYST3000.0020NULLNULLNULL

7934MILLERCLERK1300.0010NULLNULLNULL

9999SUDHARSHANSQL-DBA42500.0050NULLNULLNULL

Then, while configuring the layout tab in SSRS, i created a filter and filtered the records having the null occurences for EMP table by using a filter expression as below: =IsNothing(Fields!EMPNO.Value) = = False

and similarly used expression to filter for DEPT table values without nulls.

Thanks again

Sam