Programatically Supress print dialogue

jimmyf

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

Savatage

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.

jimmyf

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.