[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Shared Variable NumberVar not totaling in Footer

Posted on 2006-03-21
Medium Priority
Last Modified: 2012-06-27
I have the following setup in a Crystal Report v.10:

Group Header --  Feld Name: VacTotalH
shared numberVar VacTotal :=0;

Detail Section --  Field Name: VacAccrualManual
shared numberVar VacTotal;
VacTotal:= {@VacAccrualMonthly};

Group Footer -- Field Name: VacAccrualTotal
shared numberVar VacTotal;

The Group Header is fine.  The details section works fine.  The group footer is not totaling the values in the Details section.  I get the following:

Group Header field = 0

Group Details Record instance 1 = 10.17
Group Details Record instance 2 = 12.13

Group Footer field = 12.13  (This should be 22.30 - a total of 10.17 and 12.13)

HELP!!!  The need for this is extremely urgent and I have set it to 500 points.  I'm sure it will be pretty easy, but I need it bad!!
Question by:pmasseycpa
LVL 28

Accepted Solution

bdreed35 earned 2000 total points
ID: 16254086
Your VacAccrualManual formula should be this:

Detail Section --  Field Name: VacAccrualManual
shared numberVar VacTotal;
VacTotal:= VacTotal+{@VacAccrualMonthly};

You were resetting the formula each time rather than accumulating it.
LVL 101

Expert Comment

ID: 16254158
Looks like the answer.


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Screencast - Getting to Know the Pipeline

872 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