How to create / compressan array during report run

Is it possible in Navision to create / modify an array length during report runtime.

Requirement

We run Navision with LS Retail, my requirement is as follows

  1. Go the Mix & Match Table, pickup a ref no.

  2. Go to the Mix & Match Line Table, count the number of records available for the M&M Table

Create an array/arrays for the same record count.

IF runtime creation is not possible, is there an option to delete empty array elements

As far as I know you can’t create an array or modify the lenght during runtime, you have to set the dimension of the variable when you declare the variable.

Why don’t you use a temporary table?

Regards

Claus