Do not display both sections of group header in a report

[microjude]

Hello,

Hopefully this is not too novice a question for everyone, but it has me
stumped. How do I not make visible the first section of a group header in a
report while keeping the other section of the group header visible?

Right now I have a report that has delivered (value =1) vs non-delivered
(value=0) patients seen. All the patients must be listed in the report and
sorted by non delivered first and deliveries listed last. The report is
grouped by delivery status. I want to offset the two groups so I thought a
group header would be best. I can do that but I can't create 1 group header
for both groups. So right now my group header reads DELIVERED PATIENTS.
Unfortunaly that is the header for the non-delivered patients in the
beginning (value=0) as well. I really only want a header for the delivered
patients at the end.

How can I make the header only visible for the second group only?

Thanks!

 

[Marshall Barton]

Hopefully this is not too novice a question for everyone, but it has me
stumped. How do I not make visible the first section of a group header in a
report while keeping the other section of the group header visible?

Right now I have a report that has delivered (value =1) vs non-delivered
(value=0) patients seen. All the patients must be listed in the report and
sorted by non delivered first and deliveries listed last. The report is
grouped by delivery status. I want to offset the two groups so I thought a
group header would be best. I can do that but I can't create 1 group header
for both groups. So right now my group header reads DELIVERED PATIENTS.
Unfortunaly that is the header for the non-delivered patients in the
beginning (value=0) as well. I really only want a header for the delivered
patients at the end.

How can I make the header only visible for the second group only?

A quick and dirty way to do that is to cancel the header
when the delivered field os 0. Use this kind of code in the
group header section's Format event:

Cancel = (Me.delivered = 0)