RE: [U2] Cumulative Trouble in paradise
Not sure if this solution will work in UniData (but it does in Universe): Try writing an iType using this code: @2;Qty+@ eg: SORT FLAT.SHD BY Frame_Color BREAK.ON Frame_Color TOTAL Qty EVAL @2;Qty+@ The @2 means use the 2nd value defined in the iType, but because the 2nd value hasn't been evaluated yet, it uses the 2nd value from the previous iteration (ie. The running total). Adrian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, 26 February 2008 7:38 AM To: U2-Users Subject: [U2] Cumulative Trouble in paradise DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Cumulative Trouble in paradise
Hi Adrian, Guess it just works in Universe! I have no problem with using the select then the list. I had to move the code from a report generator source to hand written 'cus the report generator tries to do it all in one pass. But that's ok, since I had to do that anyway 'cus the standard report was doing the BY.EXP thang, and I had to write a small program to flatten it first so the cumulative thing would work. So I had to remove it from the report generator anyway so I could add the program to the proc and it won't disappear if someone rebuilds the library. Man, all this work for one little field. Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Womack, Adrian Sent: Monday, February 25, 2008 15:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Cumulative Trouble in paradise Not sure if this solution will work in UniData (but it does in Universe): Try writing an iType using this code: @2;Qty+@ eg: SORT FLAT.SHD BY Frame_Color BREAK.ON Frame_Color TOTAL Qty EVAL @2;Qty+@ The @2 means use the 2nd value defined in the iType, but because the 2nd value hasn't been evaluated yet, it uses the 2nd value from the previous iteration (ie. The running total). Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/