Invisible Group Footer

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I have report that shows data on companies
Each company has sometimes sub company

The report is summerize data of company and sub company

If i have only one sub company the group footer of the subcompany should not
be visible.

How can i do that?
 
Roy said:
I have report that shows data on companies
Each company has sometimes sub company

The report is summerize data of company and sub company

If i have only one sub company the group footer of the subcompany should not
be visible.
Click to expand...


You didn't provide enough information for me to be specific,
but I'll take a guess that the subcompany data is in the
report's detail section. If so then add a hidden text box
named txtDtlCnt to the footer section and set its control
source expression to =Count(*)

With that in place add a line of code to the group footer
section Format event:
Cancel = (Me.txtDtlCnt = 1)
 
Back
Top