Grid Total on Grid Column

[ewpritchard2001]

I have created a custom Form. I need to total ( 2 ) Columns by a Specific Order Number. How do I get a Total? A good example of what I am trying to do is like Summary Availability Form total by Branch Plant.

<P ID="edit"><FONT SIZE=-1>Edited by ewpritchard2001 on 1/28/02 02:52 PM.</FONT></P>

 

[Zoltan_Gyimesi]

Hi "ewpritchard2001",

First of all, welcome to the JDEList Forums!

Secondly, let me two request:
1.) Please, attach always your systm configuration information to your posts.
2.) Let us know a nickname, making possible for us to address our replies to you.
Thanks!

Thirdly:
Please, check one of my previous post in the archives:
Sent by: Zoltan_Gyimesi
Date/Time: 1/15/02 08:17 AM
Subject: Re: Get Max Grid Rows [Post#: 26590 / re: 26519 ]

Maybe you can find there some hints for you too.

Regards,

Zoltán

P.S.: It seems so, today we have specially many "first poster". Should I advise to visit the General Board on the Forum and read Larry's "Nethiquette". I suppose, it is on the top in the list.
... and welcome again, all "first posters"!

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[ewpritchard2001]

Hey, I got the Grid Total now. How do I get that total at a break by a
specific field, like order number?






Regards,

Edward W Pritchard




Edward Pritchard
Xe SP16.1, CO on AS400 Enterprise Server
Lang Companies

 

[Zoltan_Gyimesi]

Hi Edward,

Thanks for your update, nickname and config info!

If my memory serves me well then I have written more thoughts about level break totalling and its possible traps.

Excuse me, but it is too long to describe it here and it isn't really a to complicated thing when somebody have a bit programming sense.

Just some thoughts again.

1.) Create variable sets for the different levels of totaling for accummulations and storing level break (last) values.
2.) Be carefull to initialize all your variables and how to handle the first row.
3.) Never forgot, all level break have to trigger the lower lever break if any EXCEPT at first row. E.g.
When A-3 changes to B-3 then you have to print totals for A-3 and A, although the value on lower level hasn't changed.
4.) Good habit to place the different level break logic behind different hidden push buttons, simulating "subroutines" which you can call at more places with "PressButton" system function calls (General category).
5.) You can insert the level break totals populating the Grid Buffer and insert it into the grid.
6.) You can set different fonts and clolours for the different levels of total.
Hope, could help a bit.

Keep us posted about your progress! Thanks!

Regards,

Zoltán

P.S.: I am sure, you can figure out the details.

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[lisachew]

Hello,

By any means, are you doing what Im thinking you are doing?
Eg:
-------------------------------------
ORder No | Amount | added column for total
-----------------------------------------
123...........10.00...........60.00
123...........20.00...........60.00
123...........30.00...........60.00
456...........40.00...........40.00

Please reply as I might need some help.

Thanks!

Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2

 

[ewpritchard2001]

Yes I am. When I complete the Development and Testing I will Email the
details to you.






Regards,

Edward W Pritchard




Edward Pritchard
Xe SP16.1, CO on AS400 Enterprise Server
Lang Companies

 

[Zoltan_Gyimesi]

Hi Lisa and Edward,

Lisa, I am glad that you have found this thread. I just wanted to reply your other thread that to check this thread and the other, which had been mentioned in one of my replies in this thread.

Nice to see that you can help each other.
Just a request. Please, do this here, on the public Forum instead of privately.

Once, it will be very useful for the others.
Second, we can help you much easier if any problem occures during your task.

Thanks!

Regards,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[lisachew]

Hello Edward,

THanks for your help.

I am able also to get the total on the added column(total) but then it total up the whole order no that is in the application. Which means it does not break when it have different order no.

Anyway, I really do appreciate your help. When you send me the detail can you please tell include the specs and also whch application are you modifying?

Thanks again!


Best regards;
Lisa
OneWorld XE B733.3
SP 13
Intel NT4-service pack 6A
SQL 7
Service Pack 2