I want to add serial no in a list page, i have done using an integer variable as sr no and code is written on onaftergetrecord sr no:= sr n0 +1; its working but no changes when i do export to excel using ctrl+e or by clicking the ascending or descending arrow in list page. I m using nav 2013 r2
I don't want sorting in serial no.
but when i do sorting with No. field the serial no gets change.
Best Idea is create Temporary variable of page source table.
In OnOpen Trigger filled this Temporary record with data by increasing one and then GET this Temporary record in onafterGerRecord trigger.
design your page with this filled.
see the below screenshot.
in your case you can use any Intger field of your table.
Design your page
See below screen shots: