Excel report

Business Central/NAV User Forum
1

Hi Users,

Am doing a excel report. I had exported all the values from navision report to excel. Here I have a problem that the property called blankzero has been set as Yes, After that am not getting any zero values in my navision report. Here in excel am able to see those field values in zero. Is ther any way to clear those zero valued fields in excel.

Regards,

Seshadri.

2

Hi Seshadri,

If you don’t want your ZERO valued cells to be printed in Excel, you can:

a) Put the commands which export data to excel on a separate section of the Report and use the CurrReport.SKIP property.
b) Check for ZERO values using an IF condition and then make the values to print blanks.

–Vikram