0

How to prevent a jet report from emailing recipients

Jet Reports Historic Posts

September 02, 2014 16:25

None

Follow

Hello,

Is there a way to setup a jet report scheduler that will not email recipients if there’s no data when the report is automatically generated? Any tips or guidance is greatly appreciated.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 29, 2014 09:00

  You need to use conditional expression in a named cell;
  
  Example : Daily Purchase receipt
  
  Mail=IF(Report!F9>0;"user@site.com";"") ( CTL + F3 to create a named cell)
  Report!F9 : is the count of new receptions
  
  When you config email in schedule report , check Get receipt from Excel Named Range , then choose Mail
  I hope that's gonna help;

• 0
  
  Jet Reports Historic Posts August 14, 2015 07:52

  You can also do this via Batch.
  Make a batch with use of NL rows, for example: all buyers how placed a purchase order yesterday.
  
  Then based on that information you start another report, which wil be send to..
  
  Does this make sense for you? If not i can help you set it up.
  
  You can find more information about this right here:
  http://kb.jetreports.com/article/AA-00493/0/Jet-Scheduler-Using-X-Batch-Files.html