Crystal Reports Select Expert - Saved Data-

Message

   This is the formula:

StringVar OrderTaken;

if PreviousIsNull({JobOrder.JobOrderNo}) or {JobOrder.JobOrderNo} <> Previous({JobOrder.JobOrderNo}) then 

  OrderTaken := 'No';

if InStr(UpperCase({JobComments.Description}), 'ORDER TAKEN') > 0 then 

  OrderTaken := 'Yes';

OrderTaken

I created this in Formula Fields in Field Explorer and then dragged the Field into the Group Footer #1 with the other data.

Below is a cross section of some of the data that the report produces

OwnerStaffID     JobOrderNo          OfficeCode     OfficeCode     JobStatus     OrdJobType     OrderTaken     

DEBBIE          200,035,658          200          200          Closed          Firm Order          

AARON          200,035,953          200          200          Closed          Extended          

KATH          200,035,990          100          100          Filled          Extended          

PEOPLE          200,036,025          200          300          Filled          Firm Order          

JAMESM          200,036,085          100          100          Closed          Extended          

CHRISTI          200,036,132          200          200          F-Competitor     Firm Order          

ELIZA          200,036,294          100          100          Cancelled     Firm Order          No

JAMESM          200,036,321          100          100          Closed          Extended          No

CHRISTI          200,036,358          200          200          Filled          Firm Order          No

CHRISTI          200,036,376          200          200          F-Competitor     Firm Order          No

KYML          200,036,560          200          200          Closed          Firm Order          No

JAMESM          200,037,774          100          100          Filled          Payrolled          Yes

JAMESM          200,037,775          100          100          Filled          Payrolled          Yes

JAMESM          200,037,776          100          100          Filled          Payrolled          Yes

JAMESM          200,037,777          100          100          Filled          Payrolled          Yes

SALLY          200,037,779          200          300          Submitted     Firm Order          Yes

JAMESM          200,037,780          100          100          Closed          Contingent          No