Skip to Content
0
Former Member
Dec 01, 2009 at 07:29 AM

Crystal report error

24 Views

Hi,

Customer is using 2007A SP01 PL07, crystal version 2.0.0.6 We are customizing a crystal report for customer. When refreshing the error message that "The remaining text does not appear to be part of formula" and it highlight the below syntax in Crystal formula.

else if GroupName ({ChartOfAcct.AcctCode}) ='Advertisement - Vacancy'

or GroupName ({ChartOfAcct.AcctCode}) = 'Bonus'

or GroupName ({ChartOfAcct.AcctCode}) = 'Dental - Fee'

or GroupName ({ChartOfAcct.AcctCode}) = 'EPF'

or GroupName ({ChartOfAcct.AcctCode}) = 'Incentives'

or GroupName ({ChartOfAcct.AcctCode}) = 'Medical Fee'

or GroupName ({ChartOfAcct.AcctCode}) = 'Meal Allowance'

or GroupName ({ChartOfAcct.AcctCode}) = 'Part Time Staffs'

or GroupName ({ChartOfAcct.AcctCode}) = 'Salaries'

or GroupName ({ChartOfAcct.AcctCode}) = 'SOCSO'

or GroupName ({ChartOfAcct.AcctCode}) = 'Staff Allowance'

or GroupName ({ChartOfAcct.AcctCode}) = 'Staff Handphone Charges'

or GroupName ({ChartOfAcct.AcctCode}) = 'Training Expenses'then

StaffCosts:=StaffCosts+Groupsum;

else if GroupName ({ChartOfAcct.AcctCode}) ='Staff Welfare' then

StaffWelfare:=StaffWelfare+Groupsum;

else if GroupName ({ChartOfAcct.AcctCode}) ='Accomodation'

or GroupName ({ChartOfAcct.AcctCode}) = 'Car Allowance'

or GroupName ({ChartOfAcct.AcctCode}) = 'Parking And Tolls'

or GroupName ({ChartOfAcct.AcctCode}) = 'Petrol'

or GroupName ({ChartOfAcct.AcctCode}) = 'Road Tax'

or GroupName ({ChartOfAcct.AcctCode}) = 'Travelling - Air Ticket'

or GroupName ({ChartOfAcct.AcctCode}) = 'Travelling - Mileage'

or GroupName ({ChartOfAcct.AcctCode}) = 'Travelling - Taxi Fare'

or GroupName ({ChartOfAcct.AcctCode}) = 'Upkeep Of Motor Vehicles'then

TravellingNAccomodation:=TravellingNAccomodation+Groupsum;

May I know how to troubleshoot?

Regards

Thomas

Edited by: Thomas Lai on Dec 1, 2009 8:34 AM