I searched around and found this as the most related, but it was too different from my case (as far as I could see) to make it work:
http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=13090&KW=running+total+header

I have several running total fields.  They are working fine, and I am aware that they work based on counting records and then being displayed at the bottom of the report.

Is there a way to take them and display them at the top?  Right now I have six running totals, and two of each are added together, to leave three formula fields:
(Total 1) = {RTotal0}+{RTotal1}
(Total 2) = {RTotal2}+{RTotal3}
(Total 3) = {RTotal4}+{RTotal5}

Any help is much appreciated.

If I need a running total, how do I summarize a formula?  Looking at the past topic, I tried to create a summary but I could only summarize fields, not any of my formulas.

I think I generally get what you are saying.  One of my running totals does use the previous or next function, so I probably can't do it.  I will mess around with it though and see if I can get the numbers I want with summary instead.  Thank you for the help again.

My data is based on (Host) and (Guest).  It is displayed like so:

Group: (Host.Name)  (Registration.Status)
       Details: (Guest.Name)  (Registration.Status)

I am counting up "Registration.Status" for both Hosts and Guests, which have three options: "Not Registered", "Registered", "Do Not Register".

This is how I have found I have to count:

Group: (Host.Name)  (Registration.Status)
       Details: (Guest.Name)  (Registration.Status)
                    (Host.Name)   (Registration.Status) - (BOTH HIDDEN, HERE FOR COUNT)

Report Footer: Rtotal0: Count
                                      Evaluate: Guest.Registrat.Status = "Registered"
                                      Reset: Never
                        Rtotal1: Count
                                      Evaluate: Next ({HostID})<>{HostID}
                                      and Host.Registration.Status = "Registered"
                                      Reset: Never
                        Formula: {@Rtotal0}+{@Rtotal1}

      Displayed: "Total Registered: {Formula}"


I hide the running totals in the footer and just display total registered.  I do this for each of the three "Registration" options.

As you can see, I put the group name in the details so that I can running total it.  Not sure if that is problematic but it works.

Thanks for any help.


Edited by JFinzel - 21 Sep 2011 at 10:02am

I am not seeing any immediate 'simple' way to get the data into a group header.