How to save Navision Reports as PDF

Do you have a code snippet to obtain this?

And after the report is print I probably need to destroy the newly created record in "Printer Selection"?

Ok, everything works so far but the only thing that's kind of strange is the fact that somethime a "0" reference for the bullzip printer is created in the printer selection.

recSalesHeader.SETRANGE("Document Type", Rec."Document Type");
recSalesHeader.SETRANGE("No.", Rec."No.");
recVendor.GET("Buy-from Vendor No.");

//Printer tijdelijk instellen
IF NOT lPrinterSelection.GET('',ReportID) THEN BEGIN
  lPrinterSelection.INIT;
  lPrinterSelection."Report ID" := ReportID;
  lPrinterSelection."Printer Name" := 'Bullzip PDF Printer';
  lPrinterSelection.INSERT;
END;

IF ISCLEAR(BullZipPDF) THEN
CREATE(BullZipPDF);
Window.OPEN('bezig met verwerken ######################1##');
ReportID := REPORT::AankoopOrder;
FileDirectory := 'C:\TMP-PDF\';
FileName := 'IO'+"No." + '.pdf';


Object.GET(Object.Type::Report,'',ReportID);



BullZipPDF.LoadSettings;
RunOnceFile := BullZipPDF.GetSettingsFileName(TRUE);
BullZipPDF.SetValue('Output',FileDirectory+FileName);
BullZipPDF.SetValue('Showsettings', 'never');
BullZipPDF.SetValue('ShowPDF', 'no');
BullZipPDF.SetValue('ShowProgress', 'no');
BullZipPDF.SetValue('ShowProgressFinished', 'no');
BullZipPDF.SetValue('SuppressErrors', 'yes');
BullZipPDF.SetValue('ConfirmOverwrite', 'no');
BullZipPDF.WriteSettings(TRUE);
REPORT.RUNMODAL(ReportID,FALSE,FALSE,recSalesHeader);

TimeOut := 0;
WHILE EXISTS(RunOnceFile) AND (TimeOut < 10) DO BEGIN
SLEEP(1000);
TimeOut := TimeOut + 1;
END;
Window.CLOSE;
cuMail.NewMessage(recVendor."Fax No.",Text036 + ' ' + "No.",'',FileDirectory+FileName,TRUE);
IF lPrinterSelection.GET('',ReportID) THEN BEGIN

//Printer terug verwijderen
  lPrinterSelection.INIT;
  lPrinterSelection."Report ID" := ReportID;
  lPrinterSelection.DELETE;
END;

I have been lurking in this thread for a little while, and I'd like to thank Rashed for this contribution!

I've been dabbling with bullzip for a bit, myself now. What I was curious about, were the settings that one can use for Bullzip (such as ShowPDF, ShowProgressFinished,...) It might have been posted before, but I've looked through this thread before and haven't found it as of yet:

http://www.biopdf.com/guide/settings.php

These are the settings that can be used as the .SetValue('configname', 'configvalue'); parameters.

Rashed already incorporated those of most value, but maybe someone else out there could make use of another parameter.
RememberLastFileName, RemeberLastFolderName, ShowSaveAs, etc... might improve the usability for your users. It also seems possible to embed watermarks, merge PDF files, password-protect files, you can even pass on the way the document is supposed to be viewed in the default viewer, after output (though not all viewers might accept those parameters).

Do note, the above website is for bioPDF, the commercial "branch" for BullZip, though the functions seem to remain the same, from what I have been able to test.

The only thing I'm missing, is a mail function... Anyone had any luck on that with BullZip?

Thank you for the warm welcome! Truth is, I have posted here before, rarely. But it seems I forgot the account details...

And, you're welcome. Whatever I can do to attribute to your awesome post.

I'm not quite a developer. I do mess around in code very now and then, but could you point me in the right direction to look into SMTP from within NAV?

I noticed that it's possible to automatically execute a .VBS script whilst parsing the report to PDF. I had considered using a .VBS script to launch an emailer of some sort. But I'd rather keep my code IN NAV.

