marciopd Posted July 26, 2010 Share Posted July 26, 2010 Guys,I have a report which columns are dynamic and the number of columns can be big enough so they don't fit all in one page. I though the best way to implement this was using crosstabs, because they deal with column breaks automatically.The problem with crosstabs is that if the data being rendered is a really big datatable, then the crosstab will eat all memory and crash the report no matter if you're using a virtualizer. What's the best solution for this situation? (dynamic columns + page column breaks + lots of data)Thanks Link to comment Share on other sites More sharing options...
lucianc Posted July 27, 2010 Share Posted July 27, 2010 I don't think there are any solutions for your requirements. Column breaks are only implemented in crosstabs, which work with in-memory data.It's not very clear what dynamic columns means. Do you have any details on that? How are the columns defined, and how is the data fed to the report?Regards,Lucian Link to comment Share on other sites More sharing options...
lucianc Posted July 27, 2010 Share Posted July 27, 2010 PS: Also take a look at http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4368 to see if it's the same requirement as yours. Link to comment Share on other sites More sharing options...
marciopd Posted July 27, 2010 Author Share Posted July 27, 2010 By dynamic columns I mean that I have to do a query in order to know which columns and data must be printed in the report. The data is fed depending on the columns. Link to comment Share on other sites More sharing options...
marciopd Posted July 27, 2010 Author Share Posted July 27, 2010 About http://jasperforge.org/projects/jasperreports/tracker/view.php?id=4368 :yes, I think that's what I was looking for.. I way to tell jasper that it must put what doesn't fit in one page into another. already voted :D thx a lot Link to comment Share on other sites More sharing options...
teodord Posted August 4, 2010 Share Posted August 4, 2010 Hi, Please don't contribute only by voting. Your feedback is needed on that tracker where a question was asked about how breaking of columns should actually work.Without valuable feedback, the feature will never be implemented, regardless of how many votes it received. Thanks,Teodor Link to comment Share on other sites More sharing options...
shruti_1 Posted November 20, 2013 Share Posted November 20, 2013 Hi teodord, I am not able to access the url link above. What was the proposed solution to many columns in the report problem? Link to comment Share on other sites More sharing options...
2340patel Posted June 7, 2019 Share Posted June 7, 2019 We have similar requirement and want to understand how can large report output possible using crosstab. We have posted a query on stack overflow too. https://stackoverflow.com/questions/56484245/why-do-jasperreport-with-crosstab-output-to-excel-fails-with-large-number-of-colAppreciate if someone pls guide on same. ThanksAnjana 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