Jump to content

How Add few Blank lines to jasper report before filling the database details?


adasi

Recommended Posts

I am building a Banking System..I want to print a PassBook....Then  ,   When i  put the last line number of the PassBook,

I want to be printed the rest of the account transaction details that line number>line number....

So I want to  add some Blank Lines   Before filling the database details

How can i do it?

Plese help me..

 

 



Post Edited by adasi at 08/05/2011 08:38
Link to comment
Share on other sites

  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Hi,

You could acquire some additional blank rows with an appropriate query. For instance, if you need 5 blank rows, a query like below might be the solution. If you are not using MySQL, then use the equivalent syntax of 'limit 5'.

Hope this helps,

sanda

 

Code:
select null as date_balance, null as dr, null as cr from my_database limit 5union allselect date_balance, dr, cr from my_database
Link to comment
Share on other sites

  • 7 years later...

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...