How to get a simple count of rows in a table

[peter_turner]

Hello Everyone,

I'm trying to find a simple way to make my table title show the number of rows in the current selection.

Usually I just count one of my ID fields such as count(MY_ID), but I'm looking if there is a built in function I can use instead?
Similar to the "Sum of Rows" feature for an expression, just need a simple count of the number of rows that are shown on screen.

Does QV have a built in function for this sort of thing or anyone have any ideas?
The dataset is large with 6million+rows.

Thanks,
Peter.

[Durgadevikumar]

Hi peter,

Let a= Noofrows(tablename) is simply provides the count of rows in a table.

Regards,

DurgadeviKumar