Disable printing hardcopy if you print to excel

Business Central/NAV Developers Forum
1

Hi all,

I tried to print report in excel from NAV, but everytime i print to excel it also prints hardcopy and i dont want that.

How do we stop it or disable it? I tried to debug it and check the code but can’t find anything.

Thank you

2

Is it the standard report or a customized report ?

3

Hi there,

It’s a standard report i think… under manufacturing > planning > Reports > stock on hand report

4

Hi,

This is not a standard report. To fix this use a command like

IF PrintToExcel THEN
CurrReport.SHOWOUTPUT(FALSE);

in the OnPreSection of all the section that print

Look at standard report 120 Aged Accounts Receivable for an example of how to do it.

5

Or just click Preview instead of Print.