12 Replies Latest reply on Nov 22, 2012 5:54 AM by electric_soul

    Inconsistent Sub- and Grand Summary Behavior when re-sorting

    fciadmin

      Summary

      Inconsistent Sub- and Grand Summary Behavior when re-sorting

      Product

      FileMaker Pro

      Version

      12.0v2

      Operating system version

      OS X 10.7.4

      Description of the issue

      With some found sets, re-sorting a list of records causes Sub-Summary and Trailing Grand Summary parts to display incorrect summary totals. It appears that the Summary fields are displaying the data from just one of the records instead of the Summary of all (or the appropriate subset) of the records.

      Steps to reproduce the problem

      In a list of records with multiple Sub-Summary Parts and a Trailing Grand Summary, I allow the user to re-sort the report by clicking on a header label, using a button-triggered "Sort Records" script step. The sort is hard-coded with sort fields for each header label. The scripted sorts (intentionally) cause certain Sub-Summary parts to appear and disappear based on the sort order.

      With certain found sets of records the Summary fields appear to show data from just one of the found records instead of summarizing. Different sorts show correct or incorrect data in different places. Sometimes the Sub-Summaries will be correct, sometimes they won't. Sometimes the Grand Summary will be correct, sometimes it won't.

      It does not appear to depend on the presence or absence of any one particular record, as I can reproduce the incorrect behavior on sets from the last month, or a completely different set of records from last year. It does seem to be related to the size of the found set, in that the larger sets I've observed seem to behave as expected, while smaller sets are more likely to fail. However, there isn't a hard break in the number of records required. In dozens of tests, I have never observed it happen with more than 30 records. It always seems to happen with less than 10. Between 10 and 30, it may or may not occur.

      Expected result

      Correct summarization of data in found set

      Actual result

      Repetition of data from just one record in found set

      Exact text of any error message(s) that appear

      n/a

      Configuration information

      n/a

      Workaround

      n/a

      Incorrect_Grand_Summary.png