Hi,
I do not want to use report wizard. I am using 2008 R2
I want to create a report eg
Deptno 10
EMPID Name Dept Sal
----------------------------
empid Ashish CC 1000
empid Raj TC 2000
total 3000
Dept no 20
EMPID Name Dept Sal
empid Ashish2 CC 100
empid Raj 2 TC 2001
total 2101
Please provide me the steps
The EMP table will contain : EMPID, NAME, DEPTNO, SAL
The DEPT table will contain: DEPTNO , DEPTNAME and LOC