I have a report I've been running in a Pick environment for years without
problems. The data, using ECLTYPE P on UniData, looks like:
[UNIDATA]
SORT BANKBOOK WITH PLANTNOS = "9800""9900" AND WITH YRMO = "200411" BY
PLANTNOS PLANTNOS TOTAL CURRBAL 22:45:48 Feb 07 2006 1
BANKBOOK... PLNT# CURR BAL.....
28*200411 9800 57,482.04
9900 -925.00
15*200411 9900 -64,729.34
=============
TOTAL -8,172.30
2 records listed
One account has two plants associated with it while the other one has only
one plant associated with it. On a Pick machine I do the following:
[D3]
:SSCROLL BANKBOOK WITH PLANTNOS = "9800""9900" AND WITH YRMO = "200411"
BY-EXP PLANTNOS BY ATYPE_ACCTNO BY ATYPE_DESC ID-SUPP PLANTNOS BREAK-ON
PNAME0 "Totals: 'UV'" BNAMES ATYPE_DESCS ATYPE_ACCTNOS TOTAL CURRBAL
Command => SORT BANKBOOK 22:52:24 07 Feb 2006
PLNT# Name.......................... TypeDesc.. GLAcct CURR BAL.....
9800 KEY BANK OF CALIFORNIA Checking 4000 57,482.04
-------------
Totals: PAYROLL TRUST ACCOUNT 57,482.04
9900 KEY BANK OF CALIFORNIA Checking 4000 -64,729.34
9900 KEY BANK OF CALIFORNIA Checking 4000 -925.00
-------------
Totals: PROPERTY MANAGEMENT CORP. -65,654.34
-8,172.30
[405] 3 items listed out of 1089 items.
This doesn't even come close to working in UniData; although it works fine
in UniVerse. I'm running in ECLTYPE P. It looks like:
[UNIDATA]
SORT BANKBOOK WITH PLANTNOS = "9800""9900" AND WITH YRMO = "200411" BY-EXP
PLANTNOS ID-SUPP BREAK-ON PLANTNOS " 'DL'" CURRBAL
PLNT# CURR BAL.....
9800 57,482.04
-925.00
9900 -64,729.34
9900 57,482.04
-925.00
3 records listed
[UNIVERSE]
SORT BANKBOOK BY-EXP PLANTNOS ID-SUPP BREAK-ON PLANTNOS " "DL"" CURRBAL
PLNT# CURR BAL.....
9800 57,482.04
9900 -64,729.34
9900 -925.00
3 records listed.
I've been fiddling with this for quite a while and am obviously missing
something. Can anyone help. Thanks.
Bill Haskett
Advantos Systems, Inc.
www.advantos.net
(760)944-5570 (CA)
(360)923-4838 (WA)
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
