krishnarhl Posted February 11, 2015 Share Posted February 11, 2015 I have one query. Please help me out. kindly refer the below given example. If I have 20 records with 20 columns, and my page can contain only 10 records with 10 columns at a time. In this case my data is coming like on first page of PDF first 10 records will display with first 10 columns, on second page next 10 records will display with first 10 columns and then remaining columns of first 10 records and so. But I want my output to be like on first page my first 10 records should come with first 10 columns and then on second page next 10 columns of first 10 records should display instead of next records' first 10 columns. Kindly suggest me the solution. Thanks in advance! Link to comment Share on other sites More sharing options...
gert_1 Posted February 13, 2015 Share Posted February 13, 2015 I actually think JasperReport doesn't support this right now. Have you experimented with Crosstables already?I can tell you how to hack this specific situation, but that only works if you know how much records will return (which is not the case I guess). Create tabel, query LIMIT 10 (sort on first 10).Do this again, sort on last 10. Now you have 2 tables which act like you want. And if you are very creative maybe you can use this principle to make a subreport that does this for you, so repeats this step 10 times if you have 100 records. Ps. tagging it with all labels that are not involved (like Google, Hadoop etc.) does not help you. probably sooner the opposit 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