Simple array question

RonaldW

Hi,

I have a simple question about arrays.

What i want to do is a simple count of different Template Codes in a table.

Example:

Template code 1: 12 x present
Template code 2: 10 x present

At the end of the table i want to print these values.
It think i can do this with an array. But how :P?

Can anyone of you help me with this?

Miklos_Hollender

There isn't really any elegant equivalent of SELECT DISTINCT in Navision. What you can try is to create a key for that field. Create a report using that table and key, count in a variable, after each record if it's different thant the previous one, showoutput(true) and show the variable and reset the variable... and the same thing again after the last record for... as lovely as kicking dead whales down the beach but it should work.