Suppressing subtotal lines

[John Pearce]

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.