Programatically Supress print dialogue

jimmyf
jimmyf Member Posts: 104
edited 2011-08-14 in NAV/Navision Classic Client
Does anyone know if I can programatically supress the windows printer dialogue.
I have created a report with a request form. The requestform has a checkbox with the option to print to excel. If this is checked I want the report to go to excel (via excel buffer functionality) otherwise I want the report to print as normal.
When I choose the excel option and click OK the windows printer dialogue box opens. This is what I need to supress.

Thanks in advance

Comments

  • Savatage
    Savatage Member Posts: 7,142
    What happens if you hit preview instead of print?
    Does the export to excel work without the print dialog?

    if it works as you desire then you could use the CurrReport.PREVIEW function

    http://msdn.microsoft.com/en-us/library/dd301398.aspx

    if "yourcheck box to export to excel" then currreport.preview.
    since preview is either true of false & so is your check box...it seems possible.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • jimmyf
    jimmyf Member Posts: 104
    Hi there
    If you click preview it works. The report is exported to Excel BUT the preview is also displayed in Nav.
    I tried wha you suggested however you can not explicitly set CurrReport.PREVIEW it must be used as part of a conditional expression. ie IF CurrReport.PREVIEW THEN Do something so I am back to where I started!
    If I run the report and Check ExportToExcel and click OK to run the report the windows print dialogue appears.

Categories