thota_ravi Posted January 27, 2010 Share Posted January 27, 2010 hai all, i am attaching one purchase order reportjust see that report please help with this problemi.e i want if 100 records are there in repoprt i want only 10 records per every pageif bilow 10 records are there i want to print blank speace up to ten recordsi mean i want 10 records for every page even if there is no data ........ Link to comment Share on other sites More sharing options...
lock51 Posted January 28, 2010 Share Posted January 28, 2010 You can create a second query which generates the missing lines - for example if you got 43 lines in the first query then the second one will have 7 lines. Than you can add a subreport after the main one. It will add the missing 7 lines.For the purpose of the query you can have a table with just 10 lines, which are numbered from 1 to 10. Then SELECT * FROM table WHERE lineNum < COUNT. You can parametrize the COUNT.You can also do a UNION right inside the main query and add the missing lines, but then you cah to run your main query twice - second time to get the number of lines - I think it's worse then parametrize.Looks kind of ugly... Link to comment Share on other sites More sharing options...
thota_ravi Posted January 28, 2010 Author Share Posted January 28, 2010 I am using Ireport tool to create jasperreports,i have created the purchse order report,result of the report is added bilow,my problem is i want some gap after printing detail band,because now my report occupied half speace of the page,but i have to cteate a report that occupy the whole page space i mean i want some gap after printing detail band there is any posibility of printing detail bond without data? bilow po.pdf is created by me ,DelivaryChalana form is exact requirement for me,take the reference of the two formshelp methanks i advance Link to comment Share on other sites More sharing options...
thota_ravi Posted February 9, 2010 Author Share Posted February 9, 2010 my dear lack51,please tell me the expression to parameterize this count please .............i am knocking my mind last one week to get this please help me clearly Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now