Skip on level break
Kogan, Arthur(50 Pitt)
akogan@westpac.com.au
Tue, 10 Aug 1999 12:35:54 +1000
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01BEE2D9.246D798C
Content-Type: text/plain
Hi Terry.
Could you not do:
heading at FIELD2 skip page
footing at FIELD1 {your total stuff)
I think the 'footing at' for a higher control break would be done before the
'heading at' for a lower control break, if they occured on the same record.
Regards,
Arthur Kogan
Westpac Financial Services
Sydney, Australia
My views are my own and do not necessarily reflect the views of my employer.
> -----Original Message-----
> From: Terry Pickering [SMTP:pickering@myself.com]
> Sent: Tuesday, 10 August 1999 12:09 PM
> To: powerh-l@lists.swau.edu
> Subject: Skip on level break
>
> 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.
------_=_NextPart_000_01BEE2D9.246D798C
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IhwCAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAYAAAAUkU6IFNraXAgb24gbGV2ZWwgYnJlYWsA4gcBCYAB
ACEAAAAzRTNGRjY1RUI1NEVEMzExOTYxRTAwMDA4MzJCNjc1MQAHBwEggAMADgAAAM8HCAAKAAwA
JAAZAAIAMwEBBYADAA4AAADPBwgACgAMACMANgACAE8BAQ2ABAACAAAAAgACAAEDkAYA0AsAACsA
AAALAAIAAQAAAAMALgAAAAAAQAA5AJAH5BHZ4r4BHgBwAAEAAAAUAAAAU2tpcCBvbiBsZXZlbCBi
cmVhawACAXEAAQAAABsAAAABvuLU1+SdNtAMTrgR0540AAD2uPoRAADeb1AAAgEJEAEAAADfBgAA
2wYAAIUPAABMWkZ1E2lasAMACgByY3BnMTI10jIA+zM2AeggAqQD4wkCAGNoCsBzZXQwHiAHEwKD
AFAQVnBycd4yEVkOUAPVEWV9CoAIyGwgOwlvDjA1AoAKgXW2YwBQCwNjAEELYG4OEAgwMzMLpiBI
aSDiVASQcnkuCqIKhAqAIQhRbGQgeQhgIG4ibwVAZG86GYpoZURhZAuAZyBhBUBGkElFTEQS0HNr
BSCSIAqwZ2UZhWIgAhBfGvAcUgogEUAcljEDMHs7GqEFwHQa8AdAHSB0dVUBICkZikkgEGgLgGux
IbFlICceVhyQJx5BvQXAYQMwGmAeISHQZxwQXwXABaACMANgAyBiCXBhTmse0SOREUAgdxpTYvsi
QBsgbiJAJiAjMSJAIiO/HBgeISMQHtIjOgkAdyQ/NSVyLB7SIAaQIhJ5IPhvY2MIcAmAK6ADoCIi
tHNhB4AgCXAFoWQZe+hSZWcLEXMq0BmZBxBzIcAf8UtvLkALkBmTV3UHkHQKsGMcsAuAAHBjewcx
BlJ2DeAHkBmEBrBkqSZweSwRUHUggHIHQPsHMBmKTSuQMdAH0AQgCsD1IkBtK5F3A6AAcBqAGyDf
GtMmcDHxLKAFEGwrkAlwvGZsBZAFQCIiNIRvK0DJNSFlbQtQb3kEkBl7/wr0M2APMReRAUASoBrw
N0GhEeQxNiAtO9JPBRD2ZzERAyBNNnIdoDvTGYYPOuQ6sQsTOuZpLTE0xjQBQDNgMTgwAUAM0Ps/
cx4wRgNhG0AMkh7hGSM0IFAN4GsGcRxhW1OgTVRQOnBCBkA1IJEREGxmLgWgbV0dx48GYAIwQQgK
UHNkYTLR2xggMvFnMxFGIDlG4EYgSDI6MEcAUE0dx1QLGzFBJXApYmgtbEATM2AggHMuA+BhdS7H
CYAMcERXdWJqN0FBB+5THUIsMTcwdkPAJNU9j38+mTo0DNABwRN0DAEhVCf+bSAQGVAcUiAgHkAk
ACvh7SugdTdkAhBsKVEcUgTwbwnwNqFRMSNDcwkRJNQu+CBCYQ3RB0A20CFGSeD/AjBREjXRI3Ad
giTUHIIsYwcFkTWhTGkgRVhDRfxQVCskBAArIAQgP0ARAP8n8BmTTGkZeyGgEOBMgFH+JQkROgYA
T1JZEE9O/x82XhYOUBmZNZIiIkXgAZD5KUFvawQgM2BCIFlTG0v/H0QMhAGgXts70z1gYwZkRf8Z
kxggQBFjFRczZdxfNWX6+xhQaA80GYQB0GYfarpfNf9qumkVarpqRVtfJvE14Fwzz1ZbLDEcxDLg
ZXgx8AUxvyMyC2BGoSZhMuAckXch0OcQ0CAQB3EgSRmEEqALgP8FQCNwICQzYCZxIzIfRFRw3kFZ
kQVAWYEa4Hcy4CGg+wnwGoB1HWAiInXMYjosIv9TsXLQCsAckCJAVnQrkHdg+0OzdMAnXFIIgTWx
ARALgL8cUxrhJCI/QEPAYCFvX6XebFPQU8QCIDLgYlHRXDPuZgtwNzB+ciAdoHdxVdPtJcByIgA6
0XAEkDbQW0ynK0B3YRwQbHA0wW4y0f0hoGt3wSISJuED8FJgHID+bEngQ6AmEiNwLPSFMSHAHSNh
dgdAClA4EiI0Iv8ZhHZ3EtALgDhwANB0YAnAfwhgTBErQB9FLPRJsHTAZf9doIR4c0SGV1JgfraF
uIfB/1RwIOxVo4FkeDVhP2JPY1h/YwtpFWRPlJ9lf2aDZjcw7i5AAZbPl9k1mJ+XnAHQd5qnYvZi
9z2eUhmEGRBPeFRBTEYgQQRpx5qYKP8dNyDbkX+Sj5OflZ+l35rv/6QomH+oj5qYnU+eX2fQn4z/
DjCgj6Gfoq+jv6TPps+m7/9oL6kPtw+rL7kvnD+sT61f/2kAn4+vn7Cvsb+yz7PftO//tf9pbrgP
yB+6L8o/vE/MX9e8X71vvn80v5w2q6meu/9AAL+XJaDV0z/hwJ/Brxmi/n7Y39nv2v/bZBmEQZ7V
1Z8IUACAGmABkFXBRXgzMf8tITERCXAz9VfBRfA1g0DA/mngUtXVRaU7wBkQL5FF0r0ZhFAJERfh
GoDjvkVGcNMJ8B21KDUYMCln0MBwYC03MTc447nlgDSCMeXANjg3LTPnML422H/o/+oP268KgD3R
cP/sb+1/7o/vn+/iMiVK8ATyuyYgXaAi3nDxhUjXIojyfweBPOIk0ARwK5BRIQDAatstIQNwb0lv
GaJV3mHxiP519ojyv/PD9G9JvkjvSfT/WaIuQDsAhbEsAz0QhbFREtpid2Au+jMxsS77dtx1t1ly
+jJZomMJABEQZDLg/y+BBCBRIftwRqFRIYvD+kH7MuAaom1GkoYD93c49hSRAgAFQAADAP0/UgMA
AB4AQhABAAAAMwAAADwzLjAuMy4zMi4xOTk5MDgwOTE5MDkyMy4wMTBhYWY5NEBldWc0amEubGFu
ZS5lZHU+AAALAACACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAB4AIIAYAAAAAAMAAAAAA
AABGAAAAABCFAAAAAAAAAwAjgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAHQQAAAeACSACCAGAAAA
AADAAAAAAAAARgAAAABUhQAAAQAAAAUAAAA4LjAyAAAAAAMAD4AIIAYAAAAAAMAAAAAAAABGAAAA
AAGFAAAAAAAACwApgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAyACCAGAAAAAADAAAAA
AAAARgAAAAARhQAAAAAAAAMAK4AIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgA6gAggBgAA
AAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AO4AIIAYAAAAAAMAAAAAAAABGAAAAADeF
AAABAAAAAQAAAAAAAAAeADyACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAAwAm
AAAAAAADADYAAAAAAB4AMUABAAAADwAAAEtPR0FOQTA4NzM4Q0MwAAADABpAAAAAAB4AMEABAAAA
DwAAAEtPR0FOQTA4NzM4Q0MwAAADABlAAAAAAAMAgBD/////AgH5PwEAAABiAAAAAAAAANynQMjA
QhAatLkIACsv4YIBAAAABgAAAC9PPVdFU1RQQUMvT1U9V0JDL0NOPVJFQ0lQSUVOVFMvQ049TVNN
QUlMIEFERFJFU1NFUy9DTj1LT0dBTkEwODczOENDMAAAAB4A+D8BAAAAFwAAAEtvZ2FuLCBBcnRo
dXIoNTAgUGl0dCkAAB4AOEABAAAADwAAAEtPR0FOQTA4NzM4Q0MwAAACAfs/AQAAAGIAAAAAAAAA
3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VTVFBBQy9PVT1XQkMvQ049UkVDSVBJRU5UUy9D
Tj1NU01BSUwgQUREUkVTU0VTL0NOPUtPR0FOQTA4NzM4Q0MwAAAAHgD6PwEAAAAXAAAAS29nYW4s
IEFydGh1cig1MCBQaXR0KQAAHgA5QAEAAAAPAAAAS09HQU5BMDg3MzhDQzAAAEAABzCQg5dR2OK+
AUAACDCMeW0k2eK+AR4APQABAAAABQAAAFJFOiAAAAAAHgAdDgEAAAAUAAAAU2tpcCBvbiBsZXZl
bCBicmVhawALACkAAAAAAAsAIwAAAAAAAwAGEBf7qukDAAcQLAcAAAMAEBAAAAAAAwAREAEAAAAe
AAgQAQAAAGUAAABISVRFUlJZQ09VTERZT1VOT1RETzpIRUFESU5HQVRGSUVMRDJTS0lQUEFHRUZP
T1RJTkdBVEZJRUxEMVlPVVJUT1RBTFNUVUZGKUlUSElOS1RIRUZPT1RJTkdBVEZPUkFISUdIAAAA
AIZt
------_=_NextPart_000_01BEE2D9.246D798C--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.