zellers

When you uploaded the key, what did you upload it as ? Admin manual says "Add Resource > File > Secure File" To upload an SSH key file to the repository: Log into JasperReports Server as an administrator. Click View > Repository and expand the folder tree. Browse to the folder where you want to save the SSH key. Right-click the folder and select Add Resource > File > Secure File from the context menu. Click Choose File to locate and upload the SSH key file. Enter a name and resource ID for the file. Click Submit to save the file to the repository.

Looks like the binary installer is not available for 8.1 CE. I'd recommend following "Chapter 3 Installing the WAR File for Production" in the Installation Guide for 8.1 (requires manual Apache Tomcat installation) or installing JasperReports® Server Community Edition (v8.0.0) (including bundled Tomcat and PostgreSQL) and then updating to 8.1 by following the "Chapter 3 Installing the WAR File for Production" instructions.

Have a look at this https://community.jaspersoft.com/wiki/how-create-report-uses-remote-json-data-source

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v630/working-font-extensions

iReport 5.6.0 was released 2014-May-29 and iReport in general stopped being supported on December 31, 2015. MySQL 8.0.30 was released 2022-07-26. Nobody is going to 'confirm' anything released 7 years after iReport support ended is supported. Is it likely to work ? Yeah, sure, it's all MySQL Connector/J and JDBC anyway.... Also, ever considered switching to Jaspersoft Studio ?

Please post a (minimal) version of your report as jrxml demonstrating the issue and also a PDF or screenshot showing your result. Otherwise all I can say is: Doesn't happen to me, you're doing it wrong.

I had a look at your jrxml. As I don't have access to your data I am unable to fully reproduce your issue. Looking at your file, my interpretation is that you are getting two "labels" onto one physical label ? Correct ? If this is what is happening, it's due to the size of your detail band. Looking at the report properties, you have correctly set up the page format (252px x 170px / 88.9mm x 60.1mm) but your detail band is not using the entire page height. Jasperreports will try and fit as many 'Detail Bands' onto a page as possible and only start a new page once a page is filled. As your Detail 1 band is currently set to 70px, Jasperreports will "print" two Details per page (2x70px = 140px, which is less than 170px) and then begin a new page as the remains on the first page (170px - 30px = 40px, which is less than 70px) won't fit another 'Detail Band'. I believe the solution is to set the Detail 1 band height to 169px (170px - 1px page margin as configured in Page Setup). <detail> <band height="169" splitType="Stretch"> If this is not it, can you attach a PDF of your output ?

Because you didn't include any additional information like a (minimal) jrxml source or a screenshot showing your problem I can only give you a stupid answer: Your company name is triggering a secret easter egg that results in the barcode being printed twice when mercury is in retrograde ?

Set Height to 0 for the footer cells you don't want. Example: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.1.1 --><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="Blank_A4_Landscape_1" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d670a5fc-7f7c-4af6-91f1-4121b99da744"> <style name="Table" isDefault="true"> <box> <pen lineWidth="0.5"/> </box> </style> <style name="Table_CH" style="Table" mode="Opaque" backcolor="#BFE1FF"/> <subDataset name="Dataset1" uuid="d0afc712-a54d-4808-9c1e-6e0b584bfc7a"> <field name="_THIS" class="java.lang.String"/> </subDataset> <title> <band height="118"> <componentElement> <reportElement x="0" y="0" width="800" height="100" uuid="5b169c2d-2ddc-47f9-a8c2-75aa2967bd47"/> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Dataset1" uuid="7d33a1b3-8fa6-4c55-9224-d6bcbbe8c83d"> <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource(java.util.Arrays.asList(new String[] { "A", "B", "C", "D" }))]]></dataSourceExpression> </datasetRun> <jr:columnGroup width="178" uuid="056c1cbb-44f4-4163-bcb4-ba7d1c4a39bd"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Columns [2]"/> <jr:columnFooter style="Table_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="178" height="30" uuid="353e4ea5-3bb1-4981-a476-5c5dcc4e92be"/> <textElement textAlignment="Center"/> <text><![CDATA[spanned Footer]]></text> </staticText> </jr:columnFooter> <jr:column width="89" uuid="c8cd84ef-9a85-4618-832e-0df32c1e994a"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="89" height="30" uuid="9c6e198d-f50a-477c-a468-df31e74b4e50"/> <text><![CDATA[Foobar]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="0" rowSpan="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </jr:columnFooter> <jr:detailCell style="Table" height="30"> <textField> <reportElement x="0" y="0" width="89" height="30" uuid="775d75f0-ffdd-4bc6-aa68-fa6177c2cc83"/> <textFieldExpression><![CDATA[$F{_THIS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="89" uuid="6dcea097-22ca-43a0-bcc7-c48cf6ea2ae7"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:columnHeader style="Table_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="89" height="30" uuid="a804c276-7841-455f-8503-e1966f751d2d"/> <text><![CDATA[bar]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="0" rowSpan="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </jr:columnFooter> <jr:detailCell style="Table" height="30"> <textField> <reportElement x="0" y="0" width="89" height="30" uuid="b93c246a-3a9b-4695-96d8-5eecbcbf9cde"/> <textFieldExpression><![CDATA["bar"]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:columnGroup> <jr:column width="89" uuid="04cd569d-42ca-46e3-a6b7-005b3b3900ba"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:columnHeader style="Table_CH" height="30" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="89" height="30" uuid="6136ef01-5687-41e9-8973-441f674c51c5"/> <text><![CDATA[bag]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30" rowSpan="2"> <staticText> <reportElement x="0" y="0" width="89" height="30" uuid="62306c92-daf8-4ea4-9cfc-62381e243b39"/> <text><![CDATA[bag ?]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table" height="30"> <textField> <reportElement x="0" y="0" width="89" height="30" uuid="feaae1d2-9505-4bf3-a856-ee6e3ea96764"/> <textFieldExpression><![CDATA["bag"]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </title></jasperReport>[/code]

Probably not possible. Watermarks in Excel are usually done by placing images in the Header and here's a old issue from someone else wanting to do the same that closed as 'Won't fix' https://community.jaspersoft.com/jasperreports-library/issues/8601

I think what you are trying to create requires two different page sizes in one report which as far as I know is not possible.

"Print When" should to what you're after if you combine it with "Remove Line When Blank" except you need to make sure that there are no other elements occupying the same horizontal space, otherwise "Remove Line When Blank" won't work.

Try adding <property name="net.sf.jasperreports.export.xls.create.custom.palette" value="true"/> to your report. http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.create.custom.palette

Add a variable with calculation set to "System", Expression: $V{Variable_1} != null ? $V{Variable_1} + "," + $F{questionId} : $F{questionId}.toString()[/code]And Evaluation time on the Text Field to "Report". Demo attached.

$F{Field1}.replaceAll("<[^>]*>","")[/code]This should strip anything that looks like a html tag from your data.