Using A Parameter Field To Suppress A Group Header

[Former Member]

Hi Experts,

Is it possible to use the value of a Parameter Field i.e. "Show Group Header" to suppress or un-suppress a Group Header section, depending on the boolean value of said Parameter Field?

For Example:

Show Header: True > Doesn't suppress the header

Show Header: False > Does suppress the header

(Everytime you refreshed the data, it would give you the option to change the boolean value, like any other Parameter Field).

How would you do this?

Thanks,

Gareth

[abhilash_kumar]

Hi Gareth,

1. Setup a parameter with the type 'Booleanvar'.

2. Go to the Section Expert > Highlight Group Header > Click the formula button beside Suppress and use this code:

Not({?PromptName})

-Abhilash

[Former Member]

Hi Abhilash,

I'll need to test this in a couple of different environments than mine own, but this should work nicely.

Thank you for your reply.

Kindest Regards,

Gareth

[Former Member]

Hi Abhilash,

I am trying to suppress the "CHECKBOXGROUP_4_Supress_Frame_Materials" Group Header.

I've inserted the statement "Not({?CHECKBOXGROUP_4_Supress_Frame_Materials})" below.

However, I am getting the error [A statement was expected here] on the Not({?CHECKBOXGROUP_4_Supress_Frame_Materials}) line of code.

Any ideas?

If {?CHECKBOXGROUP_1_SUMMARY} = True Then
    formula = True
    Else
        If {QuoteAssemblies.qmaQuoteAssemblyID} = 0 Then
            formula = True
            Else
                If {?CHECKBOXGROUP_3_Suppress_Fabric_Materials} = True and {QuoteAssemblies.qmaPartID} = "FABRIC" Then
                    formula = True
                    Else
                         If {?CHECKBOXGROUP_4_Suppress_Frame_Materials} = True and ({QuoteAssemblies.qmaPartID} = "FRAME" or {QuoteAssemblies.UQMACOMPONENTCLASSID} = "FRAME" or {QuoteAssemblies.UQMACOMPONENTCLASSID} = "TIMBER") Then
                            formula = True
                            Error here >>>> Not({?CHECKBOXGROUP_4_Suppress_Frame_Materials})
                            Else
                                If {?CHECKBOXGROUP_5_Suppress_Leather_Materials} = True and {QuoteAssemblies.qmaPartID} = "LEATHER" Then
                                    formula = True
                            Else
                            formula = False
                            End If
                    End If
            End If
End If
End If
<br>

Regards,

Gareth

[Former Member]

Bump......