Conditional Group Footer

I want to design a report/subreport that displays the group footer only if
there is more than one record in the group. I have had success setting
variables to count records in the group and then setting an OnFormat event
for the group footer, but I have naming problems when I try to insert the
resulting report as a subreport in another report. Is there a simple built-in
function to hide the group footer when there is only one record in the group?

Since you have managed to count the records, you could put on Detail_Print

GroupFooter1.Visible = ([TextCount] 1)

Change:
- GroupFooter1 for the name of the footer section
- TextCount for the name of your TextBox with the counter of rows


"landeye" wrote:

I want to design a report/subreport that displays the group footer only if
there is more than one record in the group. I have had success setting
variables to count records in the group and then setting an OnFormat event
for the group footer, but I have naming problems when I try to insert the
resulting report as a subreport in another report. Is there a simple built-in
function to hide the group footer when there is only one record in the group?

Works for me. Thanks!

"landeye" wrote:

I want to design a report/subreport that displays the group footer only if
there is more than one record in the group. I have had success setting
variables to count records in the group and then setting an OnFormat event
for the group footer, but I have naming problems when I try to insert the
resulting report as a subreport in another report. Is there a simple built-in
function to hide the group footer when there is only one record in the group?