Suppressing subtotal lines

[Regan, John]

Depending on the number of regions, which probably are not too numerous, you
could define a new report item to sort on and perform footings with.

Define regionx char*30 = region + state if state ne "State Name" else 
 "New Name #1" if state = "State Name" and region = "Region Name" else 
 "New Name #2" if state = "State Name" and region = "Region Name"

Add as many "New Name #s" as you like and then change your footing
statements to be footinga at regionx. 

Hope I understood your message and that this helps.

-----Original Message-----
From: John Pearce [mailto: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.

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