Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Report Formula

I have created a formula in Crystal Reports 2013 but I receive the error " boolean is required here" The purpose of the formula is to put the title of each work center next to the work center number. So this is my formula

IF GROUPNAME ({job_routing.work-ctr})= "1400" then "HEAT TREAT" OR

IF GROUPNAME ({job_routing.work-ctr})= "1410" then"OV PLATING-3DAY"

IF GROUPNAME ({job_routing.work-ctr})= "1415" then "OV GRIND" OR

IF GROUPNAME ({job_routing.work-ctr})= "1425" then"SANDBLAST-3DAY"

IF GROUPNAME ({job_routing.work-ctr})= "1450" then "OV WELD" OR

IF GROUPNAME ({job_routing.work-ctr})= "1455" then"OV MISC"

ELSE ""

The editor suggest a boolean be put where I have the red lettering. However i am not sure what boolean it wants because none of them seem like they belong at that point.

Tags:
replied

Hi Lenore,

Replace all the 'OR' with Else

-Abhilash

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question