Form List View show a total count

Business Central/NAV Developers Forum
1

I have been asked to put a total count of say part numbers for example when someone opens the Item card in list view. Down at the bottom of the list view form where it says OK, Cancel. etc… it would have total number of parts in the Navision table 27.

So I’d start with Text Box - On trigger. I’d need a Global variable. Reccount numeric. Maybe reccount: =reccount + 1;

Thanks in advance. Greg.

2

Hi Greg,

It’s a lot simplier that that - use the COUNT function e.g. Rec.COUNT. Put a textbox with Rec.COUNT and you’re done [;)]

It will update even when you filter.

3

Worked like a charm Dave. Thanks a million…

4

Glad to Help [:D]

5

To take this one step further could you have a count that said what record you were on. Say record 5,000 out of a total of 30,000???

6

Hi Greg,

You will have to code this. Off the top of my head you could create a variable for the record you are using. In the onaftergetcurrrecord trigger - filter the record variable to ‘…’+CurrentRecord and then display the count of the record variable as the “5000” records.

7

Thanks I’ll give it a try.

Greg