Jump to content
Changes to the Jaspersoft community edition download ×

Printing labels starting at label x


a.nef

Recommended Posts

  • 3 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...