Re: hide repeating values?

A subsummary PART (there are no such things as subsummary fields) is a
section of a layout that FileMaker will show between groups of similar
records. They are based on "break" fields.

The groups are created when you SORT records. For example, if you lined up
all the children in a high school by age, then all the 14 year olds would be
together at one end, and all the 18 year olds would be grouped together at
the other end. FileMaker similarly can detect -- when a file is sorted --
the groupings created by that sort and will insert a subsummary part between
them. In this case, it would be a Subsummary by Age.

1) Subsummary parts only work in Preview mode.

2) You must sort by the fields the subsummaries are based upon for them to
appear. If you want you "levels" of subsummary data, then you have to sort
by two fields (in the same sort).

3) If a given level of subsummary doesn't contain any data, it won't appear.

For example, you want a list of addressed sorted by State and City. There
are no addresses in Alaska, so that state does not appear:

Alabama
Aliceville
Address 1
Address 2
Anniston
Address 3
Ardmore
Address 4
Address 5
Address 6
Arizona
Cottonwood
Address 7
California
Arcadia
Address 8
Bel Air
Address 9
Address 10
Address 11
Concord
Address 12
Address 13

This example contains three parts:

- Subsumary by State
- Subsummary by City
- Body Part

Hope this helps clear up the issue a little

Bill


"John Pollock" <jbpollock@xxxxxxxxx> wrote in message
news:Wq_hf.1050$4r.741@xxxxxxxxxxx
> Actually, I had tried using subsummary parts but they weren't working the
> way I thought they would, probably because I'm not using them correctly.
> :) I had added 2 subsummary parts and put the fields I wanted to sort by
> in those parts. But when I tried viewing the results, they weren't what I
> expected:
>
> 1) When viewed as a form, it shows only one single record at a time (which
> I expected from form view);
>
> 2) When viewed as a list or table, it's not sorted at all and the
> subsummary field doesn't show up; and
>
> 3) When viewed in Preview Mode, it shows all records underneath my first
> subsummary field, but not subsequent records.
>
> What I really want is something that looks like the following, all on one
> single page:
>
> Subsummary field 1
> Subsummary field 2
> record
> record
> record
> subsummary field 2
> record
> record
> Subsummary field 1
> subsummary field 2
> record
> record
> subsummary field 2
> record
> record
>
> If anyone has any suggestions for this, I'd appreciate this. Part of the
> problem is that the Filemaker help bits on using subsummaries is pretty
> thin.


.

Relevant Pages

  • Re: hide repeating values?
    ... When viewed in Preview Mode, it shows all records underneath my first subsummary field, but not subsequent records. ... Part of the problem is that the Filemaker help bits on using subsummaries is pretty thin. ...
    (comp.databases.filemaker)
  • Re: Sorting for sub-summary report
    ... user to determine whether the sub-summaries are required or not. ... sort the records using FieldB (AND FieldA ... subsummaries should all work. ... Another way is to make three different layouts, ...
    (comp.databases.filemaker)
  • Re: Sliding and page breaks
    ... My layout will always be two pages long, depending on a portal on the first page some of the stuff from page one will move to page 2, but there will always be a text field on page 2. ... If I turn on sliding on that object it will slide up so that part of the text field is on page 1 and the rest is now at the top of page 2. ... I use multiple subsummaries, with dedicated sort fields specifically for each subsummary, to effect pseudo sliding for 6 different image groups and couple of other data groups, that may or may not have content. ...
    (comp.databases.filemaker)
  • Re: Analaysis of Questionnaire in Filemaker
    ... the results but I've decided that my filemaker skills aren't up to it. ... To generate the numbers, you can use Summary fields, or a relationship ... For example, to count occurrences of Male or Female in a Gender field, ... To export the subsummaries to a graphing application, ...
    (comp.databases.filemaker)
  • Re: Sorting for sub-summary report
    ... user to determine whether the sub-summaries are required or not. ... sort the records using FieldB (AND FieldA ... subsummaries should all work. ... Bill Collins ...
    (comp.databases.filemaker)