[comp.databases] Group headers in Paradox 3.5 reports

aa640@cleveland.Freenet.Edu (Neil Parks) (04/24/91)

I am a newcomer to Paradox 3.5, and I have a silly question about it.
I have searched the "Presenting Data" manual several times, but can't
find any help for my problem.
 
When designing a report in Paradox 3.5, is there any way to prevent a
lonely group header from printing at the bottom of a page when the first
record of that group appears on the next page?
 
Here's what I mean:
 
I would like to print a client address listing in the following format:
 
4/23/91              Client Listing                      Page 1
 
-A-
 
All-American Company
15 Your Street
Anytown, US 11111
 
Another Company
Box 15
Cleveland, OH 44444
 
-B-
 
Big Company
Address
City
 
    ...and so on.  Everything is fine until, at the bottom of page 3,
    this happens:
 
Final Company
Address
City
 
-G-
 
4/23/91              Client Listing                      Page 4
 
Good Company
Address
City
 
Great Company
Address
City
 
   ...and so forth.
 
Since there was no room for the first G record at the bottom of page 3,
that lonesome G group header shouldn't be there either--should it?
 
I've tried putting the PAGEBREAK command at various places in the
report form.  Either it has no effect, or it causes every group to start
a new page, which I don't want.
 
Is there any way around this?
 
BTW, I used the "free-form" report.  Would using the "tabular" version
(or
whatever the opposite of free-form is) make any difference?
 
Thanks.


--
NEIL EDWARD PARKS
>INTERNET: ac119@cleveland.freenet.edu
(Fidonet) 157/511 (Appleholics)
(GT) 22/9 (Akademia)

byock@umaxc.weeg.uiowa.edu (Bill Yock) (05/03/91)

From article <9104240301.AA14694@cwns4.INS.CWRU.Edu>, by aa640@cleveland.Freenet.Edu (Neil Parks):
> 
> I am a newcomer to Paradox 3.5, and I have a silly question about it.
> I have searched the "Presenting Data" manual several times, but can't
> find any help for my problem.
>  
> When designing a report in Paradox 3.5, is there any way to prevent a
> lonely group header from printing at the bottom of a page when the first
> record of that group appears on the next page?
>  

Try including another grouping outside of the one you have that groups on 
the number of records.  If you can print five records on a page then group
on 5 records, etc.  


--
Bill Yock, Weeg Computing Center, University of Iowa, Iowa City, Iowa 52242
byock@umaxc.weeg.uiowa.edu