Sub-summarys within portals pt III

Welcome to Pt III of the sub-summary portal tricks post. As it continues straight from the first and second posts it may be worth skimming through those here and here.

Conditional formatting

The last aspect is displaying either the summary or line item data. In fact all portal lines include both data but using some conditional formatting we can hide or display data based on the underlying type of the record. At the simplest level the portals have the ‘details’ displayed under the summary fields. The summary fields are in fact calcs defined to evaluate to empty unless the are a sub-summary or grand-summary.

The conditional formatting on the fields is simply:

The fields are set to transparent as default so usually the underlying data is visible. So with no data to display and the type not setting the conditional formatting to grey for line items the line items are visible, flag a row as a sub-summary or grand total and the formatting kicks in, hides the underlying fields. The calculation fields now return values which display.

Damian Kelly

Damian has been a database developer with Linear Blue since 2007. During this time he has developed complex FileMaker solutions in a broad range of industries from Finance and Investment to Manufacturing to New Media Promotion. Damian graduated in Production Engineering from the University of Hertfordshire in 1996, attained his Masters of Engineering from Kingston University in 1997 and MBA from Heriot Watt in 2006. He holds certification in FileMaker versions 7 through 12 and in Oracle MySQL 5.

More Posts - Website

Leave a Reply