jack w. Posted November 17, 2017 Share Posted November 17, 2017 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-excelStill, 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 Link to comment Share on other sites More sharing options...
Solution jack w. Posted November 17, 2017 Author Solution Share Posted November 17, 2017 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-jasperreports-serverI'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. Link to comment Share on other sites More sharing options...
djohnson53 Posted November 20, 2017 Share Posted November 20, 2017 Not surprising. Working to make your quesiton clear to others can also make it clearer to yourself. 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