[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Cannot do "insert summary" on a formula field.

Posted on 2005-04-09
2
Medium Priority
?
388 Views
Last Modified: 2012-06-27
I have this formula which is in the detail. Values of either 0 or 1 displays correctly.
However, when I right-click on it, it does not show "insert summary" option.
Does this have to do with "evaluateafter" or using global variable?
How can a do a summary (count of)?
thanks

problem formula:
-----------------------------
WhilePrintingRecords;
EvaluateAfter({@G});
global stringvar YM1;
global stringvar LYM;
if YM1 = LYM then 1 else 0;

A simple formula, such as, has no problem showing the "insert summary" option.
----------------------------
if {listing.Status} = 'p' then 1 else 0
0
Comment
Question by:spoowiz
  • 2
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 13745855
Summaries are actually done before printing the records.

This will explain the multipass method used by CR
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_evaluationtimes.pdf.asp

When is {@G} evaluated?  If it is also whileprintingrecords then there is probablyno ay to use the summary.

You could use a running total instead of the summary.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 13746022
Glad i could help

mlmcc
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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 …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

867 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