AIX 5.3
Universe 10.2.4 Pick
We have been using Cedarville DOWNLOAD for simple extracts rather developing
custom programs for each extract. We are now converting some more complex
reports to extracts and having a bit of difficulty.
Has anybody ever tried TOTALing a single valued field while using BY.EXP on
another field with Cedarville Download? It seems to accumulate the total for
each multivalue. This is only an example of what I am experiencing, not the
actual DOWNLOAD command.
SSELECT CASH-REC BY WHSE BY DATE BY-EXP INVOICE
DOWNLOAD CASH-REC BY.EXP INVOICE TOTAL CASH INVOICE
CASH INVOICE
27.00 123456
789654
55.00 333322
333444
--------
164.00
Acting like,
CASH INVOICE
27.00 123456
27.00 789654
55.00 333322
55.00 333444
--------
164.00
TIA,
Vance Alspach
John Deere Landscapes
________________________________
CONFIDENTIALITY. This electronic mail and any files transmitted with it may
contain information proprietary to Deere & Company, or one of its subsidiaries
or affiliates, and are intended solely for the use of the individual or entity
to whom they are addressed, shall be maintained in confidence and not disclosed
to third parties without the written consent of the sender. If you are not the
intended recipient or the person responsible for delivering the electronic mail
to the intended recipient, be advised that you have received this electronic
mail in error and that any use, dissemination, forwarding, printing, or copying
of this electronic mail is strictly prohibited. If you have received this
electronic mail in error, please immediately notify the sender by return mail.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
