Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Error: This field cannot be summarised Post Reply Post New Topic
Author Message
tcong
Newbie
Newbie
Avatar

Joined: 17 Jun 2009
Location: Malaysia
Online Status: Offline
Posts: 4
Quote tcong Replybullet Topic: Error: This field cannot be summarised
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
tcong
Newbie
Newbie
Avatar

Joined: 17 Jun 2009
Location: Malaysia
Online Status: Offline
Posts: 4
Quote tcong Replybullet 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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
tcong
Newbie
Newbie
Avatar

Joined: 17 Jun 2009
Location: Malaysia
Online Status: Offline
Posts: 4
Quote tcong Replybullet 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
IP IP Logged
tcong
Newbie
Newbie
Avatar

Joined: 17 Jun 2009
Location: Malaysia
Online Status: Offline
Posts: 4
Quote tcong Replybullet Posted: 18 Jun 2009 at 11:57pm
Hi lockwelle,

Yes. I manage to get the total now.
Thanks a lot.

TC Ong
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.