topic Re: Iterate Data from csv file in Jasper report in Talend Studio

Iterate Data from csv file in Jasper report

Gadje — Tue, 08 Dec 2020 16:22:02 GMT

Hi everybody,

i need to iterate data from csv file in a Jasper report but i only get one line and not all lines i should get.

That's my job structure :

I tried to iterate data from file [1] in tMap [2] as sho below :

I made join on "NOBON" [3] and i filtered "CODAR" [1] as show in expression [2].

But my output PDF is only withe one line [1] as show below :

I would like to get all the lines that concerne the voucher N° 562730 [2] but those of other Gestionnaires than "CD" [3], in place [1].

I dont know to iterate.

Thanks in advance.

Re: Iterate Data from csv file in Jasper report

Anonymous — Wed, 09 Dec 2020 07:12:08 GMT

Can you share a screenshot of the basic settings of tJasperOutput component? You are iterating the input rows, if you set the fixed file name/stream, the output file will be override for each iteration. To include all lines, try to add a tUnite component before tJasperOutput.

Regards

Shong

Re: Iterate Data from csv file in Jasper report

Gadje — Wed, 09 Dec 2020 07:31:26 GMT

Hi Shong and thanks for reply,

Here are my basics settings for tJasperOutput component :

And here is my report structure :

I tried to add tUnit instead of the tMap [2] on my first screenshot but it didn"t work.

I'll retry one more time.

Re: Iterate Data from csv file in Jasper report

Anonymous — Wed, 09 Dec 2020 07:58:46 GMT

from your screenshot, I see you define a dynamic file name, that means you will generate different report for each iteration.

What are you expected result? Only one file to contain all lines?

Re: Iterate Data from csv file in Jasper report

Gadje — Wed, 09 Dec 2020 08:30:18 GMT

I generate one file for eache manager, for CD manager -> OpenWeb_CD.pdf, for CP manager -> OpenWeb_CP.pdf, ...

Instead one line at [1] on the third screenshot i need all the lines that concerne the voucher N° 562730 [2] and the other managers than "CD" [3] that are in the CSV file "allArtListIn"

Here is a sample of my csv file :

In this example i need to get all the lines of the voucher N° 562730 and that are not for CD manager, all the CP manager lines, not only one line.

Re: Iterate Data from csv file in Jasper report

Anonymous — Wed, 09 Dec 2020 08:50:13 GMT

Thanks for your detailed explanation, it is clear now. I am not sure the problem comes from the job design or the report jrxml design. Can you try to do the following testing:

1 Use tFixedFlowInput to generate to multiple lines and link it to tJasperOutput directly, check if the job generates the report with multiple lines.

2 Use tFileOutputDelimited instead of tJasperOutput to generate a text file, check if the job generates one file for each manager with multiple lines.

Regards

Shong

Re: Iterate Data from csv file in Jasper report

Gadje — Wed, 09 Dec 2020 09:33:40 GMT

Ok i try to do what you said and i return you the results.