topic Create for each iteration report file with tJasperReportExec, in Talend Studio

Create for each iteration report file with tJasperReportExec,

pawe84 — Wed, 03 Apr 2024 11:33:00 GMT

Hi everyone,

I have a sql query which will give invoice numbers as result.

How I can use iterate with tJasperReportExec so that I'll get for each invoice number a new pdf file?

I am using the jrxml file which I created in Jasper Studio.

At this file is another sql query stored.

Do I have to edit the jrxml file and have to put my Talend context variable inside so that tJasperReportExec can iterate it?

Example modification to jrxml, sql query part

This would be my talend job setup (see attched screenshot).

Thanks in advance for any hints.

Re: Create for each iteration report file with tJasperReportExec,

pawe84 — Thu, 04 Apr 2024 15:16:18 GMT

I solved this issue. You have to create parameters in your report designer.

Re: Create for each iteration report file with tJasperReportExec,

jlolling — Thu, 11 Apr 2024 08:18:57 GMT

jrxml query also allows not only one value as parameter, you can also handover a list as value for a parameter which will converted into a "my_field in (....)" expression.

Example for an sql expression in jasper reports:

select * from my_table where $X{IN, colname, parameter_name}

This works also if your list is empty and will not disrupts your query.