Suppress Help needed 1

[Tech2377]

This one I thought was easy and self explanatory however I cant seem to get this to go.

In my report, I have a GroupBy ({aaVisitStatus;1.GroupBy1}).

I want to suppress a specific group header and a group footer when this field = '(none)'

So I inserted the following suppress statement on both of these:

{aaVisitStatus;1.GroupBy1} = '(none)'

I am still getting both the header and footer.

 

[lbass]

If you place the field {aaVisitStatus;1.GroupBy1} in the detail section, how does it display when null or empty?

I would suspect that it doesn't display as "(none)" or "'(none)'". Try this suppression formula:

isnull({aaVisitStatus;1.GroupBy1}) or
trim({aaVisitStatus;1.GroupBy1}) = ""

If the group sections are entirely blank, you should also be also to just use "suppress blank section" in the section expert.

-LB

 

[Tech2377]

lbass:

This one is turning out to be more tricky then what I thought.

In my Group Header, I originally had the following:

({?SHOWDETAIL} = False and 
({?SHOWINSBALANCE} = False and {?LASTFILED} = False)

In my Group Footer, I originally had the following:

{?SHOWDETAIL} = True OR {?SHOWINSBALANCE} = True OR {?LASTFILED} = True

I want to take your coding as it works well, however I need to incorporate what was in there as well. I tried using an OR and dropping in what you gave me, but I think its not evaluating it right.

 

[lbass]

If your formulas using the parameters worked well before, then just do add them like this:

//Group Header:
(
isnull({aaVisitStatus;1.GroupBy1}) or
trim({aaVisitStatus;1.GroupBy1}) = ""
) or
(
{?SHOWDETAIL} = False and
{?SHOWINSBALANCE} = False and
{?LASTFILED} = False)
)

//Group Footer:

isnull({aaVisitStatus;1.GroupBy1}) or
trim({aaVisitStatus;1.GroupBy1}) = "" or
{?SHOWDETAIL} = True OR
{?SHOWINSBALANCE} = True OR
{?LASTFILED} = True

-LB