Hide summary section on report of group doesn't exist

[tagteam]

I group one of my reports by cost center and then rider because a few of the customers use cost centers. However, 90% of them don't have cost centers and it ends up creating a summary for the cost center and then the exact same summary for the rider below it.

I have tried :

If Me.CostCenter Is Null ThenMe.CostCenter.Visible = False
End If

but it doesnt work. How can I hide the cost center summary if there is no cost center?

[Gicu]

I think you need to have the code in the Format or Print event of the section you want to hide (cost center footer???) and use the IsNull() function instead of Is Null:

If IsNull(Me.txtYourControl) then Me.GroupFooterX.Visible=False 'where x is the index of the cost center footer

Cheers,