Hi everyone
I really need to get this done, please try to help me.
I'll appreciate any help i get.

I have a View in my SQL Server DB which has following data.

cardtype totaltype amount

type1 R16-Balance 12000.50
type1 R32-Balance 15000.70
type2 R16-Balance 18000.50
type2 R32-Balance 19450.60
type3 R16-Balance 12500.50
type3 R32-Balance 18550.80


I am trying to create a report in which i have grouped this data by Cardtype, Now the question is I want the difference between the amounts for the same card type. for Example :-
I want my report to look like following:

type1 R32-Balance 15000.70
type1 R16-Balance 12000.50
----- ----------- --------
Outbalance:- 3000.20

type2 R32-Balance 19450.60
type2 R16-Balance 18000.50
----- ----------- --------
Outbalance:- 1450.10

type3 R32-Balance 18550.80
type3 R16-Balance 12500.50
----- ----------- --------
Outbalance:- 6050.30


Thanks. Please Look into it

I'll did all I could, I am doing all I can and I will do all I can. Now, you better do all you can.