I am quite new to Jet reports scheduler and was under the impression you could set up using conditions.
For example: Running a monthly expense report for a program and if an expense was over $10,000 then email to the manager. If not then dont email.
Is this possible? If so can someone give me a clue as to how I would do this?
Cheers
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Cwatt,
You cannot add a condition to the scheduler. It would be a great feature - you will get my vote if you'd add it to the Suggestions part of this forum :)
But why don't you build a report that only shows expenses over 10000$? I know this is not exactly what you mean, but it might be a work around solution. -
Jet Reports Historic Posts Just putting this out there… Could you use some conditional statements contained within a sheet and use the 'Batch File Generation' option in the scheduler? I've not ever used this myself, but it sounds good on paper.
-
Jet Reports Historic Posts Hmmmm… that's a nice idea, Mark! I think you could do that…
Another consideration: if this would be a monthly procedure my manager would like to get a report that shows either nothing or expenses above 10000. But he definitely would like to get the email so that he is assured that the procedure was executed. Does that make sense? -
Jet Reports Historic Posts Thanks for the suggestions - I will investigate the batch file generation option further.
-
Jet Reports Historic Posts Easier could be to ad an "if" in the mailing list in excel… you could test this?
something like =if(C3=0;"";"mail@mail.com")
edit - first tests didn't work out as planned, someone else might get this to work?
Please sign in to leave a comment.