Anthony and the ClientJobNumber report.

[Seamus Browne]

If I understand you correctly,

1. This can be done using an unprinted sort key.

If you have

ClientNumber	Client 	Type 		Sum
	100		Jones		AP		160.00
	158		Smith 	AP		100.00
	100		Jones 	AR		177.00
	158		Smith 	AR		521.00


You can define an (unreported  sort key made up of Client plus Type
	def asc-client-number char * 6 = asc(ClientNumber,6)
	def Breaker char * 20 = pack (asc-client-number + Type )
	sort on Breaker
	report client type sum
	;(don't report the breaker)

and send this to an intermediary subfile which will be sorted
on the Breaker key even if the Breaker is not shown in the report.
Then access the intermediary subfile to create the output file :

ClientNumber	Client 	Type 		Sum
	100		Jones		AP		160.00
	100		Jones 	AR		177.00
	158		Smith 	AP		100.00
	158		Smith 	AR		521.00



2. Another (clumsy) way would be to get MPE to do the SORT on the output
file
at the end of the Quiz.

3. And the third (rather more graceful) way would be to leave your final
output file unsorted and shift it over to a PC via FTP automatically
in a job and open it as an external source of data in an Excel Pivot table.

Another thing, if your user wants this report often you could set
it up to run nightly automatically and update the data for the excel
pivot table, wheter it was asked for or not.
That way you're freed from user requests.
You don't event have to think about it.
The new output file just replaces the previous one.
The data is always up to date, it's ready before the user asks for it.

That the way the user only has to open the excel file and the
report is alredy there. Updated during the night.
Excle has the ability to automatically re-read the data and present the
"new" version of the report when the user opens the Excel file.

If this doesn't make sense, get back to me at seammus@partage.org
-------------------------------------------------------------------------

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