Suppressing subtotal lines

[Rus]

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:
>The company has added a new layer to some of our reporting.  Previously, we
>sorted on STATE-CODE, FACILITY-NUMBER and had corresponding FOOTING AT
>statements.  Now, there is also a REGION-CODE so the sort is REGION-CODE,
>STATE-CODE, FACILITY-NUMBER with corresponding FOOTING AT totals.
>
>The problem is that in several cases, there is only one state in the region
>and management desires to eliminate either the region totals or the state
>totals.  They don't want to see the same set of numbers printed for both
>the Region and State control breaks.  Unless there is a hidden feature of
>Quiz (8.19.C4), this can not be done directly in Quiz.  
>
>I think I can to do this in a multiple pass mess with QTP and Quiz.  Before
>I spend the time to work through the problem, does anyone have any sample
>code they can share that will do this?  
>
>Anyone else need this feature?  Should we hassle Cognos to add this to
>Quiz?  I can envision a SUPPRESS keyword in FOOTING AT that would suppress
>printing if the control break happened at the same time as an immediately
>higher or lower control break.  Bob D.?????
>
>Thanks for any info you can share.
>
>------------------------------------------------------------------
>John Pearce  <jpearce@rmi.net>	| Bethesda Management Company 
>Speaking for only myself		| Colorado Springs, CO  USA
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
>
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.