Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Is it possible to create a sum by a custom formula Post Reply Post New Topic
Author Message
jpatracar
Newbie
Newbie


Joined: 25 Oct 2007
Location: Mexico
Online Status: Offline
Posts: 2
Quote jpatracar Replybullet Topic: Is it possible to create a sum by a custom formula
    Posted: 25 Oct 2007 at 2:21pm

Hello

As you all know, to make a simple summary in your report is by right clicking/Insert/Summary..

In my report I have 2 group fields...so in the  summary windows i change the summary location to where i want to set it up.

The calculation I want to do is a sum of one of my formulas, but i cannot see any of my formulas in the "Choose the field to summarize"

The formulas are empty but when i run my program i fill them up according to what the user needs..

Is there a way to set this up programatically? or just by making them appear in the summary windows?

***Creating a new formula where I do: Sum({@myfieldIwantToSum} works..but it acutally gives me the total of all the fields...I want to make that sum to where the group is placed.

IP IP Logged
jpatracar
Newbie
Newbie


Joined: 25 Oct 2007
Location: Mexico
Online Status: Offline
Posts: 2
Quote jpatracar Replybullet Posted: 25 Oct 2007 at 4:06pm
Oh I finally got it:
 
Sum ({WhatIWantToSumField}, {TheFieldWhereitsbeingplaced})
 
Clap
 
 
What I tried to do all this time was:
Sum ({WhatIWantToSumField}, GroupName {TheField})
 
but i kept getting an error, until I realized just by adding the name of the field of my groupname is based worked just fine!
Big%20smile
 
 
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.