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]

Okay the requirement is this. I have 4 email ids, abc@xxx.com, def@xxx.com, ghi@xxx.com and jkl@xxx.com

And the files outputted by tjasperreportexec is report_abc.xls, report_def.xls,report_ghi.xls, report_jkl.xls

So, for abc@xxx.com I must pick report_abc.xls , for def@xxx.com I must pick  report_def.xls etc

[fdenis]

dose it work with a fix file

[Anonymous]

Yes, it works for a fix file

[fdenis]

try with a copy of your reports and dynamic file name

[Anonymous]

ahh.. I did not get you. Can you please elaborate?

[fdenis]

dynamics name as attachment:
C:/Copy_Of_Users/report_out_"+ ((Long)globalMap.get("row1.id"))+".xls"

[Anonymous]

fdenis, I have used this code "C:/Users/report_out_"+ ((Long)globalMap.get("row1.id"))+".xls" and its still the same error

[fdenis]

add tlog on row1 (check name of file générated)

I'm not on your desk!

[Anonymous]

fdenis, apologies for your time on a simple issue

I have checked  and the file name that is generated is correct and the file is present at the location mentioned

C:/Users/report_out_4.xls. This is the file name generated

[fdenis]

try crate report first and to iterate a second time after a onSubjodOk to send emails