Connect with Expertise | Find Experts, Get Answers, Share Insights

How to get the value of the total summary of crosstab in crystal report?

lotus18's Avatar
C
 
Join Date: Nov 2007
Location: Zamboanga City, Philippines
Posts: 866
#1: Feb 9 '10
Hello World!

I got stuck with my program and I can't figure it out by myself. I have a problem in getting the total summary of my crosstab. Here's my sample report.



As you can see on my report, you will notice that I set the Section Footer (it is not visible here) to Suppress (No Drill Down). Here's my formula
Expand|Select|Wrap|Line Numbers
  1. if {creditmemo_list.CreditReturn}="Yes" then
  2.     true
  3. else
  4.     false
And it works fine. All I want is to get the value of total summary (Sum of @ii) of the crostab and subtract it to the value of #TotalBalance and the result would be the @GrandTotal. The formula of my @GrandTotal should be

Expand|Select|Wrap|Line Numbers
  1. {#TotalBalance} - {(Sum of @ii)} <-Actual value of this object
  2.  
Is this possible? If not, is there any alternative solution to my problem? Please help. This is urgent.

Rey Sean

lotus18's Avatar
C
 
Join Date: Nov 2007
Location: Zamboanga City, Philippines
Posts: 866
#2: Feb 11 '10

re: How to get the value of the total summary of crosstab in crystal report?


Hello I'm calling all experts of this community. Please post some reply here... I just want to know if there is another way to solve my problem. Thanks!

Still waiting for your replies :'(
Reply