QUIZ: COUNT report-item and SUBFILES

[Dave Heasman]

"COUNT" isn't an item, it's a function


access wallaby

DEFINE A NUM*8 = 1

sort on d-key
set subfile name fred keep at d-key
rep summ d-key another-item a subtotal reset at d-key

go

----- Original Message -----
From: <bdawson@nmstc.ca>
To: <powerh-l@lists.swau.edu>
Sent: Thursday, June 14, 2001 7:36 PM
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.