Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Crystal and totalling a field Post Reply Post New Topic
Author Message
nickyaussy
Newbie
Newbie
Avatar

Joined: 05 Oct 2007
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote nickyaussy Replybullet Topic: Crystal and totalling a field
    Posted: 05 Oct 2007 at 10:06am
I am wanting to total the number of records which appear under a certain condition  I have tried many different ways of doing this all mostly ending in the error you cannot summarize this field ..or a run time formula.. how do you make it a non run time formula?.
Ive tried running total .. everything..
thanks
I love crystal reports!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 05 Oct 2007 at 10:48am
I'm not sure where you are getting this error about not summarizing a field. I would create a formula and within it have a global variable. Put the formula in the Details section and have it increment when the condition is met. Then in the report footer (or wherever you want it), display the result of the formula. I've done this countless times, so maybe your circumstance is a bit unique? If so, please clarify a bit. It sounds like you already know CR well enough, so maybe this is something unique about your report?
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>
IP IP Logged
nickyaussy
Newbie
Newbie
Avatar

Joined: 05 Oct 2007
Location: United Kingdom
Online Status: Offline
Posts: 2
Quote nickyaussy Replybullet Posted: 08 Oct 2007 at 3:41am
That sort of helped.. (I can now do globals!)
but i calculated in header 4 ... and want to show result in header 1..
it doesnt seem to reach header 1.. dont know quite what to do..!
I love crystal reports!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Oct 2007 at 8:30am
CR performs calculations by their print order. So if you are doing a calculation in Section C and you are printing it in Section A, then it will be shown as zero in Section A. You can only display it in Section C or any section following it. What some people do to get around this is to create a subreport that just does that calculation (putting into a Shared variable) and putting that subreport in the report header. This makes the calculation available anywhere on the report (I talk about handling these 'hidden' calculations in Tutorial 9-6 of my new book).
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>
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.