Report problem

[Ronald Walcott]

Mr Arnone

I have never used PowerHouse on HP but assuming that the HP version is
similar to the VMS version and assuming that I am understanding correctly
what you are asking below is a solution which should help:

One way to solve the problem is to create a subfile which contains items
from both files

e.g. if the AP file contains ClientJobNumber, total1, total2, total3
and the AR file contains ClientJobNumber, total4, total5, total6
You must create a subfile containing ClientJobNumber, total, total2, total3,
total4, total5, total6

To distinguish between the AR and AP records you must add another field to
the subfile. If AP must print first then an item RECORD_IDENTIFIER
CHARACTER*1 can be created. When the AP is written to the subfile write "A"
to this field. When the AR is written write "B" to this field. A QTP process
would therefore populate this subfile sorting on ClientJobNumber and
Record_Identifier, you should then have a file with the AR records following
the AP records. Only fields corresponding to the particular type of record
would be populated when the process is run. The report can then use DEFINE
fields which will look at the type of record "A" or "B" to create the
desired layout.

Hope this helps.

Ronald Walcott


----- Original Message -----
From: "Arnone, Anthony" <aarnone@grey.com>
To: <powerh-l@lists.swau.edu>
Sent: Friday, February 21, 2003 10:09 PM
Subject: Report problem


> Good Afternoon all,
>
> I am having a problem that I can't seem to figure out how to get
> around. Hopefully I wont confuse anybody with my explanation of the
problem.
> I am using version 8.19 on an HP3000 running MPE/iX.
> I have 2 tables, one is an accounts payable table and one is and
> accounts receivable table. Both tables contain a field called
> ClientJobNumber which is the primary key.The report currently prompts for
> one ClientJobNumber then I access the accounts payable table then write it
> to a disc file then access the accounts receivable info then append it to
> the same disc file. This works fine because it is just one ClientJobNumber
> that I am grabbing and then simply writing the data to the disc file. But
> the user now wants the report to grab all ClientJobNumbers and create the
> same report by showing a ClientJobNumber with the A/P info then the A/R
info
> then showing the next ClientJobNumber and so on, all in the same disc
file.
> The problem that I am having is because the AP data and the AR data are
> different how can I create the disc file looking the same way when I am
> getting the data at different times. I hope that I didn't confuse anyone
> with this, if you have any questions please let me know.
>
> Also one way that I tried was to create a subfile of both tables but
> then I have no way of putting the AR info after I total the AP info.
>
> Anthony
>
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.