Suppress group header depending on field in detail section

[Former Member]

I would like to suppress a group header depending on the content of a field in the report. I used section expert Suppress and put in the following formula but it doesn't work.

{Command.Action} = "ERAT" or
{Command.Action} = "ENRAT"

[Former Member · Accepted solution]

Hi,

Use like below.

if ({Command.Action} = "ERAT" or {Command.Action} = "ENRAT")

then true

else

false

Hope this helps.

Thanks,

Madhuri

[Former Member · Accepted solution]

Thanks that produces no errors but the Group header still does not suppress. I also tried placing your formula in the Format Field dialog as well - still no go. barry

[Former Member · Accepted solution]

Hi Barry,

Is there any field available in group header section? If field does not exists then you right click on the group header section and check hide.

Thanks,

Mahduri

[Former Member]

re-marking fairly

[Former Member]

Hi

Pleas put this condition in Supress of GROUP HEader

TRIM(UCASE()= VALUE1 OR TRIM(UCASE()) = VALUE2

Regards,

Sathish

[Former Member]

Thanks for all the suggestions everyone. SS243's post prompted me to revisit the solution from B Madhuri. Bingo! What didn't work yesterday is now working although I'd say I put the same code in the same way! Thanks again.

[Former Member]

Hi try this :

Go to Section Expert and select the GroupHeader on the right hand side you will find a tab called as 'Common' in there you will find Supress(No Drill-Down) now select the formulae(X+2) button of this Supress and place this statment in there

if ({Command.Action} = "ERAT" or {Command.Action} = "ENRAT")

Hope this should solve your issue.