Account Schedule Export to Excel

anton1987
anton1987 Member Posts: 35
edited 2009-06-09 in NAV/Navision Classic Client
Hi as you all know by now I am pretty ne win Dynamics NAV.

I have a slight problem with report 29

I have got the report not to print to excel if the show value on the account schedule setup is false.

I did it in the following way :



IF AccSchedLine.Show <> 1 THEN BEGIN
TempExcelBuffer.INIT;
TempExcelBuffer.VALIDATE("Row No.",RowNo);
TempExcelBuffer.VALIDATE("Column No.",ColumnNo);
TempExcelBuffer."Cell Value as Text" := CellValue;
TempExcelBuffer.Formula := '';
TempExcelBuffer.Bold := Bold;
TempExcelBuffer.Italic := Italic;
TempExcelBuffer.Underline := UnderLine;
TempExcelBuffer.INSERT;
END;
END ELSE BEGIN
IF AccSchedLine.Show = 1 THEN BEGIN
CurrReport.SHOWOUTPUT(FALSE);
END;
END;

But now I have no Idea on how to make it export work if the value is not zero for any value in the column or for all the other functions. If someone could give me some advice please.

As i am as confused as a baby in a topless bar

Categories