Hiding row and column totals

[Kebabmeister]

Does anyone know how to hide row and column totals?

 

[MKhanA]

In frame properties, click Methods tab and select BuildFromRow function by double clicking on functions name. You will see following Built-in function:

Function BuildFromRow( row As AcDataRow ) As AcBuildStatus
BuildFromRow = Super::BuildFromRow( row )
' Insert your code here
If (Col1=0 and Col2=0) Then
size.height = 0
End If
End Function

 

[Kebabmeister]

Thanks MKhanA, but I don't think this would work. I am using an Ac7 crosstab so I don't think this will help. Have you ever used the crosstab facility?

The help file suggests a properties "TotalColumnPlacement" and "TotalRowPlacement" controls display but I can't find them anywhere.

 

[MKhanA]

You did not mention that you are using crosstab. Anyway good luck in finding the solution.