Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Summary/running total field could not be created Post Reply Post New Topic
Author Message
ororo
Newbie
Newbie
Avatar

Joined: 16 Jul 2012
Location: Italy
Online Status: Offline
Posts: 3
Quote ororo Replybullet Topic: Summary/running total field could not be created
     Posted: 16 Jul 2012 at 11:10pm
I have a basic problem on the use of Sum. Confused

The table RPT_CERTCOL_CAR is in relation 1:n with the table RPT_CERTCOL_MIS.

There is a group on the field {RPT_CERTCOL_CAR.SEQUENZA_CAR}.

In the *header* of this group, I need to write the sum of a function:
{RPT_CERTCOL_MIS.VALORE_RILEVATO}+{RPT_CERTCOL_MIS.VALORE_RILEVATO2}

of course, referred to the rows of that group only.

I try to write a formula with this:

Sum({RPT_CERTCOL_MIS.VALORE_RILEVATO}+{RPT_CERTCOL_MIS.VALORE_RILEVATO2},{RPT_CERTCOL_CAR.SEQUENZA_CAR})

but the answer is: "The summary / running total field could not be created."

What is wrong? Thank you very much.

Using C.R. 8.5.

IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Posted: 16 Jul 2012 at 11:18pm
Sum({RPT_CERTCOL_MIS.VALORE_RILEVATO},{RPT_CERTCOL_CAR.SEQUENZA_CAR})+
SUM({RPT_CERTCOL_MIS.VALORE_RILEVATO2},{RPT_CERTCOL_CAR.SEQUENZA_CAR})

or

create a formula with {RPT_CERTCOL_MIS.VALORE_RILEVATO}+{RPT_CERTCOL_MIS.VALORE_RILEVATO2}

Then use the built in function to sum (right mouse click on field, select insert summary)
IP IP Logged
ororo
Newbie
Newbie
Avatar

Joined: 16 Jul 2012
Location: Italy
Online Status: Offline
Posts: 3
Quote ororo Replybullet Posted: 16 Jul 2012 at 11:28pm
Thank you!
IP IP Logged
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