Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SubTotal  in Group footer section Crystal Reports

Posted on 2011-03-17
3
1,024 Views
Last Modified: 2012-06-27
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
Comment
Question by:ASPDEV
  • 2
3 Comments
 

Author Comment

by:ASPDEV
ID: 35158329
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 35158986
Grand total - Just remove the group from the subtotals

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

mlmcc
0
 

Author Closing Comment

by:ASPDEV
ID: 35181607
Thanks.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question