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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lotus18
    Contributor
    • Nov 2007
    • 865

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

    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
    Code:
    if {creditmemo_list.CreditReturn}="Yes" then
        true
    else
        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

    Code:
    {#TotalBalance} - {(Sum of @ii)} <-Actual value of this object
    Is this possible? If not, is there any alternative solution to my problem? Please help. This is urgent.

    Rey Sean
  • lotus18
    Contributor
    • Nov 2007
    • 865

    #2
    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 :'(

    Comment

    Working...