Default settings for profile tables
You can set up defaults for profile tables. Profile table defaults are specified separately from the defaults for aggregated tables, using the ProfileDefault table property instead of the Default property. For example, here is a default annotation to display the base value on all profile tables:
TableDoc.ProfileDefault.Annotations.Item[7].Specification = "{TableBase \p}"
This displays the number of rows in the table in the right footer position (position 7). If the table is filtered, it returns the number after filtering, and if the table is truncated by setting the MaxRows property, it returns the number of rows specified in MaxRows.
Some default settings are not suitable for profile tables and therefore are not used. You can set profile defaults for:
▪Filters.
▪Annotations. The default annotations are as for aggregated tables; however, the default annotations in the left footer position are not relevant to profile tables and so are not included.
You can also set defaults for the FilterEmptyRows and MaxRows properties:
TableDoc.ProfileDefault.Properties["FilterEmptyRows"] = False
TableDoc.ProfileDefault.Properties["MaxRows"] = 100
See also