How to get barcodes in seq, two next to each other. Jasper iReport

Question

I am developing barcode shortcuts in Jasper iReport. These are 2 tags next to each other. At the moment, it looks like this for me:

As you can see its the same barcode numbers next to each other. I want it to look like this:

So, instead of two identical barcode numbers next to each other, I need unique ones. Not sure how to handle this. Can anyone help?

Here is the code I'm using:

select to_char(pallet_id_no_seq.nextval) as barcode from dual connect by level <= $p{quantity} 

As you see here above, the request has a parameter that I can use to select the number of barcodes that I want to print in Band Detail of Jasper.

Answer 1

Try the following:

  SELECT to_char(pallet_id_no_seq.nextval) as barcode FROM ( SELECT * FROM DUAL CONNECT BY LEVEL <= $P{quantity} ) 

In iReport: Right-click the name of your report in the Report Inspector and select "Page Format." Change the number of columns to 2 and save. Right-click the report and select Properties. Here you may need to change the print order to horizontal - check it and see how it looks.