count on records of table

NoiK00

Hey NAV-ers,

I got a small, basic question on how to get the number of records when in table view. Is there a handy functions that will display this information?

Thanks in advance,
NoiK

einsTeIn.NET

What would you guess how should such a function be named?

Belias

do you mean after a user interaction?
e.g.: a user opens a list form, sets some filters and then he wants to know the no. of records?
no, out of the box, there isn't.
if you are a developer you can easily implement it with the [What would you guess how should such a function be named?] function on the rec variable (you have to do it for every form you need it), otherwise, you can export to excel the table and count the rows

NoiK00

With a function i ment a button, filter....some of these options. So the users can see it.

It seems that there isn't an out of the box one. So i thought maybe there is another handy feature with some combinations of these buttons. That's too bad, now i am "copying" the table to excel and i see the count there. then i keep using that method.

Thanks,
NoiK

Belias

you can use the "send to excel button" if you are in nav 5 or more...it's faster than copy/paste for large tables, and you don't even have to run excel manually.
anyway, if you need the counter just on some forms, you can implement the COUNT function in a lable textbox in the bottom of the form (something like the balance field in the journals)

NoiK00

Thanx, with the send as excel button it will work to, maybe the label isn't needed then...we will see..


Thanx

Belias

NoiK00 wrote:

Thanx, with the send as excel button it will work to, maybe the label isn't needed then...we will see..


Thanx

unfortunately, you've to remove that label line manually

Andwian

NoiK00 wrote:

I got a small, basic question on how to get the number of records when in table view. Is there a handy functions that will display this information?

einsTeIn.NET wrote:

What would you guess how should such a function be named?

NoiK00 wrote:

That's too bad, now i am "copying" the table to excel and i see the count there.

That is the clue

rec.COUNT;

Savatage

We've added that to a few forms here & there - A simple TextBox at the bottom of the screen.

Sourceexp = COUNT

Item List
Customer List
Payment Journal
etc.