Print number of pages based on field value

[christianhill2010]

Hello,

Can't seem to find anyone else that has tried this on the net.

So I've used iReport 3.0.0 (have to use this version as our java app won't allow anything jaspers created from later versions) to create a pick label.

The report is a SQL report on an oracle server , and basically is a select qty to pick as well as other data like order number and so on.

What the operation have asked for is every label to be for a qty of 1, and another label for each individual product.

For example currently the label could generate order number 12345 for a quantity of 3, what we need is 3 labels for a quantity of 1.

Is this achievable in iReports? Or should it be done through the SQL?

Many thanks in advance!

Christian