Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1887

Re: Missing Records When Printing and Previewing

Show all headers | View raw

In article <1lrgahm.1dv11uekayr48N%dempson@actrix.gen.nz>, David Empson
<dempson@actrix.gen.nz> wrote:

> Charles H. Sampson <csampson@inetworld.net> wrote:
> 
> > Charles H. Sampson <csampson@inetworld.net> wrote:
> > 
> > >      The mysteries of FileMaker continue to elude me. Here's my latest.
> > > 
> > >      In one of my databases, I have a table that has four records. When
> > > I try to print a layout for this table, I get only two records. I get
> > > four in browse mode, two in preview mode. Show All Records changes
> > > nothing.
> > > 
> > >      The only thing that is at all non-standard about this table, in my
> > > opinion, is that it is entirely populated by a script. That is,
> > > executing this script first deletes all records and then creates
> > > records, resulting in the four that I mentioned above.
> > > 
> > >      Any suggestions? I'm still using FMP8 on a G4. This is the latest
> > > version for that hardware/system combination, I think.
> > 
> >      My thanks to all who so graciously offered to help, to David Empson
> > in particular who found the cause of the problem. In the layout I had
> > the single line of fields that I thought were in the body one pixel into
> > the header part which, in FileMaker, puts the fields entirely into the
> > header. In other, my report consisted of a header, and empty body, and a
> > trailing grand summary. 
> 
> I'm glad I was able to help. Now that I spotted it, I should have
> thought of it earlier, as I've been bitten by similar issues before.

Rats! I was actually going to post the other day to check the fields
aren't "too high", but I thought someone else already had. Oh well, at
least it's working now.  :o)




> >      That's exactly what I was seeing at the end, when the report was
> > showing a single page: A header made of the fields from the first record
> > of the table and the trailing grand summary. I don't understand why I
> > was getting two pages at one time, the second page with a header made up
> > of fields from the second record of the table. I'm mulling that over.
> > 
> >      Does anyone know why FileMaker chooses to fill the header with
> > fields from the first record? Is it by design?
> 
> Yes, it is by design, and is documented in the FileMaker Pro user guide,
> in the section on creating and manging layouts and reports. This also
> mentions the fact that fields and other objects are regarded as being in
> the layout part which their top edge touches.
> 
> 
> > If it's by design, what is the rationale? Or is it just by accident;
> > that's the way the code just happens to work?
> 
> The content of header and footer parts are generated once per page. 
> 
> If they contain normal fields (as opposed to summary fiels or globals),
> the values in those fields are always taken from the first or last
> record which appears on that page.
> 
> A typical case where you want to do this is a report which is sorted by
> a particular field, and a page break is forced whenever that field
> changes. You could then include that field in the header or footer and
> it would show the value which applies to all records on that page.
> 
> Similar rules apply to record fields in the other non-body layout parts
> (title header, title footer, leading or trailing grand summary or
> subsummary).

The same happens if fields are "too high" within a Portal Row, although
usually the first related record's data is replicated on every line of
the Portal.

It's the same basic operation in Relationships too. If a calculation
accesses a field via a Relationship, only the data from the first
related record is used (the exception being aggregation-type functions
like Sum, Average, etc.)


Helpful Harry   :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-08-27 10:39 -0700
  Re: Missing Records When Printing and Previewing dempson@actrix.gen.nz (David Empson) - 2014-08-28 10:54 +1200
    Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-08-28 15:03 -0700
      Re: Missing Records When Printing and Previewing dempson@actrix.gen.nz (David Empson) - 2014-08-29 12:38 +1200
  Re: Missing Records When Printing and Previewing Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-08-28 13:24 +1200
    Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-08-28 15:03 -0700
  Re: Missing Records When Printing and Previewing clkaufmann@gmx.ch (Christoph Kaufmann) - 2014-08-28 07:38 +0200
    Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-08-28 15:03 -0700
  Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-08-28 15:22 -0700
    Re: Missing Records When Printing and Previewing dempson@actrix.gen.nz (David Empson) - 2014-08-29 12:38 +1200
      Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-09-02 02:43 -0700
        Re: Missing Records When Printing and Previewing dempson@actrix.gen.nz (David Empson) - 2014-09-02 22:35 +1200
          Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-09-02 23:06 -0700
        Re: Missing Records When Printing and Previewing Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-09-03 09:41 +1200
    Re: Missing Records When Printing and Previewing Erik Appeldoorn <ursus.kirk@gmail.com> - 2014-08-29 13:27 +0200
  Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-09-03 18:21 -0700
    Re: Missing Records When Printing and Previewing dempson@actrix.gen.nz (David Empson) - 2014-09-04 13:42 +1200
      Re: Missing Records When Printing and Previewing Helpful Harry <HelpfulHarry@BusyWorking.com> - 2014-09-04 13:56 +1200
      Re: Missing Records When Printing and Previewing csampson@inetworld.net (Charles H. Sampson) - 2014-09-04 10:54 -0700
        Re: Missing Records When Printing and Previewing dempson@actrix.gen.nz (David Empson) - 2014-09-05 11:50 +1200

csiph-web