Proper syntax for formula??

[Divinity2779]

Can someone help me with the proper syntax for what I want to do - I am kind of a newbie:

I need to SUPPRESS a field (in a subreport) IF:

'field2' is NOT NULL
AND
'parametervalue' (passed in from main report) ends in -CC or -CK

Right now in my Suppress conditional formula editor I have the following:

If not IsNull({BM2_BillMaterialsDetail.ComponentItemCode}) or
"*-CC" in {?Pm-SO2_SOEntryDetailLine.ItemNumber}
then true
else false

It works to suppress the field "if not null", but it is still showing the field even if the 'parametervalue' ends in -CC. (Yes, I realize this is not set up for -CK, but I didn't know how to do both).

Can someone help me with my syntax or understand why this is not completely working for me? I really appreciate any help you can provide!

 

[stormtrooper]

Remove the "if", "then" and "else" parts.

 

[kskid]

You almost have it

Right click on field and click on Suppress.

Click on x-2 next to suppress and add the following

IsNull({BM2_BillMaterialsDetail.ComponentItemCode}) or
{?Pm-SO2_SOEntryDetailLine.ItemNumber} in ["-CC","-CK"]


If the above statement is true then the field will remain suppressed. Otherwise, it will show

 

[Divinity2779]

Thanks guys! I got it to work - my first report is now complete!