How to create Row Number in AX 2012 Form's GridControll ??

Finance and Operations/AX Developer Forum
1

Hi,

I want to create a form with grid control in it. and I need one field in that, which shows row number. like

Sr. No. ID Name

1 DAT-0001 ABC

2 DAT-0002 XYZ

3 DAT-0003 PQR

So, My question is How can I create this “Sr. No.” Field in Grid of Form ???

I there any property for doing that or need to do any Code for it.

Thanks

Sumit

2

Hi Sumit,

Create one new number sequence on that form using below link then the number will be allocated in the Sr.No filed automatically when you press Ctrl+N.

Try this link:http://axaptacorner.blogspot.in/2012/09/generate-number-sequence_8531.htm

Thanks

3

Hi Sumit,

Create one new number sequence on that form using below link then the number will be allocated in the Sr.No filed automatically when you press Ctrl+N.

Try this link:http://axaptacorner.blogspot.in/2012/09/generate-number-sequence_8531.htm

Thanks

4

Hi Pandu,

Is there any other way to do that… like in SSRS report we use RowNumber(Nothing);

Thanks

5

Hi Sumit,

You can set the counterField property of form datasource to the field which you want to increase.This will do magic.

Thanks & Regards,

Britto John Baskar.A

6

Hi Britto,

Thank you… It is really working for me…Great…

regards,

Sumit

7

Hi Britto,

I have tired using CouterField in the Form Datasource for a field which is real (EDT as LineNum at table level and it is the index for the table). But, I am getting Values like

1.00000

-1.00000

-2.00000

-3.00000

and so on for the new records.

Can anyone please tell where I am going wrong.

Thanks in advance.