Jasper report outputs as email attachments (tJasperReportExec)

[Anonymous]

Hi , 

I want send jasper report outputs as email attachments

I am using tjasperReportExec. The job looks as shown below. If I have to send the report output as an attachment to multiple email addresses, how do I do it? As of now it stores the output in a directory. Also, if I have 10 different email and the report output differs for each email, how do I pick the relevant attachment and send it in tsendmail component? 

Also what is the difference between tjasperoutputexec, tjasperreportexec and tjasperoutput?

Any ideas on this will be of great help

Thanks

Rathi

[Anonymous · Accepted solution]

Hi fdenis, I figured it out

I had to use ((String)globalMap.get("tJasperReportExec_1_OUTPUT_FILE")) this in the attachment section of tsendmail.

Now, I have another problem. The job runs fine on windows, when I run it on linux, I get the error 

java.lang.Exception: No Connection or JRDataSource available to fill the report

But, I have used to tmysqlconnection to populate the connection details

Any help on this please?

[fdenis]

it's an other topic.
just think about path they are with with \ only on windows
try to use // .
check file access too.
good luck

[Anonymous]

hi fdenis,

Thank you for your support. I will start the discussion for being unable to run on linux machine as another topic