Subtraction of subtotals in grandtotal CROSSTAB in crystal report [Resolved]

Posted by Teena under ASP.NET on 11/15/2011 | Points: 10 | Views : 3774 | Status : [Member] | Replies : 1
Hi,

I have a report on Crosstab in crystal report.
I had two columns Earnings and Deductions.
For Earnings and Deductions had sub column based on it .
There is Earning Subtotal and Deduction Subtotal.
There is column for grantotal in it shows summation of these subtotals
instead of that i need Earning Subtotal - Deduction Subtotal in grandtotal.


I had attached format of report in excel and my design page image.

Please help if u knows about this.

Regards
Teena




Responses

Posted by: Teena on: 11/15/2011 [Member] Starter | Points: 25

Up
0
Down

Resolved
Hi all,

I got answer for the above question. For deduction column value i put negative sysmbol infront of it in my stored procedure
and i remove that negative symbol in design using customizing that field.Then u will Earning - Deduction in GrandTotal.

Teena



Teena, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response