Dynamics Community Forum Thread Details

Read data from Matrix Page

We've created a custom Matrix Page in NAV 2017. The Page basically shows some row and column labels, as any matrix page, and the user can input values in the Data Cells (MATRIX_CellData[1],MATRIX_CellData[2], etc)

The idea is to have some code in OnClosePage() trigger, to read the data from the Matrix Page and store it in a NAV Table.

We are not able to find code to set the cursor position on the first row, and retrieve the MATRIX_CellData values. Then loop to the next row and so on, until all rows have been read.

Any ideas? This is what we have tried, but it's always returning the data in the actual Page's active row

IF FINDFIRST THEN REPEAT 
 MESSAGE(FORMAT(MATRIX_CellData[1]));
UNTIL NEXT=0;

The only solution I've found is to code the OnValidate trigger of each MATRIX_CellData field, and store the values on a Temporary record. Then in the OnClosePage() trigger, I will loop through this temp. record and store the values. It's sad to have to do this, as the values are already on screen, and must be some way to just read them

Quick Links

Leaderboard > Microsoft Dynamics NAV (Archived)