I happen to have a field being reported called: TYPE. I dragged it onto the report - it works fine. I added to a filter. That works fine and th ereport runs. I just tried adding another filter, I clicked WhereIf then Assist and get a message: 'The expression is not supported by the expression builder'. I am pretty sure it does not like the TYPE in the filter. I tried changing it to: [TYPE]...no dice. Any idea how I should be qualifyig on this field.

Here is some code focus has generated; I think tha very tail end is the problem...Like I said..the report runs...but I suspect when I tried to add a new filter, some sort of compiler ot something is internally not likeing how: TYPE is appearing.

WHERE ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.GROUP EQ &GROUP.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.GROUP,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.GROUP IN tbltemp_budgactualdetails)).GROUP. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.FISCALYEAR EQ &FISCALYEAR.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.FISCALYEAR,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.FISCALYEAR IN tbltemp_budgactualdetails)).FISCALYEAR. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.IDXSPECIALTY EQ &IDXSPECIALTY.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.IDXSPECIALTY,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.IDXSPECIALTY IN tbltemp_budgactualdetails)).IDXSPECIALTY. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.RPTBANBR EQ &RPTBANBR.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.RPTBANBR,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.RPTBANBR IN tbltemp_budgactualdetails)).RPTBANBR. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.LOCATIONNM EQ &LOCATIONNM.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.LOCATIONNM,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.LOCATIONNM IN tbltemp_budgactualdetails)).LOCATIONNM. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.CPT_CODE EQ &CPT_CODE.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.CPT_CODE,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.CPT_CODE IN tbltemp_budgactualdetails)).CPT_CODE. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.ORIGFSCCAT EQ &ORIGFSCCAT.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.ORIGFSCCAT,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.ORIGFSCCAT IN tbltemp_budgactualdetails)).ORIGFSCCAT. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.ORIGFSCNM EQ &ORIGFSCNM.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.ORIGFSCNM,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.ORIGFSCNM IN tbltemp_budgactualdetails)).ORIGFSCNM. ) AND ( TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.TYPE EQ &TYPE.(OR(FIND TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.TYPE,TBLTEMP_BUDGACTUALDETAILS.TBLTEMP_BUDGACTUALDETAILS.TYPE IN tbltemp_budgactualdetails)).TYPE. );

One suggestion is to DEFINE a new field with a different name and assign it to this TYPE field. Then use the DEFINE field instead.

Not sure how it would fit in with your code, but quotes around the field may help. You may be able to do this in the master file.

I tried brackets, single quotes and double quotes. I do not want to change the master file since other things may already be linked to it. Can you give me an example of the define and where I would stick it...I hate to deviate from the GUI but I need to get this working....