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


Cannot do "insert summary" on a formula field.

Posted on 2005-04-09
Medium Priority
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)?

problem formula:
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
Question by:spoowiz
  • 2
LVL 101

Accepted Solution

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

This will explain the multipass method used by CR

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.

LVL 101

Expert Comment

ID: 13746022
Glad i could help


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