Grouping by Line no.

Hello,

i think you have at least 4 options order by elegance and style ascending:

1. google "Navision group by" there are tons of threads

2. if you have a table with the right key, use CALCSUM as Amol suggest

3. Create a SQL view that do the group by and then use NAV to show the output

4. use a nested loop to create another tempTable with the result of the group by (this is a dirty solution )

Something like that:

WITH yourTempTable

  DO BEGIN

    REPEAT

      yourTempTable.FINDSET();

      yourTempTable.SETRANGE(line,line) ;

      IF yourTempTable.FINDSET() THEN BEGIN

          yourTempTabletmp.INIT();

        REPEAT

         yourTempTabletmp.line := yourTempTable.line;

          yourTempTabletmp.doc := yourTempTable.doc;

          // sum qty

          yourTempTabletmp.qty := yourTempTabletmp.qty + yourTempTable.qty;

        UNTIL (yourTempTable.NEXT = 0);

        // fill another table after each iteration

        yourTempTabletmp.INSERT();

        //delete processed lineNo and go next

        yourTempTable.DELETEALL();

        RESET();

        yourTempTable.NEXT();

      END;

    UNTIL (  yourTempTable.ISEMPTY() )

  END;

yourTempTabletmp.FINDSET();

REPEAT

  MESSAGE('%1 %2 %3',yourTempTabletmp.doc,yourTempTabletmp.line,yourTempTabletmp.qty);

UNTIL (yourTempTabletmp.NEXT = 0 );

Hope this can give you some ideas how to move forward ...