0

Jet Scheduler - Conditionally run reports

Jet Reports Historic Posts

March 26, 2011 16:45

None

Follow

There is a video which demonstrates how to do this at:
http://www.jetreports.com/video/jet-reports-tutorial-trigger-based-email-alerts.php


This and other videos are available if you select the "Tutorial Videos" link from
http://www.jetreports.com/welcome/

Thanks,
Steve

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts March 26, 2011 16:45

  Is there a way to have Scheduler run a report and only e-mail it out if certain criteria are met based on the report? For example, if it is a report of Open Orders and there aren't any open orders at that time, I would like the report not to e-mail itself to the recipient. In other words, I would only like the report to be sent if there is certain data on the report.
  
  I think this can be done using Excel named range, but I am not sure how to do it.
  
  I appreciate any help with this. Thanks.
  
  Lauryn

• 0
  
  Jet Reports Historic Posts March 26, 2011 18:27

  Hi Lauryn,
  
  Yes, this can be done. You need to put a condition in the cell that holds the emailaddress. Suppose you can count the number of orders. If the outcome is 0, the report should not be emailed…
  
  Cell D4 Holds the number of open orders
  Cell D5 Holds the emailaddress
  =IF(D4<>0;"lauryn@…";"")
  
  Make a name box for Cell D5 and setup the scheduler so that it uses this namebox for the emailaddress.
  
  Please let us know if it works for you.

• 0
  
  Jet Reports Historic Posts April 07, 2011 12:13

  Hi,
  
  This works in that the e-mail did not send to the recipient, however, the e-mail still sits in my Inbox -Drafts since there was no e-mail to send it to.
  
  I will take a look at the video Steve suggested to see if there is a another solution there.
  
  thanks.

• 0
  
  Jet Reports Historic Posts April 07, 2011 15:20

  Hi Lauryn,
  
  Generally having the e-mails in Outlook just go to your Drafts folder and not get sent is some sort of a configuration problem with Outlook and Jet Reports support may be able to help you fix it. Frankly, the easiest thing to do if you are using Jet Reports 2010 is to just e-mail using SMTP and bypass Outlook entirely. If you must e-mail using Outlook, then you might want to ask Jet Reports support.
  
  Regards,
  Hughes