Hi Folks
I have a question for the BIRT gurus out there. I have been requested to create a report in Maximo that groups open/in progress work orders by Vendor and as the report is rendering, an email should be sent to each vendor with their section/grouping of the report.
I am told that this has been done before, however, I have not seen the solution in operation myself. I found some Java code that will send an email and have placed this in the onPageBreak method. My concern with the page break is that where a vendor's work order list is long, that an email will be sent after each page, rather than after the vendor grouping. Also, duding testing, two vendors appeared on the same page for just one page and the rest were on separate pages.
My bigger concern is getting the Java code to execute, but more importantly, how do I get a portion of a rendered report to be emailed? Is this even possible?
The reasoning behind this approach is to reduce administrative overhead so that the report does not need an individual schedule for each vendor, but has one schedule, once per week and will send to all vendors who have open/in progress work orders. So, if a new vendor is brought on, there is no need to create a new scheduled report and when a vendor is rolled off, there is no need to do a clean up of the scheduled reports.
Is there another way to achieve this outcome with the same minimal administration? I could use cron tasks, etc, but we want to avoid any custom coding within this implementation.
Thanks in advance to those able to help with this interesting question.
Regards
Stewart