I am trying to add up school employees sick pay. They have Accumulated Sick pay (total 1) , used Sick pay (total 2) and sold Sick pay (total 3).

 

I want to put an if statement that says

 

if  (sick pay field type) = "A"

  then

    Total 1 = Total 1 + (sick pay hours field)

 

and if (sick pay field type) = "U"

   then

      Total 2 = Total 2 + (sick pay hours field)

 

and if (sick pay field type) = "S"

   then

     Total 3 = Total 3 + (sick pay hours field)

 

Then I want to be able to say

 

Grand Total = Total 1 - Total 2 - Total 3

 

Is that possible to do in Crystal reports?  I am getting errors at every turn

Cvail in Seattle

 

 

I assumed that ELSE meant INSTEAD OF.  So I see that you are saying that ELSEIF means  IN ADDITION TO.  Is that a command when you put the two words together ELSEIF   instead of ELSE IF?  I thought I had tried that (of the many things I tried) and was getting an error so I may have made a typo that I could not find.  That is what I was trying to do is find some command that  would be the same as saying AND ALSO  ..

 

Thanks for the tip.  I will go try it tomorrow...

 

 

Thanks for putting this Forum here.  It is a great releif to know that when I am totally stumped I can go somewhere for a tip or two.  Now to order the rest of your books....   Cordell

 

You are right.  I had already tried the ELSE IF but as you say, I need to do all three every time as I go down name by name reading each record in the history file to see how much Sick time they have accumulated, used and also sold.  The trouble I am having is that all of the transactions are in the same record.  So I have to use a formula to say if they are type A, U or S so  then  and I cant do a Running total on a Formula field

 

here is the original formula I wrote to try to put them all in one

 

I put this formula in the detail section and supressed the section so it does not print

 

fmSickAccumulate

 

This is what was in that formula

whileprintingrecords;

global numbervar SickTrans;

if {HTOTRN_TRANS.HTODGR-GRP-CODE}='1'

and {HTOTRN_TRANS.HTOTRN-LTD-RECORD} = "N"

and {HTOTRN_TRANS.HTOTRN-TYPE}="A"

and {HTOTRN_TRANS.HPAHDM-ID} <> 0 then

SickTrans := SickTrans + {HTOTRN_TRANS.HTOTRN-HRS}

else

and {HTOTRN_TRANS.HTOTRN-LTD-RECORD} = "N" and

{HTOTRN_TRANS.HTOTRN-TYPE}="u" then

SickTrans := SickTrans - {HTOTRN_TRANS.HTOTRN-HRS}

and   (I also tried ELSE here)

and {HTOTRN_TRANS.HTOTRN-LTD-RECORD} = "N" and

{HTOTRN_TRANS.HTOTRN-TYPE}="s" then

SickTrans := SickTrans - {HTOTRN_TRANS.HTOTRN-HRS};

 

And I put this formula field in the Footer for Group 1 to actually print on the report

fmSickPrint

 

This is what was in that formula

 

mfSickReset

 

This is what was in that formula

whileprintingrecords;

global numbervar SickTrans := 0

 

 

But it does not reset or add up right as it goes down the records. 

 

It would be so easy in Excel but of course when you are working with a database and have to have selection parameters for date ranges and formulas for limiting the types it gets complex. 

 

It is so amazing that you guys would be willing to take the time to try to help me.  If and when I get this Crystal Reports thing learned, I assure you I will be in here with you helping others....

 

Cordell