Substitute footing print based on subtotal.

[Jones Allen (Van)]

So long as the collating sequence places "N" before "Y", you might be able
to use the MAXIMUM function
	DEFINE MY_TEST_Y char*1 = "Y" IF MY_COLUMN = "Y" ELSE "N"
	DEFINE MY_TEST_Z char*1 = "Y" IF MY_COLUMN = "Z" ELSE "N"
	...
	FOOTING AT MY_INDEX_COLUMN
		MY_INDEX_COLUMN		&
		MY_TEST_X MAXIMUM		&
		MY_TEST_Y MAXIMUM		&
	...etc.

I haven't tried it (re: specific syntax), but if I understand your question
correctly, something like this might give you what you want.

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse@qtiworld.com]
Sent: Thursday, April 19, 2001 12:31 PM
To: 'powerh-l@lists.swau.edu'
Subject: Substitute footing print based on subtotal.


Hi all,

I'm not sure how to explain what I want, so I'll start with my current QUIZ
code on 8.13D1 -- the memory leak version -- on HP/UX 10.20:

	ACCESS MY_ORACLE_TABLE

	DEFINE	MY_TEST_X NUM = 1 IF MY_COLUMN = "X" ELSE 0
	DEFINE MY_TEST_Y NUM = 1 IF MY_COLUMN = "Y" ELSE 0
	DEFINE MY_TEST_Z NUM = 1 IF MY_COLUMN = "Z" ELSE 0
	DEFINE MY_TEST_OTHER_IDX NUM = INDEX("XYZ",MY_COLUMN)
	DEFINE MY_TEST_OTHER NUM = 1 IF MY_TEST_OTHER_IDX > 0 ELSE 0

	SORT ON MY_INDEX_COLUMN

	FOOTING AT MY_INDEX_COLUMN
		MY_INDEX_COLUMN		&
		MY_TEST_X SUBTOTAL		&
		MY_TEST_Y SUBTOTAL		&
		MY_TEST_X SUBTOTAL		&
		MY_TEST_OTHER SUBTOTAL

What I want is a "yes/no" in place of the SUBTOTALs.  "Yes" if a subtotal >
0, "No" if = 0.

Due to certain other complications which I don't want to get into, this
really needs to be done in one pass.

Can this be done???

Rich Jesse                          System/Database Administrator
Rich.Jesse@qtiworld.com             Quad/Tech International, Sussex, WI USA


-----------------------------------------------------------------------

This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.