• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1119
  • Last Modified:

SubTotal in Group footer section Crystal Reports

Hello Experts,

I have a crystal report 11i in VS2005 IDE.Where I'm grouping a report on Dept.,created  two formula fields , which does cost and tax.

I need total of this @Cost + @tax formula fields in @SubTotal.
 @SubTotal = @Cost + @tax

And also need to reset the values once the group is done.I get @cost & @tax values from running Total variables.But I'm stuck at @Subtotal and GrandTotal.

Once I get SubTotal ,finally  I need to do GrandTotal(Which is Subtotals of all the Dept groups).
0
ASPDEV
Asked:
ASPDEV
  • 2
1 Solution
 
ASPDEVAuthor Commented:
Experts,

I can able to get @Subtotal, solution is simple. In formula field.
 SUM({Test.Cost},{Test.Dept}) + SUM({Test.TAX},{Test.Dept})


Now, I need  @GrandTotal
0
 
mlmccCommented:
Grand total - Just remove the group from the subtotals

    SUM({Test.Cost}) + SUM({Test.TAX})

mlmcc
0
 
ASPDEVAuthor Commented:
Thanks.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now