Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Total from a Field in a Group Header? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Having a problem getting a report total from a field in a group header

    See attached demo, open report and enter 5/1/5 thru 5/31/5

    Fees total is 10,007.00 and is OK

    Est Cost is totaling 4,158,252, it should be 2,414,252

    I think it is picking up cost values from permits that have multiple lines, it should be just including cost just once on the break of permit number.

    Any solution to this?

    Thanks, John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Total from a Field in a Group Header? (a2k (9.0.6926) SP-3 Jet

    Put a text box in the strPermitNo group header.
    Set its Control Source to lngEstCost, and its Running Sum property to Over All (or Over Groups, that does not matter here).
    Set its Visible property to No, and name it for example txtRunningEstCost.

    Set the Control Source of the lngEstCost Grand Total Sum text box in the report footer to =[txtRunningEstCost]

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Total from a Field in a Group Header? (a2k (9.0.6926) SP-3 Jet

    That

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •