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

Groups > comp.databases.filemaker > #2130 > unrolled thread

Multi-Page Summary Reports

Back to article view | Back to comp.databases.filemaker

Contents

  Multi-Page Summary Reports csampson@inetworld.net (Charles H. Sampson) - 2015-03-28 08:45 -0700
    Re: Multi-Page Summary Reports Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-03-29 10:15 +1200
      Re: Multi-Page Summary Reports csampson@inetworld.net (Charles H. Sampson) - 2015-03-29 15:55 -0700
        Re: Multi-Page Summary Reports ursus <ursus.kirk@gmail.com> - 2015-03-30 01:20 +0200

#2130 — Multi-Page Summary Reports

I've become pretty adept at developing what I call "summary reports".
These typically are only one page long (for my small personal databases)
and consist of a header, body, and trailing grand summary. The body
consists of a number of lines with informaton about some aspect of the
database. (Think customer name and outstaning balance.) The grand
summary contains bits of information about the database (e.g.,
outstanding balances less than 30 days old, 60 days old, etc.)

Now I want to do something similar except that it's a multi-page report,
each page organized as described above. I've figured out a way to do
what I want for my one database, but it's ad hoc and pretty clumsy. Does
anyody know a neat way of doing this?

A related question: Is there a way to force a new page in a report. If
it's in the Pogue Press book it's well-hidden.

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

[toc] | [next] | [standalone]

#2131

In article <1m1zjly.gn44jwll7wfgN%csampson@inetworld.net>, Charles H.
Sampson <csampson@inetworld.net> wrote:
> 
> I've become pretty adept at developing what I call "summary reports".
> These typically are only one page long (for my small personal databases)
> and consist of a header, body, and trailing grand summary. The body
> consists of a number of lines with informaton about some aspect of the
> database. (Think customer name and outstaning balance.) The grand
> summary contains bits of information about the database (e.g.,
> outstanding balances less than 30 days old, 60 days old, etc.)
> 
> Now I want to do something similar except that it's a multi-page report,
> each page organized as described above. I've figured out a way to do
> what I want for my one database, but it's ad hoc and pretty clumsy. Does
> anyody know a neat way of doing this?
> 
> A related question: Is there a way to force a new page in a report. If
> it's in the Pogue Press book it's well-hidden.

In some ways the reports are probably FileMaker's weakest part and can
be difficult and cumbersome to get what you want (and thanks to a buggy
Preview Mode, it can be impossible to do something like an index /
table of contents).

By stretching the various Layout Parts you can make a report as long as
you need it to be. In the Body Part you will eventually get an
indicator of where a page boundary supposedly occurs, but it's only
really a vague guess at best since it can be affected at the print /
Preview stage by things like Sliding field heights or records taking up
differing amounts of space.

You can only specifically force a page break at Part boundaries using
the Part options to have a page break "after every X occurrences", for
example.

Helpful Harry   :o)

[toc] | [prev] | [next] | [standalone]

#2132

Helpful Harry <HelpfulHarry@BusyWorking.com> wrote:

> In article <1m1zjly.gn44jwll7wfgN%csampson@inetworld.net>, Charles H.
> Sampson <csampson@inetworld.net> wrote:
> > 
> > I've become pretty adept at developing what I call "summary reports".
> > These typically are only one page long (for my small personal databases)
> > and consist of a header, body, and trailing grand summary. The body
> > consists of a number of lines with informaton about some aspect of the
> > database. (Think customer name and outstaning balance.) The grand
> > summary contains bits of information about the database (e.g.,
> > outstanding balances less than 30 days old, 60 days old, etc.)
> > 
> > Now I want to do something similar except that it's a multi-page report,
> > each page organized as described above. I've figured out a way to do
> > what I want for my one database, but it's ad hoc and pretty clumsy. Does
> > anyody know a neat way of doing this?
> > 
> > A related question: Is there a way to force a new page in a report. If
> > it's in the Pogue Press book it's well-hidden.
> 
> In some ways the reports are probably FileMaker's weakest part and can
> be difficult and cumbersome to get what you want (and thanks to a buggy
> Preview Mode, it can be impossible to do something like an index /
> table of contents).
> 
> By stretching the various Layout Parts you can make a report as long as
> you need it to be. In the Body Part you will eventually get an
> indicator of where a page boundary supposedly occurs, but it's only
> really a vague guess at best since it can be affected at the print /
> Preview stage by things like Sliding field heights or records taking up
> differing amounts of space.
> 
> You can only specifically force a page break at Part boundaries using
> the Part options to have a page break "after every X occurrences", for
> example.

Thanks, Harry. Wow! With regard to these aspects, my 40-year old Reflex
Plus far outshines FMP.

Charlie
-- 
Nobody in this country got rich on his own.  You built a factory--good.
But you moved your goods on roads we all paid for.  You hired workers we
all paid to educate. So keep a big hunk of the money from your factory.
But take a hunk and pay it forward.  Elizabeth Warren (paraphrased)

[toc] | [prev] | [next] | [standalone]

#2133

Charles H. Sampson schreef op 30-3-2015 om 00:55:
> Reflex
> Plus

You could also revert to a plug-in. Perhaps in conjunction with some 
html. Not for the faint hearted, but I have done it. With some degree of 
satisfaction. (Although not 100% I must admit)

-- 
Keep well, Ursus

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.filemaker

csiph-web