jcking Posted July 20, 2017 Share Posted July 20, 2017 Hi,I am trying to add a crosstab to the end of a table I created because I need to be able to expand the table columns based on the value of a certain field. I plan to open this in excel since it may end up having quite a few columns. Is this possible?Thanks, Link to comment Share on other sites More sharing options...
Friendly User Posted July 25, 2017 Share Posted July 25, 2017 You will need to use two separate report objects in the band (summary band I guess) - table and crosstab. Both can use same data set or you can use different data sets. When exporting to Excel though I'd recommend to put them both on different sheets as crosstab columns and table columns can have different size and that can cause the exporter to merge a lot of cells and generally give you a messy output. To force a page break add a break element between Table and Crosstab elements. To force Excel exporter to print each page on it's own sheet use this property in the report:http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.one.page.per.sheet Link to comment Share on other sites More sharing options...
jcking Posted July 25, 2017 Author Share Posted July 25, 2017 Thank You! 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