Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

running totals - grand total How t

Status
Not open for further replies.

kalpsv

Programmer
Jun 12, 2002
58
IN
running totals - grand total
How to get grand total after creating a running total
formula?
i have created a running total formula
with a field called subscpriton.
this field is grouped statewise
and gives the data correctly for each state.
but i am held up with a small
problem
i want a grand total for this running
total i.e. total for all the states.
when i try grand total it says
"this field cannot be summarised"
thank you in advance
sorry for the disturbance
bye
kalps





 
Crystal can't summarize summaries.

Create the Grand total as another Running Total using the same exact field you used in your Grouped Running Total. Just change to Reset level from Group to Never.

The only other alternative is to create a variable and accumulate the Group values in the Group footers...

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top