QUIZ: COUNT report-item and SUBFILES

[Robert H Taylor]

---------------------- Forwarded by Robert H Taylor/WoodProd/IPAPER on
06/15/2001 10:15 AM ---------------------------


David Sowder <davids@quark.swau.edu> on 06/15/2001 10:05:54 AM


To:   Robert H Taylor <Robert.Taylor2@ipaper.com>
cc:
Subject:  RE: QUIZ: COUNT report-item and SUBFILES




that is basic stuff and things, so who really gives a something, just do a
sort, a subfile at something,
w/ and presto....you have a count....geeze. stop cluttering up this
listing.....


---------------------- Forwarded by Robert H Taylor/WoodProd/IPAPER on
06/15/2001 07:12 AM ---------------------------


>"Deskin, Bob" <Bob.Deskin@Cognos.COM>@cube.swau.edu on 06/14/2001 03:40:43
>PM
>
>Sent by:  powerh-l-admin@cube.swau.edu
>
>
>
>To:   powerh-l@lists.swau.edu
>cc:
>Subject:  RE: QUIZ: COUNT report-item and SUBFILES
>
>
>Here's another few categories of question: HISTORICAL (or hysterical),
"WHY
>DOES IT DO THAT", "WE'D RATHER NOT DISCUSS IT". Often it will be Matt that
>responds or I will.
>
>As to the "EASY" part, simply define a counter and include the defined
item
>in the report statement with a subtotal.
>
>Now as to "WHY", the best I can do is that there isn't any specific item
>associated with COUNT. COUNT is a function and we don't put function names
>out as items. Also, at one time, in the Jurassic, there were no subfiles.
>So
>there was no need to associate an item to the COUNT. It just appeared on
>the
>report. When subfiles were introduced, they simply took the values from
the
>item buffers for those items specified in the REPORT statement. For COUNT,
>there was a buffer holding the value, but no associated item name.
>
>Note that for AVERAGE and RATIO, we put out two values - a total and a
>count
>- because that's what we have in the buffers. Don't ask me why, I wasn't
>there (believe it or not).
>
>Aren't you glad you asked :-)
>
>Bob Deskin
>PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA
>
>-----Original Message-----
>From: bdawson@nmstc.ca [mailto:bdawson@nmstc.ca]
>Sent: Thursday, June 14, 2001 2:36 PM
>To: powerh-l@lists.swau.edu
>Subject: QUIZ: COUNT report-item and SUBFILES
>
>
>Hi everyone,
>
>A questions for the list that may also fit into the "EASY" category: Why
is
>the "count" report-item excluded when reporting to a subfile in QUIZ.
>
>I have the following simple report statement:
>
>REPORT CAT-NO REPORT-DATE REPORT-BY COUNT
>
>To the screen or printer, there is no problem -- I see all four columns,
>and my counter fuctions as I want.  But when I set a subfile...
>
>SET SUBFILE NAME MYREPORTLIST
>
>...then the subfile only includes the first three columns.  Why does this
>happen? Any suggestions on how to write COUNT to the subfile (or how to
>produce an equivalent end result)?
>
>Thanks,
>BRIAN.
>
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.
>
>

--
David R. Sowder
Network Manager/Lead Software Technician
Southwestern Adventist University
http://www2.swau.edu/~davids/         Primary Email Address:
davids@swau.edu