Add Blank Lines to Invoice.pdf

[sididesril]

I have created an invoice in the form of a PDF file using automation. The problem is that I want 10 lines in one report sheet. If the invoice results only have 2 lines then I want the other 8 lines in the form of empty lines only so that the result remains 10 lines. After that, the sub total will appear. what are the steps to make it?

[AleksiAlkio]

Are you using a Start: & End expression to bring the lines? 

[sididesril]

Yes, I'm using a star:&End.

In column "No", I Write : <<Start: [Related DBJADIs By NO PACKING]>><<COUNT(SELECT(dbjadi[ID],AND([NO PACKING]=[NO PACKING],[_ROWNUMBER]<=[_THISROW-1].[_ROWNUMBER])))>>. In column "Packing", I Write : <<[QTYPACKING]>><<End>>

[AleksiAlkio]

Little bit complex but doable with many ways, for example something like this. Though if you are using the same table as this sample, you ned to have min 10 rows in the child table. Another way is to use totally different table that you know there are always min 10 rows.

[Suvrutt_Gurjar]

Nice one Aleksi.

[Koichi_Tsuji]

@AleksiAlkio 

I like this trick.  Smart and efficient.

thanks .

[sididesril]

THIS FORMULA WORKS BUT THE CHILD TABLE ONLY CONTAINS 5 ROWS SO ONLY 5 ROWS APPEAR. CAN YOU EXPLAIN OTHER EXAMPLES OF FORMULA TAKEN FROM DIFFERENT TABLES AS YOU MENTIONED?

[AleksiAlkio]

Need to find a sample.. little bit more complex.

[sididesril · Accepted solution]

Thank you Aleksi, the formula you have provided is working and I think it is enough for me

[AleksiAlkio]

Okay good 🙂