Hello all,

So I'm sure this has been answered elsewhere but I can't find it with my limited vocabulary. I have created a layout with sub-summary part that produces multiple different sub-summaries with respect to a bunch of summary fields when sorted by a single field (e.g. total/percent when sorted by location for 10 locations). I want to be able to view all location sub-summaries side by side without having to see the individual record data between them, since in some cases this means scrolling through hundreds of them. Is there a way to either hide the individual data that they sub-summaries are reporting on or else basically copy and paste them all into the header? I thought about using a portal with a completely different layout and only displaying the sub-summary part, but I am afraid that placing a single portal in layout mode will not end up producing a separate view of each sub-summary that gets produced.

If this makes sense to anyone (I am a new user and still learning the lingo!), please feel free to offer some guidance. I'm sure this has been solved before. Thanks for your help!

Ben

Looks like this has my answer, but I don't know where to find the "Organizing Records by Categories" panel they are referencing. I created a basic layout and then just added grant total and sub-summary parts. Is this a feature that only exists on Report layouts? I am using FM Pro 11, btw.

http://fmhelp.filemaker.com/fmphelp_11/en/html/non_toc.45.8.html

You can delete the body part of a sub-summary report (and therefore not show the detail). Side-by-side or cross-tab reporting is a very advanced technique in FM (bcs it's really pushing FM to its limits). If that is what you need, I'd contact a professional developer.

Perhaps, all you need is to study this demo by Ray Cologon.

Is this a feature that only exists on Report layouts?

FileMaker the application doesn't really make a distinction between types of layouts. A Report layout is one because of what it's intended use is, not any inherent quality of the layout itself.

As Barbara says, deleting the body is the best way to go. You can also put the "body" fields onto another subsummary part and sort by that when you do want to see the detail.

Awesome! That's EXACTLY what I needed. Thanks!