see the total number of elements

sarto76 · **Posted:** Tue Mar 12, 2013 1:05 pm

Hallo, it should be a very basic functionnality but, if there is, I cannot see it.
Is there a wa to see the total number of a selection?
For example, when I select the customer list, is it possible to see the total number of customers? Is there another way to do that?
Than you
Max

pawanp · **Posted:** Tue Mar 12, 2013 1:08 pm

Form.SETSELECTIONFILTER(CustomerRec);
CustomerRec.COUNT;

sarto76 · **Posted:** Tue Mar 12, 2013 2:18 pm

Sorry but it is only my first week with Navision...
Where should I put this code?
I tryied to create a new label and put it in the c/ on the onPush() function but the variable won't work
Thank you very much.
Max

pawanp · **Posted:** Tue Mar 12, 2013 2:59 pm

1. Go to customer list form
2. Add a new button and go to push action trigger
3. Add a local record variable "Cust" Customer subtype
4. Add below code

Code: Select all

Cust.RESET;
CurrForm.SETSELECTIONFILTER(Cust);
MESSAGE(FORMAT(Cust.COUNT));

sarto76 · **Posted:** Tue Mar 12, 2013 3:35 pm

Thank you very much!! :lol:

without:
CurrForm.SETSELECTIONFILTER(Cust);

it will give me all the records,otherwise I have to select alla to have the count
Tanks Max

Savatage · **Posted:** Tue Mar 12, 2013 4:45 pm

It's even easier than that.

On the List add a textbox at the bottom with sourceexp = COUNT

Set your glues to bottom & left

Save-Compile->Enjoy

pawanp · **Posted:** Tue Mar 12, 2013 6:07 pm

sarto76 wrote:

Is there a wa to see the total number of a selection?
Max

I assume you need count for only selected records. Maybe I misinterpreted

Savatage · **Posted:** Tue Mar 12, 2013 6:11 pm

sarto76 wrote:

For example, when I select the customer list, is it possible to see the total number of customers? Is there another way to do that?

I was going by this question.

And if by selection he means filter then the Count would work too.

Say he filters on a specific salesperson code.
The list will show just that salesperson and the "count" of that salespersons accounts.

That's what I'm thinking. If he want's to select a few, he could "mark" them & on View->Marked - the count will still be correct. No buttons needed.

pawanp · **Posted:** Tue Mar 12, 2013 6:23 pm

Savatage wrote:

sarto76 wrote:

For example, when I select the customer list, is it possible to see the total number of customers? Is there another way to do that?

I was going by this question.

And if by selection he means filter then the Count would work too.

Say he filters on a specific salesperson code.
The list will show just that salesperson and the "count" of that salespersons accounts.

That's what I'm thinking. If he want's to select a few, he could "mark" them & on View->Marked - the count will still be correct. No buttons needed.

The purpose was just the show the use of SETSELECTIONFILTER. Button could be the easiest trigger.

Savatage · **Posted:** Tue Mar 12, 2013 7:02 pm

Here's a vid (I don't know what youtube did it's kinda screwy) but you'll get the idea how it works for us.

As i filter on different salespeople the list changes, therefore the count changes.

http://www.youtube.com/watch?v=E15JL_rq ... e=youtu.be

Savatage · **Posted:** Tue Mar 12, 2013 8:20 pm

It works for selection also.

Make a selelection - Hit CTL-F1 (now those records are marked)
goto View-> Marked Only

now your count is showing the number of selected accounts.

So it has multiple uses :lol:

mibuso.com

see the total number of elements

Who is online