Skip on level break

[Terry Pickering]

I'm trying to figure out the following scenario for a sort break. Basically
I want to do a page break at the second level break EXCEPT if this is first
level break.

I have the following sort: SORT ON FIELD1 ON FIELD2

and the data looks like this:

FIELD1		FIELD2
------		------
100		1
100		2
100		3
100		4
200		1
200		2
200		3
200		4


I have to have a page break on FIELD2, except for last one, at which time I
print a total line for FIELD1. As it is now, I end up the total line for
FIELD1 on a separate page by itself. I've tried defining another field to
also sort on, but have failed to get it to work properly.

If it helps any, I know there will always be a record with a value of "4"
for FIELD2 in each group of FIELD1 records. Ie: I know the last record will
always be a "4". 

I want it to end up like this:

FIELD1		FIELD2		FIELD3
------		------		------
100		1		10.00
100		1		15.00
100		1		20.00
				=====
 TOTAL 1:			45.00
(skip page)


FIELD1		FIELD2		FIELD3
------		------		------
100		2		10.00
100		2		15.00
				=====
 TOTAL 2:			25.00
(skip page)


FIELD1		FIELD2		FIELD3
------		------		------
100		3		10.00
100		3		15.00
100		3		20.00
				=====
 TOTAL 3:			45.00
(skip page)


FIELD1		FIELD2		FIELD3
------		------		------
100		4		10.00
100		4		15.00
100		4		20.00
100		4		20.00
				=====
 TOTAL 4:			65.00

 TOTAL 100:		      180.00
(skip page)


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Terry Pickering        Consultant Extraordinare
Monday and Friday        Tuesday - Thursday
Portland                 Eugene
(503) 245-7178           (541) 687-3416
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.