robsil Posted September 28, 2018 Share Posted September 28, 2018 Does anyone have any ideas on why my report would show data just fine on screen in the JasperServer browser and when I export to PDF, but when I export to Excel there is the header row and blank text in each of the data rows? It looks like the rows are there... just no text in any of the rows (e.g. the row height is the height it would be in the report, for each of the rows that I see in the PDF). Just seems like the text is not exported into the table. Link to comment Share on other sites More sharing options...
hozawa Posted September 30, 2018 Share Posted September 30, 2018 I think that may be cause by wrong data type or field width. Try setting the following properties.http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.detect.cell.typehttp://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.shrink.to.fit Link to comment Share on other sites More sharing options...
robsil Posted October 1, 2018 Author Share Posted October 1, 2018 Thanks Hozawa... do I apply those on the text field or the column? Also I should mention that the cells are in a group footer and not showing... I have hidden my detail band by setting height to 0. if I move the fields into the detail band they seem to show (e.g. delete the group footer row). I also set my background color for the group footer cells to be red and the detail cells to be blue and export to excel. It seems like my red group footer cells do not show at all, but the blue detail bands do show. Is there an issue with exporting to excel with only a group footer showing and not a detail band? 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