AnsweredAssumed Answered

Subsummary report breaks awkwardly

Question asked by MikkoLindberg on Sep 8, 2011
Latest reply on Feb 10, 2012 by meg_cuddihee

Summary

Subsummary report breaks awkwardly

Product

FileMaker Pro

Version

11

Operating system version

Windows 7

Description of the issue

Reports in list view look awkward due to Filemaker's inability to add page breaks to keep categories together.

Steps to reproduce the problem

Create a table with two columns. Enter about 100+ records into the table, with one being a "category" and another being any random value, like a name, for example.

Create a report from this table and have it sorted by the "category" with a sub-summary by the category layout part above the Body. Add the second column field into the Body.

So, essentially, you have created groups of categories with sub-fields, like:

Category A
   Value 1
   Value 2
   Value 3
Category B
   Value 4
   Value 5
   Value 6
   Value 7
Category C
   Value 8
   Value 9

And so on. It is important to note here that the sizes of the groups vary.

Go to print preview mode and see what you get: say you have a long list of values and your report runs over one page. Instead of moving the entire category group over to the next page, Filemaker by default just breaks the list of individual items and starts them on the next page. Unless the reader of the report flips to previous page, they're essentially clueless as to what group the values belong to. This is not an elegant report format.

Expected result

I would have expected FileMaker, similar to what is possible with Microsoft Access, to have the option to keep subsummary categories and their value lists together on one page. I assumed that an unchecked value for "Allow part to break across page boundaries" in the Part Definition options for Body would fix this issue, but it does not.

Actual result

The result, again, is an awkward-looking multi-page report that does not allow for easy readability.

Exact text of any error message(s) that appear

There are no error messages that appear.

Workaround

There is a workaround that sort-of works by adding a conditional header that marks the continuation of a previous page's subsummary category. However, the field MUST go in the header (whereas the other subsummaries are lower, above the Body layout part), and does not resolve the page break issue.

screenshot.JPG

Outcomes