This thread is really a great contribution to the knowledge of the community. But, before you code your solution there should be some general considerations allowed:
1.) How to save Navision Reports as PDF (the original theme, remember) - this question (or How To) is easy to answer. There are many solutions on the market, many of them are free, some of them you will more like than others... - may be your customer will already have one of these solutions installed on his computers..
2.) What do you want to do with the created PDF file? May be, you want to attach it to a mail, put it into an archive, fax it (yes, this is possible) - there should be all possibilities open.
3.) If there is a solution for NAV, handling, creating, printing, mailing, etc. PDF files, it should be as "general" as possible? Why? If you are fixed to one PDF solution (PDFCreator, bullzip,...), your solution may work for the moment. But what about the future? Next versions may not be free anymore, there may be other problems with operating systems (Vista), e.g. - Wouldn't it be nice to have a solution for NAV working with an arbitrary PDF creator? What kind of basic functionality should this PDF creator provide? The only thing, we need is the capability to create a PDF file from a NAV report. - this file could have a fixed name (in the simplest case). Fortunately almost every "PDF creator solution" can accomplish this in the most simplest way, in form of a printer driver which is configured to print to a file (there is no automation component necessary).
4.) The PDF solution for NAV should be as simple as possible. If you want for example attach the print result of a report to a mail as a PDF file, it should not be necessary to design the report in any way (except if you want to initialise the mailaddress, of course).

All these considerations (and a few more) have led us to the decision to develop a "general" tool, where the mail (SMTP or MAPI) and fax issues integrate as naturally into the application as the printing process. I will soon present this tool in the product directory...

Hello,

I gave up searching for solution myself, so this thread is my last hope.
I have to make such thing: to make a report in excel then save it to PDF and then send it by email, but most importantly - it has to be done without any user intervention.
First job is done: there is an excel report. Now I'm struggling with the second (email option is my last concern). I am using PDFCreator and when I try to print a file in a particular directory, PDFCreator opens default program (in this case Excel), shows that tiny print dialog window, prints the file to the appropriate directory (user doesn't have to do anything even all of the windows appear), but when it finishes printing, it closes current workbook, but blank Excel window is STILL hanging on the screen and I can't figure out how to close that damn thing. Maybe you have some kind of life-saving ideas?

Here is the piece of code that I use:

IF ISCLEAR(pdfCreatorApp) THEN
CREATE(pdfCreatorApp);
IF ISCLEAR(pdfCreatorOptions) THEN
CREATE(pdfCreatorOptions);
XlWrkBk.SaveCopyAs(ENVIRON('TEMP') + '\' + XlWrkBk.Name + '.xlsx');
ExcelFileName := XlWrkBk.Name;
XlWrkBk.Close(FALSE);
XlApp.Quit;

IF pdfCreatorApp.cStart('/NoProcessingAtStartup',TRUE) = FALSE THEN BEGIN
globalErrDescriptionTxt := 'Status: Error: ' + pdfCreatorError.Description;
ERROR(globalErrDescriptionTxt);
END;

pdfCreatorApp.cClearCache();
pdfCreatorApp.cVisible := FALSE;

DefaultPrinter := pdfCreatorApp.cDefaultPrinter;
pdfCreatorApp.cDefaultPrinter := 'PDFCreator';

pdfCreatorOptions := pdfCreatorApp.cOptions;
pdfCreatorOptions.UseAutosave := 1;
pdfCreatorOptions.UseAutosaveDirectory := 1;
pdfCreatorOptions.AutosaveDirectory := ENVIRON('TEMP');
pdfCreatorOptions.AutosaveFilename := ExcelFileName;
pdfCreatorOptions.AutosaveFormat := 0;

pdfCreatorApp.cSaveOptions := pdfCreatorOptions;

pdfCreatorApp.cPrinterStop := FALSE;

pdfCreatorApp.cPrintFile(ENVIRON('TEMP') + '\' + ExcelFileName + '.xlsx');

pdfCreatorApp.cPrinterStop := TRUE;

pdfCreatorApp.cDefaultPrinter := DefaultPrinter;

// Everything is done except Excel window is still in front of my eyes.
//Clearing Objects

P.S. Could somebody explain me, what does that property CPrinterStop do...?

Hey everybody I didnt get Record 2000000001 in my NAV database?
Can you pls explain this to me
Thanks

Hi,

Is there anyone that can advice me as I need to urgently revert back to my user. It only hangs when it is printing the report with a range of records. If I am to print by per record it is fine.

A week ago I was trying to use PDF Creator in a batch process to create many PDF invoices. While the batch process was running I wanted to test what happens if I would print another document to PDF Creator. What I was afraid of happened. An invoice that was created in the batch process was overwritten with the document I printed to the PDF Creator. It's a matter of timing which document overwrites the other one.

The bullzip PDF printer mentioned the other posts does not have this problem due to the local runonce file that is created when used in batch mode.