Hello,
I have a customer who wants a report everyday if there's been a transaction for that customer, if not then they do not want a report. I've created a table with all the info I need. I want to use the scheduler to avoid the manual work, is there a way (perhaps a batch file?) that checks if there are any rows in the table, and if there are, sends it to the recipient; otherwise no?
Date
Votes
1 comment
-
Jet Reports Historic Posts I use the method described here:
https://jetsupport.jetreports.com/hc/en-us/articles/218953668-Jet-Scheduler-Using-X-Batch-Files
Basically, I create a report called something like 'customer scheduler' that gives me a list of all the customers that have transactions today. It creates a line in a named range which has the input file (see below), output file, email address and the parameters for the report (the customer, and maybe the date) schedule this to run every morning.
You can generally use the normal report, but make sure you have the customer set up as an option with the cell named so you can pass a parameter.
OR
If it's only one report you want to run, and send if there's something in it (not one per customer), then add something to a hidden sheet that counts the records and sets the email address to blank if it's 0. Then schedule the report, and in the email settings you can choose the email addresses from within the file.
I'm not sure if I explained either of those well, so do ask for more explanation if required.
Please sign in to leave a comment.