Search results for query: *

Ken, Whoops, didn't know you meant on Evaluate. That did it!!!! You are truly a Crystal guru -- I am forever in your debt! I am doing the dance of joy in your honor. THANK YOU!!!!!!!!!!!!!!!!!!!

It doesn't. :o( Is there a formula that I could use under Reset that would reset on the change of the appropriate group AND Not OnLastRecord? Am I grasping at straws?

Ken, I tried it on change of field and it messed up the other running totals in the report. Any other ideas? Thanks for the formula!

Are you on Crystal 7 or higher? Have you tried under File, Options, Reporting tab -- clicking Convert Null field value to default?

emallon, For Evaluate I am using Use a formula and the formulas I am using are the ones I've provided above. (FYI, I have many duplicate records and that's why the Next()<> formula.) Reset is set to On Change of group. Maybe I should Use a formula on Reset, like Not OnLastRecord. But how...

kenhamady, Do you mean my Running Total Condition formula? It is: Next({tblTemp.ResumeKey}) <> {tblTemp.ResumeKey} tblTemp.ResumeKey is the unique identifier for each applicant record. I was attempting to write a formula that would start something like this: If Not OnLastRecord then...

Yes, emallon , it is in a group footer.

Hi there, I am using Crystal Reports 7.0. I have created a bunch of running total formulas to calculate the race and sex information on an applicant report for my employer. The problem is that the last total in the report equals zero even though there is one applicant in that group. All of...