I'm trying to make a report in FM 7 that is a list of people organized
by address. The body contains the person's name and building number;
the sub-summary above it contains the street name.

e.g.

Pennsylvania Avenue
#101 - Abe Lincoln
#101 - Mary Todd Lincoln
#102 - Nelson Mandela

Slater St
#5 - Marie Curie
#7 - Louis Pasteur

....etc.

This works fine, except when there are so many people on a single
street that the data bleeds on to a second page. What I'd like to do is
repeat the name of the street at the top of the page, so the person
using the report doesn't have to page back to remember what street
he/she is on. I can't figure out a way to do this.

I can put the street name field in the report header, but then if the
data _hasn't_ bled over from the previous page, the street name will
show up twice at the top of the page (once from the header, once from
the sub-summary part).

Unfortunately it's important to keep all the information as compact as
possible, so I can't set the sub-summary to "Page break before each
occurrence," even though I realize this would solve the problem.

Any help would be greatly appreciated!

--
Matthew Furrow
mfurrow at mail dot md

Matthew,

Good one. FileMaker certainly doesn't have the capability built-in. So, you
would need to generate a report under programmatic control.

1) Export the records, sorted by the street name.
2) Import the records from step 1 into a new table
3) Create a new field, "ReportLine" in this table
4) Create a layout based on this new table, with just a body part
- Only the "ReportLine" field will appear in the part
- Determine how many will fit on the page
5) Walk through the records under script control
- create new records and insert your own "subsummary" or "subsummary
header" text into ReportLine when needed. (i.e., before the street value
changes or when a new page is reached before the end of a subsummary)
- generate the appropriate body text when a subsummary isn't needed.

Essentially, you're laying out the report ahead of time and printing it
without any processing by FileMaker itself.

Bill

<caradhras (AT) my-deja (DOT) com> wrote

You may 'Print on '3' columns' on the 'Layour Setup' menu.
Your report will be even shorter.
It's not quite what you asked but it may help.
Remi-Noel


<caradhras (AT) my-deja (DOT) com> a écrit dans le message de news:
1129439878.126622.23050 (AT) g44g200...oglegroups.com...