split pdf in multiple files

Gadje — Thu, 15 Oct 2020 08:33:59 GMT

Hi everybody,

I tried to generate multiple PDF files grouped by bill number but i didn't find how to do.

I use a tJasperOutput componant for generate my PDF and i would like to be able to obtain a PDF file for each bill number.

I didn't see anything that allow me to do it in iReport.

Is there a way to do it ?

I give you a my job structure :

A sample of what i would like to obtain :

Thanks in advance for any helping.

Re: split pdf in multiple files

Gadje — Thu, 15 Oct 2020 13:14:31 GMT

i did some progresses, by changing my job's structure like that :

As show above, i catch well the data i need until the tAS400Input_1 componant.

But in this componant's SQL query i don't know how to test equality between bills number that come from NAFAC componant.

I tried different solutions for testing equality between bills number but nothing worked.

Here's my SQL query from tAS400Input_1 componant :

"SELECT

A.NOCLI AS CODE_CLIENT,

A.DFACJ||'/'||A.DFACM||'/'||A.DFACA AS DATE_FACTURE,

A.NAFAC AS NAFAC,

A.ENF63 AS CIVILITE,

A.NOMSB AS NOM_CLIENT,

A.AD1SB AS ADRESSE_1,

A.AD2SB AS ADRESSE_2,

A.RUESB AS RUE,

A.CPOSB AS CODE_POSTAL,

A.BUDSB AS VILLE,

A.ECHSB AS ECHEANCE,

SUBSTRING(TRIM(A.NAFAC), 5, 6) AS NUM_FACTURE,

A.AGENC AS AGENCE,

A.ENFHASH AS HASHCODE,

A.ENF78 AS ENF78,

B.NOBON AS NUM_BON,

A.ENF31 AS MONNAIE_FACTURE,

A.TTVA1 AS TAUX_TVA,

A.MTFA1 AS MONTANT_TTC,

A.MTVA1 AS MONTANT_TVA,

B.PRINE AS PRIX_NET_UNIT,

B.MONHT AS MONTANT_HT,

A.MTBA6 AS MONTANT_HT_BASE,

B.DTBOJ||'/'||B.DTBOM||'/'||B.DTBOA AS DATE_BON,

B.DTLIJ||'/'||B.DTLIM||'/'||B.DTLIA AS DATE_LIVRAISON,

B.CODAR AS CODE_ARTICLE,

B.DS1DB AS DESIGNATION,

B.LUNTA AS UNITE,

B.QTTAR AS QUANTITE,

B.TVADB AS CODE_TVA,

A.NATB1 AS LIB_NATB1,

A.NATB2 AS LIB_NATB2,

A.NATB3 AS LIB_NATB3,

A.NATB4 AS LIB_NATB4,

A.NATB5 AS LIB_NATB5,

A.MTBA1 AS MONT_MTBA1,

A.MTBA2 AS MONT_MTBA2,

A.MTBA3 AS MONT_MTBA3,

A.MTBA4 AS MONT_MTBA4,

A.MTBA5 AS MONT_MTBA5,

A.TTVA1 AS TVA_ATTVA1,

A.TTVA2 AS TVA_ATTVA2,

A.TTVA3 AS TVA_ATTVA3,

A.TTVA4 AS TVA_ATTVA4,

A.TTVA5 AS TVA_ATTVA5,

A.MTVA1 AS MONT_TVA_MTVA1,

A.MTVA2 AS MONT_TVA_MTVA2,

A.MTVA3 AS MONT_TVA_MTVA3,

A.MTVA4 AS MONT_TVA_MTVA4,

A.MTVA5 AS MONT_TVA_MTVA5,

A.MTFA1 AS TOTAL_MTFA1,

A.MTFA2 AS TOTAL_MTFA2,

A.MTFA3 AS TOTAL_MTFA3,

A.MTFA4 AS TOTAL_MTFA4,

A.MTFA5 AS TOTAL_MTFA5

FROM AENTFAP1 A INNER JOIN ADETFAP1 B ON A.NAFAC=B.NAFAC

WHERE A.NAFAC = '"+((String)globalMap.get("iterate2.NAFAC"))+"'

Is there anybody who knows how to do ? Please.

Re: split pdf in multiple files

Gadje — Thu, 15 Oct 2020 13:32:48 GMT

It's ok, i found how to do. I just needed add another tFlowToIterate componant between NAFAC and tMap_1 componants.

topic Re: split pdf in multiple files in Talend Studio

split pdf in multiple files

Re: split pdf in multiple files

Re: split pdf in multiple files