Solved

Summarize Formula field in group footer

Posted on 2010-09-13
3
503 Views
Last Modified: 2012-05-10
I have a formula on the detail section of a report and need to total it in the group section.  When I try to summarize it I get a message indicating "This field can not be summarized"
0
Comment
Question by:tthayer
3 Comments
 
LVL 8

Accepted Solution

by:
kingjely earned 350 total points
ID: 33661741
Hi Tthayer

You may need something like the following,

In the group header add a formula
WhilePrintingRecords;
Global NumberVar MyTotal := 0;
''

In the section where you display the summary
WhilePrintingRecords;
Global NumberVar MyTotal;
MyTotal := MyTotal + {summaryFormula OR formular);
''

To display in Group footer
WhilePrintingRecords;
Global NumberVar MyTotal;
MyTotal



0
 

Assisted Solution

by:CarloVasquez
CarloVasquez earned 150 total points
ID: 33683514
kingjely, it seems like you are going in the right direction here but the problem I see in this code is in this section:

In the section where you display the summary
WhilePrintingRecords;
Global NumberVar MyTotal;
MyTotal := MyTotal + {summaryFormula OR formular); <----- HERE
''

SummaryFormula or Formular that you mention does not exist as a field or you can not use it.
It's unavailable. I have tried also doing the same thing as tthayer but same problem.

I am guessing that possibly by creating a formula field NOT a summarize field cause it work either.
Let me know what else you can think of.

//Carlo
0
 
LVL 3

Author Closing Comment

by:tthayer
ID: 33846229
Sorry experts.  Totally forgot I had this one out here.  
I will deffinately be able to use your suggestions.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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 …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

25 Experts available now in Live!

Get 1:1 Help Now