I've just started learning to work with JasperServer and uploaded my report. When I export my report to .xls from my local directory, everything works just fine. The problem is, when I want to generate the .xls report from the server, it deletes cell borders from my report. Why is this happening? I've found this property:
<property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
under this link:
https://community.jaspersoft.com/wiki/tips-exporting-excel
Still, it's not working. Maybe I'm putting it in a wrong spot? I don't think it matters though, but here is the part of my XML code where I put the above property:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.4.3.final using JasperReports Library version 6.4.3 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="81 test" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isIgnorePagination="true" uuid="05b3d052-31ff-4f8e-a52a-7fffa81abc28">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="BazadanychKZ.xml"/>
<property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/"/>
<property name="ireport.jasperserver.user" value="jasperadmin"/>
<property name="ireport.jasperserver.report.resource" value="/reports/10_RaportZestawienie_files/main_jrxml"/>
<property name="ireport.jasperserver.reportUnit" value="/reports/10_RaportZestawienie"/>
<property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
<style name="Crosstab_CH" mode="Opaque" backcolor="#D2691E">
<box>
And also, heres a screenshot with the looks of my report after exporting to .xls using the server:
Thanks for help
1 Answer:
This is ridiculous, how I try to do something for an hour, post the question and then get the solution myself. This link shows the list of parameters, but as I'm new to the Jasper, I make stupid mistakes.
https://community.jaspersoft.com/wiki/xls-export-parameters-jasperreport...
I've tried to put the "ignore cell border" property this way:
<property name="ignoreCellBorder" value="true"/>
I don't know why the examples are written this way under the above link, but when I put this:
<property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false"/>
It started working.
Not surprising. Working to make your quesiton clear to others can also make it clearer to yourself.