Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Cr2008 fail to SUM values Post Reply Post New Topic
Author Message
AlexDias
Newbie
Newbie


Joined: 25 Aug 2011
Online Status: Offline
Posts: 2
Quote AlexDias Replybullet Topic: Cr2008 fail to SUM values
    Posted: 25 Aug 2011 at 9:31pm
hello, i came across some odd issue which is, not being able to SUM some fields.

The idea is to SUM fields and display them in some header, for some it seems to be working but that's not happening for all the fields i need.

Does anyone ever came across this problem before?

For instance, the
{@CabSomaCred1Dig}
WhilePrintingRecords;
Sum ({@_SaldoDeb}, {@PrimDigitoConta})

This formula is working fine, but not the others, {@CabSomaDebAnt} and {@CabSomaCredAnt}

I'm out of ideas by now...Did try to convert all the vars and formulas used to number and still no luck. I always keep getting the same error: {@_SldDebAnt}/{@_SldCredAnt} can't be sumarized.

Is there any other way to display groups footer displayed data in the header?
Most of the group footers have special formulas to make several calcs, though i can not change them to one or more summarized fields.

Thanks in advance
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 26 Aug 2011 at 4:15am

what type of fields are they in crystal?

you may have to create a formula
tonumber({@_SldDebAnt})
and use the formula in the summary
sharona
IP IP Logged
AlexDias
Newbie
Newbie


Joined: 25 Aug 2011
Online Status: Offline
Posts: 2
Quote AlexDias Replybullet Posted: 26 Aug 2011 at 4:46am
Those fields are calculated on runtime using formulas that increase or decrease the value of other formulas. Did try the ToNumber() and still can't summarize field.
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.047 seconds.