Print Page | Close Window

When is Insert Summary not available?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2652
Printed Date: 04 May 2024 at 8:17am


Topic: When is Insert Summary not available?
Posted By: sirlansa
Subject: When is Insert Summary not available?
Date Posted: 19 Mar 2008 at 1:17pm
[I'm using standalone Crystal Reports 2008, but didn't find another logical place to post this question]
 
Is Insert Summary not available under certain circumstances for formulas?
I'm trying to sum(@formula) but Insert doesn't even appear on the rt-click menu for the control. Some formulas have it but the ones I want DON'T! On the Insert Menu dropdown, Insert Summary only lists a few formulas in my report, again not the ones I'd like to sum.
 
The formulas I want to Summarize appear in the detail records and produce a numeric value. The only thing unusual is that the formula I can't sum uses other formulas in the calculation. Is there a restriction on summarizing nested formulae?


-------------
Sir Lansa


Replies:
Posted By: BrianBischof
Date Posted: 19 Mar 2008 at 4:05pm
This has to do with the 2-Pass Report Processing Model. Basically, all summaries are performed in the second pass and only in the second pass. Thus, you can't do a summary of a summary b/c CR won't know which one to do first. Summaries can only be based on data that is calculated in the first pass (raw data, simple formulas, etc.). If your formula has any type of summary calculation in it, or isn't a simple formula based on raw data, then you can't do a summary of it.

I discuss this in more detail on pages 47-50 or my book http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Crystal Reports Encyclopedia .

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window