Converting Access Formula to Crystal Reports

[rwn]

I have this Access formula that works fine and trying to convert this formula to use in Crystal Reports. Thanks in Advanced for any assistance.

rate: IIf([Job_Operation_Time]![Act_Run_Hrs]>0,GetEfficiency([Job_Operation]![Run_Method],[Job_Operation]![Run],[Job_Operation]![Efficiency_Pct],[Job_Operation_Time]![Act_Run_Qty],[Job_Operation_Time]![Act_Run_Hrs]),0)

 

[kray4660]

It appears you are calling a function, sub-rountine, etc. called GetEfficiency. To get that to work correctly you will have to re-create that routine in Crystal Reports. Of course all of your field names will be change to something like this {Job_Operation.Run_Method}, {Job_Operation.Run}, etc. provided you are using tables instead of a command. Then the if statement might look a little like this.

If({Job_Operation_Time.Act_Run_Hrs}>0 then
GetEfficiency({Job_Operation.Run_Method},{Job_Operation.Run},{Job_Operation.Efficiency_Pct},{Job_Operation_Time.Act_Run_Qty},{Job_Operation_Time.Act_Run_Hrs})
else 0)