The above solution will give partial report we can get complete report by adding more conditions

Thank you all once again

Thank you all.

I found the solution

The sql query looks something like this

select fdate, total(c_type),

total(c_status) = (select count(*) where c_type = 'L' and date = fdate)

total(c_status P) = select count(*)...

date c_type c_status

5/11/08 L ...

I am looking for a query which can give monthly totals of total (L and D)

total (L) and total p( in L) and total d(in L) similarlyt total p( in...