No subject

Pablo Grim grim@gorge.net
Fri, 7 Aug 1998 14:42:23 -0700


>I have some questions for your user. Will she sometimes enter the EMP-NO and
>other times the ACCT-NO and yet other times the PAY-PERIOD-NO? Or will she
>enter all three fields at one time and if so, why is she doing this?  Take

Michael,

She will always enter at least one value into each requested item.  1 or
more employees,  1 or more account numbers, and a pay period range (2
values).

The report will be a summary report with total dollars for each account
number.  The account numbers are salary accounts, so she is trying to get
total salary for selected employees for selected accounts.  The employee
numbers and pay periods will be part of the report header i reckon.

eg

				REPORT TITLE
Pay Periods 9801 to 9802, for employees  1, 2, 3, 4, 9, 23, and 99.

Account Number				Total
10-2134-234-233				22,333.34

The quiz/qtp part seems pretty clear to me, but the screen to accept the
selection criteria values is a little tricky.  Like I said, I could set up
some temp work files, but it's kind of ugly to set up new files in the
dictionary and make sure they are purged and emptied each time.  Mailbox
files could be an option (we are Alpha platform), but it sounds like those
may be going away with new versions of Powerhouse.  I have done this type
of thing with temps before like so:

TEMP T-EMP-NO OCCURS 10

CLUSTER OCCURS WITH T-EMP-NO
  FIELD T-EMP-NO
CLUSTER

PROCEDURE PROCESS T-EMP-NO
   LET T-CHOOSE-STRING = T-EMP-NO + T-CHOOSE-STRING

and then passing the choose string to a quiz.  BUT, this assumes a finite
amount of selection criteria in the data entry (the occurs 10)....I need an
OCCURS N....

I probably shouldn't be trying to solve this on the discussion list.  I've
just learned over the years to ask for help more often instead of spending
days and days brainstorming..

thanks for all of your time
p



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.