Suppressing subtotal lines

Pickering, John (NORBORD) PICKERIJ@norbord.com
Tue, 18 Apr 2000 09:55:56 -0400


Yes - this will get rid of the stupid footings. But it give you a region
total (i.e. sum of one or more states) when there is more than one state.
There's nothing this easy!

> -----Original Message-----
> From:	Rus [SMTP:russell_garner@aapl.com.au]
> Sent:	Monday, April 17, 2000 10:21 PM
> To:	John Pearce; powerh-l@lists.swau.edu
> Subject:	Re: Suppressing subtotal lines
> 
> 
> You could simply define a field comprised of REGION-CODE concatenated
> to STATE-CODE and sort on this.
> 
> ie 	Define SORT-CODE = truncate(region-code) + trancate(state-code)
> 	sort on SORT-CODE, facility number
> 
> 
> That way you would only get one control break when there was only one
> state within a region.
> 
> Russell Garner
> Senior Analyst
> Australian Arrow
> 
> 
> At 08:12 PM 4/17/00 -0600, John Pearce wrote:
<original problem snipped>
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.