How to schedule a report to run everyday at a particulartime

Markandey_Pandey

Hi all,

Can we schedule a report to run everyday at a particular time.

can anybody guide me.

lvanvugt

Use the Job Queue.

Administration > Application Setup > Job Queue

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

Denis_Petrov

What would be the best way to run AND email a report on a regular basis?

KYDutchie

lvanvugt wrote:

Use the Job Queue.

Administration > Application Setup > Job Queue
Use the Job Queue.

Administration > Application Setup > Job Queue

Put a call to your report into a codeunit and save as HTML.
The codeunit could then generate and send an email. You could either stream the report html output into the email or attach the HTML file to the Email.

This codeunit could be executed by the Job Queue.

Hope this helps,

Willy

dn

U have to verify that u have license for Job Que first.

Denis_Petrov

KYDutchie wrote:

lvanvugt wrote:

Use the Job Queue.

Put a call to your report into a codeunit and save as HTML.
The codeunit could then generate and send an email. You could either stream the report html output into the email or attach the HTML file to the Email.

Willy

would you please share the exact code
thanks

KYDutchie

Dennis,

it really is pretty easy here is some code that I created to email an error log after an automated sales post batch :

//Send the log to Accounting:
tsSMTPSetup.GET;
SMTPMail.CreateMessage(tsSMTPSetup."Accounting Name",
                       tsSMTPSetup."Accounting email address",
                       tsSMTPSetup."Accounting email address",
                       'Sales Invoice Batch Log','',TRUE);
tsLog.RESET;
tsLog.SETRANGE(Date,TODAY);
IF tsLog.FINDSET THEN BEGIN
  tsLogReport.SETTABLEVIEW(tsLog);
  tsLogReport.SAVEASHTML('c:\SalesBatchLog.HTML');
  tsfile.TEXTMODE(TRUE);
  IF tsfile.OPEN('c:\SalesBatchLog.HTML') THEN BEGIN
    tsfile.SEEK(0);
    REPEAT
      tsfile.READ(tsErrorText);
      SMTPMail.AppendBody(tsErrorText);
    UNTIL tsfile.POS = tsfile.LEN;
  END;
  SMTPMail.Send;
  tsfile.CLOSE;
  ERASE('c:\SalesBatchLog.HTML');
END;

I know this is a bad example by hardcoding and using the 'c:\' but that is what the customer wanted.

Regards,

Willy