Exporting report to excel in Dynamic nav 5.0

ljanneh

I'm currently trying export dynamic nav 5.0 report to excel . Any way I have most of the values to excel
currently I'm stuck at getting the table values to my excel file
i.e
entercell(Row, 1, FORMAT( fixedAsset."No."), TRUE, FALSE, FALSE); // this is always empty
entercell(Row, 2, FORMAT( fixedAsset.Description), TRUE, FALSE, FALSE); // this is always empty

this is the sample code
IF isExcel = TRUE THEN BEGIN
Row := Row + 1;

entercell(Row, 1, FORMAT( fixedAsset."No."), TRUE, FALSE, FALSE); // this is always empty
entercell(Row, 2, FORMAT( fixedAsset.Description), TRUE, FALSE, FALSE); // this is always empty
entercell(Row, 3, FORMAT( StartAmounts[1]), TRUE, FALSE, FALSE);
entercell(Row, 4, FORMAT( NetChangeAmounts[1]), TRUE, FALSE, FALSE);
entercell(Row, 5, FORMAT( DisposalAmounts[1] ), TRUE, FALSE, FALSE);
entercell(Row, 6, FORMAT( TotalEndingAmounts[1] ), TRUE, FALSE, FALSE);
entercell(Row, 7, FORMAT( StartAmounts[2]), TRUE, FALSE, FALSE);
entercell(Row, 8, FORMAT( NetChangeAmounts[2]), TRUE, FALSE, FALSE);
entercell(Row, 9, FORMAT( DisposalAmounts[2] ), TRUE, FALSE, FALSE);
entercell(Row, 10, FORMAT( TotalEndingAmounts[2] ), TRUE, FALSE, FALSE);
entercell(Row, 11, FORMAT( BookValueAtEndingDate ), TRUE, FALSE, FALSE);
entercell(Row, 12, FORMAT( BookValueAtStartingDate ), TRUE, FALSE, FALSE);
END;
UNTIL fixedAsset.NEXT = 0;
END;

in short, I want to retrieve two column from a table and display its values to the first and second of the
excel column

postsaurav

Hi,

Suppose you want to Export Two Fields Says A and B then You can add -

entercell(Row, 1, FORMAT(A), TRUE, FALSE, FALSE);
entercell(Row, 2, FORMAT(B), TRUE, FALSE, FALSE);

Second Parameter in EnterCell is Column Number.