This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0F5A6.D5A48880 Content-Type: text/plain; charset="iso-8859-1" I'm hoping that was "tongue in cheek". This listing should be just as open to the rocket scientists as the novices and they shouldn't feel discouraged by posting something which it obviously giving them difficulty. Curtis Aikens Information Technologies Dairyland (780) 486-8442 -----Original Message----- From: Robert H Taylor [mailto:Robert.Taylor2@ipaper.com] Sent: Friday, June 15, 2001 8:16 AM To: powerh-l@lists.swau.edu Subject: RE: QUIZ: COUNT report-item and SUBFILES ---------------------- 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 = = = = = = = = = = = = = = = = = = = = = = = = = = = = 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. ------_=_NextPart_001_01C0F5A6.D5A48880 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: QUIZ: COUNT report-item and SUBFILES I'm hoping that was "tongue in = cheek".
This listing should be just as open to the rocket = scientists as the novices and they shouldn't feel discouraged by = posting something which it obviously giving them difficulty.
Curtis Aikens
Information Technologies
Dairyland
(780) 486-8442-----Original Message-----
From: Robert H Taylor [mailto:Robert.Taylor2@ipaper.c= om]
Sent: Friday, June 15, 2001 8:16 = AM
To: = powerh-l@lists.swau.edu
Subject: = RE: QUIZ: COUNT report-item and SUBFILES
---------------------- 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.
>
>
>
>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
>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.
>
>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
>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/ &nb= sp; Primary Email Address:
davids@swau.edu
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
------_=_NextPart_001_01C0F5A6.D5A48880--
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.