How to do grouping using coding?

chandrurec · 2011-05-25

Hi all,

I am storing a particular result in the temporary record variable and then I need to group by Item No in the temporary recordset.

Is it possible to do grouping using coding?

If anyone have coding snippets for doing grouping using code , kindly paste that also.

Thanks in advance.

Regards,
chandru.

mohana_cse06 · 2011-05-25

Lets say,If you want to Group with Document no. and Item No. then

ILETemp.reset;
ILETemp.SETRANGE("Document No.","Document No.");
ILETemp.SETRANGE("Item No.","Item No.");
IF ILETemp.FINDFIRST THEN BEGIN
// your code to modify
ILETemp.MODIFY;
END ELSE BEGIN
// Your code to insert
ILETemp.INSERT;
END;

kriki · 2011-05-25

see http://www.mibuso.com/howtoinfo.asp?FileID=22
point Make a total amount per "Gen. Bus. Posting Group" and "Gen. Prod. Posting Group" of table 15:"G/L Entry".

How to do grouping using coding?

Comments

Categories