I have a report with two grouping levels based on a crosstab query. There is a Region group and within each region, there is a Dev Status group (Proposed, Closure, Existing)for opening new outlets. As there are existing outlets, I don't want to include these under Dev Status group and merely want to show total number in each region. I added a counting formula next to region group and this works well. But when it comes to excluding these existing outlets from the Dev Status grouping, I just cannot find a way to do so. Is there any way, I can exclude these outlets from appearing in the second level? I tried on On format property of detail section using following code but this comes back with a run time error 438 (Object does not support this propertry or method).
If Me!DevStatus = "Existing" Then
Me!Store.Visible = False
Else
Me!Store.Visible = True
End If
End Sub
Will appreciate some help. Cheers
AK
If Me!DevStatus = "Existing" Then
Me!Store.Visible = False
Else
Me!Store.Visible = True
End If
End Sub
Will appreciate some help. Cheers
AK