Suppress Section Expert Groups

[rwn]

I'm using this formula to suppress a section on a report.

if {?Show Inventory Shortages Only} = "YES" then ({@InvShortBOM1}> 0)
OR {PartMaster_BOM_1_Comp.ISC} <> {?ISC's to Show}

However, it only functions to "if {?Show Inventory Shortages Only} = "YES" then ({@InvShortBOM1}> 0)
" and not to this "OR {PartMaster_BOM_1_Comp.ISC} <> {?ISC's to Show}".

So it appears it does not function with the OR, I do need it to SUPPRESS if the first statement is YES or if the Second statement is <> to a selected Parameter value.

 

[fisheromacse]

i believe "then ({@InvShortBOM1}> 0)" is not the correct syntax for a suppression formula. you are assigning a value to {@InvShortBOM1} which doesn't make sense in a suppression formula.

 

[lbass]

I think it is an issue of parens:

(
if {?Show Inventory Shortages Only} = "YES" then
{@InvShortBOM1}> 0
) OR
{PartMaster_BOM_1_Comp.ISC} <> {?ISC's to Show}

I would write it:

(
{?Show Inventory Shortages Only} = "YES" and
{@InvShortBOM1}> 0
) or
{PartMaster_BOM_1_Comp.ISC} <> {?ISC's to Show}

Either approach should work.

-LB