Shared Variable NumberVar not totaling in Footer

Posted on 2006-03-21
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

    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 100

    Expert Comment

    Looks like the answer.


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    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 …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    754 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

    17 Experts available now in Live!

    Get 1:1 Help Now