Supress Group Header w/supressed records present

[diane55]

thread767-1068492

I need to inquire more on the response posted in the thread noted above by lbass.

What if I want to supress the group header and there are records in the group they are just supressed?

Crystal X

Any thoughts D
Thanks!

 

[lbass]

What are the criteria you are using to suppress the detail records? Let's say your suppression criterion was:

{table.field} = 'A'

Then you could create a formula {@notsuppressed} like this:

if {table.field} <> 'A' then 1

Then suppress the group header with this:

sum({@notsuppresssed},{table.groupfield}) = 0

There might be a simpler way, but we'd have to know your suppression criteria.

-LB

 

[diane55]

({@FetchID} <> {OfcrCmd.SUP_ID}

The above is the criteria for supression.
The fetch formula is based on the maxvalue largest_id of the record - returns the id thru a subreport. The compare is then to the coulmn in the suptable on the ids.
If not equal the record is supressed. When the record is supressed the Group Header needs to supress also.

Hope that helps to clarify.
D

 

[lbass]

where is the subreport located? It would have to be in a section above the one you want to suppress. Please also show the content of {@FetchID}.

-LB