Count number of records in a filtered portal
I have a FM database called Monthly Report. Within Monthly Report I have a portal to my Calls DB that allows me to enter the calls made that month. I filter the Portal Calls so that they are only for that month. How can I then count those records that are filtered in that Portal. In other words, I want to have a field that counts the number of calls I made that particular Monthly Report month. How do you count filtered records in a portal?
Any help here would be greatly appreciated.
I have FMPro Advanced 13.0 v5
OS - Windows 7
If you just want to display the count, not use it in additional scripts or calculations, you can make a copy of your portal (so that it has the same filter expression) and reduce it to one portal row. Then put a "count of" summary field defined in the portal's table in the portal row to show the count.