I started using filtered portals in cross-tab reports shortly after they were introduced. And what about that Go To Related Record script step? Does it only show the related FILTERED records or all related records? The demo ( bvoth_aggregates_in_portals.fmp12) and article have been created to answer these questions.
This recent topic led me to consider what other aggregate fields could be used with the filtered portal. (The instructions for creating the filter for a portal and summary field are below.) Voila! your count is now filter-specific. Place the related summary field, “Count of…”, in the single row filtered portal. Q: How do you get the Count() of the related records in a filtered portal? A: (paraphrased) duplicate the filtered portal and make it one row in height. The question on one or more of the FileMaker forums was asked and answered.
0 kommentar(er)
