Print Page | Close Window

Error: This field cannot be summarised

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=6766
Printed Date: 26 Apr 2024 at 10:05pm


Topic: Error: This field cannot be summarised
Posted By: tcong
Subject: Error: This field cannot be summarised
Date Posted: 17 Jun 2009 at 9:17pm
Hi

I am using Crystal Report Xi. I have completed a report called Stock Aging.
It can be downloaded from here... http://www.4shared.com/file/112567589/6d3f0909/StockAgingTC.html

I am having the problem of how to create a summary by PartClass ID for the detail field 1-90days, 91-180days, etc.

Any advice or ideas is much appreciated.

Thank you....TC Ong


-------------
Thanks a lot.

TC Ong


Replies:
Posted By: lockwelle
Date Posted: 18 Jun 2009 at 6:56am
haven't looked at the report, but if there is a formula, you can't use aggregates, you will need to create your own aggregates using shared variables and formulas.
 
HTH

Posted By: tcong
Date Posted: 18 Jun 2009 at 7:10am
Yes. It is a formula, HTH.

Could you give me some idea or sample on how to do it? Appreciate all your assistance as I have no clue.

Thanks..TC


-------------
Thanks a lot.

TC Ong

Posted By: lockwelle
Date Posted: 18 Jun 2009 at 10:09am
depends on how the report is being done, but here a general outline of how to do it.
 
In the start of the group you want a formula that will set you variables =0
in the detail section, a formula that will increment the variables accordingly, and in the report footer, you can now access the variable and do any math that you need or you can display.
 
Sample formulas
 
in a group header
shared numbervar aVar := 0;
"" //suppresses the display of the 0
 
in a group footer
shared numbervar aVar
 
in a detail
shared numbervar aVar;
 
if {table.field} = someValue then
 aVar := aVar + incrementAmount;
 
""//hide the results of the formula
 
HTH

Posted By: tcong
Date Posted: 18 Jun 2009 at 7:42pm
Hi HTH,

Thanks for your prompt respond. I appreciate it.

So, I will need to create a formula with the variables like you stated in the group header and the group footer to be able to achieve the summary.

I will try it out.

Thanks again....TC


-------------
Thanks a lot.

TC Ong

Posted By: tcong
Date Posted: 18 Jun 2009 at 11:57pm
Hi lockwelle,

Yes. I manage to get the total now.


-------------
Thanks a lot.

TC Ong


Print Page | Close Window