Printing labels starting at label x

[a.nef]

Hi

Taking up a rather old question (https://community.jaspersoft.com/questions/522289/printing-labels-how-skip-first-x-labels): Is there a way to tell jasperreports to start printing labels at a given position?

[bsvorinic]

We use Oracle and the way we solve this is to add some "blanc"/"empty" records at the beginning of  result dataset, something like:

SELECT
    ROWNUM * - 1 AS ord,
    '' AS text1,
    '' AS text2
  FROM
    dba_objects
 WHERE
    ROWNUM < 10
UNION
SELECT
    ROWNUM AS ord,
    'some text1' AS text1,
    'some text2' AS text2
  FROM
    dual
 ORDER BY
    1;

You can than use JasperReports parameter to define number of blank rows needed (replace " ROWNUM < 10" with " ROWNUM < $P{NUMBER_OF_BLANKS}" or whatever you want to call this parameter)...

 

HTH,

Bruno