Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Creating a summary on a formular field Post Reply Post New Topic
Author Message
Despina
Newbie
Newbie


Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
Quote Despina Replybullet Topic: Creating a summary on a formular field
    Posted: 07 Oct 2010 at 4:44pm

Have created a formula field which assigns a conversion to certain values.  IS there any way I can create a summary of the formula field?

 

When I select Insert Summary I am unable to see my formula in the selection window

IP IP Logged
venky_115
Groupie
Groupie
Avatar

Joined: 15 Jun 2010
Location: United States
Online Status: Offline
Posts: 67
Quote venky_115 Replybullet Posted: 07 Oct 2010 at 8:49pm
We can not insert a summary of the formuale but we can get the summary using varibale, declare a variable and sum the values while printing the records and dispaly the variable where ever you want
 
 
Regards
Venky
Regards
IP IP Logged
Despina
Newbie
Newbie


Joined: 30 Mar 2010
Location: Australia
Online Status: Offline
Posts: 31
Quote Despina Replybullet Posted: 11 Oct 2010 at 1:26pm

Thanks for the update Venky,

I tried to create a var, and sum the values using the following formula:

 

 

whileprintingrecords;
shared NumberVar RTotal;


If {Command.SUM(WRKD_MINUTES)}= 1 and {Command.UNIT} > '0:00'  Then
RTotal :=
    ToNumber ({Command.UNIT})


else If {@Grouping_5}='Casual Loading 22.5%' Then
RTotal :=
    SUM ({@OA_Wrk}, ({Command.EMPLOYEE_HISTNAME}))-SUM ({@OA_PS},({Command.EMPLOYEE_HISTNAME}))


ELSE
RTotal :=
  {Command.SUM(WRKD_MINUTES)};

 

I then called the value by:

 

whileprintingrecords;
shared numbervar RTotal;

 

The problem is that I still need to group by the description of the codes returned and display the summed value that relates to the description

 

 

Any help would be greatly appreciated

 

Regards,

Despina

 

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.033 seconds.