Solved

Report footer total

Posted on 2014-09-23
1
248 Views
Last Modified: 2014-10-08
I have atatched the sample report.In the report footer which displays the total,how can I get the difference of the summarized data from the report footer.
For example to show total in the reportfooter under variance column,how can I get the variance to be 20003.34-21892.03 =- 1888.69 instead of getting the summarized value in the report footer.
Thanks All.
u-ctest.rpt
0
Comment
Question by:Star79
1 Comment
 
LVL 34

Accepted Solution

by:
James0628 earned 500 total points
Comment Utility
In your subreport, enter the following in a formula (like your totalvar formula):

Sum ({@perdiem}) - Sum ({@u&c})

 If you look at the list of "Report Fields" while you're in the formula editor, you can see the summaries on the report.  The "Report Area" summaries are the grand totals (the summaries I used above).  The group summaries are listed too, with the group number and field, so you know which group they're for (assuming that you have more than one group).

 James
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now