In today's Jaspersoft trick, we'll show you how to schedule a report, like a project status report, and email it to anyone in three easy steps. It's one of the really exciting features available in CA PPM 14.2 and 14.3. Credit goes to our own Atul Kunkulol, who shared this feature in Free Jaspersoft Ad Hoc Webinar, Part 1.
To schedule a report and send it out to the world in your preferred format, from the CA PPM Home Tab, navigate to Advanced Reporting.
This will bring up the Jaspersoft icons above, depending on your access rights. Most users will see Ad Hoc Views, Reports, and Dashboards. Underneath the Reports icon, select View List to go to the Repository view.
These are just a few of the out-of-the-box-reports; CA has included many. Now right-click on a report you need, and select "Schedule."
You can set up your scheduling to email these reports to people without CA PPM access, and you can send them in lots of different formats. That's a huge, new benefit that comes with this upgrade.
The standard scheduling options are available, like sending it daily or on certain days of the week or month. You can select the parameters that apply to the report, and in your Output Options tab, things get really interesting.
As you can see, the report can even be generated and emailed two ways simultaneously, including as a PowerPoint presentation, Excel document, or in HTML format. You can also select "Output to Repository," and save your report as an output in a folder on the Jaspersoft Server.
From the Notifications tab you can indicate if you’d like to send your PowerPoint report to end users. They don't need to have CA PPM access. This might include vendors, contractors, or a business user without a license for CA PPM.
Now these people can receive status reports off the project, in their email. And taking that a step further, you can include the report files as attachments to the email, and you can make your report generate as HTML in the body of the email. As HTML, so it doesn’t need to be opened! Isn't that thrilling?
Imagine you've got a CIO or CEO on the road checking email. All he/she needs to do is open the email to view the report, without opening an attachment or logging into CA PPM. In the past, people needed access to CA PPM. No more.
Any thoughts? Feel free to send us a line in the comments. We'll have a lot of Jaspersoft tips coming to you this year.
*This post was first published on Rego Consulting's Blog.
thanks to you and Atul for the great post, the html tip looks good.
Just a side note: if you are going to email confidential information, encrypt it!
Jaspersoft has the capability to do this, maybe one for a future post