Pentaho BI Server: Send report by email

I will try to explain How to send a report published in pentaho by email (without dying in the attempt).

First of all, and one of the most important at the moment, is that if we have a report like: File Name With Spaces.prtp, we will need a FileWithoutSpaces.prpt copy published.

1. In Process Actions add Report-Pentaho Report. Define Name, Report Specification (click the browse button to select your report) , Report Format and Output Report Name: Report in this example. We must select the report without spaces in the file name because if not, the Process Inputs/Resources/report-definition it is not going to be created

2. Add a new Process Output and select the report name (Report in this case).

3. Then select the process output (Report in this case) and add new Output destination.

4.Go to XML section an change "response" for "contentrepo":

<contentrepo>Report<contentrepo>

5. In the Process Actions, add new action: Send to - E-Mail, and configure Name, To, From, Subject and Text Message fields.

6. In the Attachments section Add new one, and select "Report" in this case. Then change the field "Name" to add a file extension according with the Report Format defined in step 1.

Now you can test the xaction. Finally, we only need to change the report file name to send the desired "Report File Name With Spaces.prpt" in the XML section, in the Resources section between the words: Location.

Enjoy.