Suppressing subtotal lines

[Pickering, John (NORBORD)]

This is a feature we could all use. Without it you're in for a lot of
fiddling just to reduce report clutter. Seems like there should be an option
something like "set noduplicates" to suppress footings when there is only
one line in the next lower report group. Think how dumb your report looks
when there is a region with a single state and that state has a single
facility.

But what's the chance of Cognos making *real* enhancements to Quiz :-(( 

> -----Original Message-----
> From:	John Pearce [SMTP:jpearce@rmi.net]
> Sent:	Monday, April 17, 2000 10:12 PM
> To:	powerh-l@lists.swau.edu
> Subject:	Suppressing subtotal lines
> 
> 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.
> 
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.