QUIZ: COUNT report-item and SUBFILES

[Deskin, Bob]

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.