Crosstab Zeros -
Change the Group by row to Expression and put the following as the field:
Expr1: IIf(Count([TableName].[FieldName])>0,Count([TableName].[Field]),0)
The Count function may be another aggregrate function like Sum but the syntax should be the same. Hope it works for you.
GumbyD