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.

Transparent needs to be off on the conditional style for the background colour to show.

You know, you could rename the variables to something shorter ? (And every instance of where the variable has been used gets automatically updated to the new name)

<propertyExpression name="net.sf.jasperreports.export.xls.sheet.name"> <![CDATA[$F{FieldName}]]></propertyExpression> Also in the wiki: Excel Export: Dynamically set sheet names

I'd say the Format Pattern dialog is a bit less than ideal in communication what "Decimal places" means.... I believe the value for "Decimal places" is the minimum of decimal places, irrespective of how many decimal places the data contains. i.e. if you set "Decimal places" to 3 the value 12.7 gets formatted as 12.700 and the value 3.1415926 results in 3.142. In your situation you can achieve the desired result by manually changing the pattern from #,##0.0##;(-#,##0.0##) to #,##0.0;(-#,##0.0) which will result in 3.1415926 -> 3.1 and 3 -> 3.0 If you'd like whole numbers to display without the .0 the pattern would be #,##0.#;(-#,##0.#) (a 0 is a "must print a value" placeholder, # is a "if there is information" placeholder)

If you're stuck with the Community edition, you can always do a dirty and draw a circle over a pie chart..... <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.17.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="donut" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="727dab2e-454f-40b0-8cef-f5e84909713b"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/> <queryString language="SQL"> <![CDATA[sELECT "ADDRESS"."CITY", COUNT("ADDRESS"."CITY") FROM ADDRESS GROUP BY CITY]]> </queryString> <field name="CITY" class="java.lang.String"/> <field name="C2" class="java.lang.Long"/> <title> <band height="570" splitType="Stretch"> <pieChart> <chart evaluationTime="Report"> <reportElement x="0" y="0" width="500" height="500" uuid="c66c6d48-9128-4d09-9e15-ae1e97130fde"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <pieDataset> <dataset resetType="Report"/> <keyExpression><![CDATA[$F{CITY}]]></keyExpression> <valueExpression><![CDATA[$F{C2}]]></valueExpression> </pieDataset> <piePlot> <plot/> <itemLabel/> </piePlot> </pieChart> <ellipse> <reportElement x="175" y="152" width="150" height="150" uuid="4878fbf0-0c68-4d81-8945-ca8900fc2b50"/> </ellipse> </band> </title></jasperReport>[/code]

I've previously ecountered a similar issue with non standard characters in subreports. I've managed to get around it by encoding the characters as HTML entities and treating the text field as html pre formatted. Probably a bit of a nightmare in your situation but possibly better than nothing. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.17.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_2" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="89dcc541-e989-48bb-bfb0-bbdca713f702"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <queryString> <![CDATA[]]> </queryString> <title> <band height="341" splitType="Stretch"> <textField isStretchWithOverflow="true"> <reportElement x="40" y="20" width="420" height="290" uuid="8936e074-380c-4cbd-96a1-22c389063f71"/> <textElement markup="html"> <font size="26"/> </textElement> <textFieldExpression><![CDATA["• <br> 嗰 <br> 個"]]></textFieldExpression> </textField> </band> </title></jasperReport>

Page width is defined in the really long <jasperReport>[/code] tag as pageWidth="500" pageHeight="842"[/code]Usually found on line 3.

As far as I can see from the release notes Jaspersoft Studio version 6.15.0 (2020-10-07) onwards ships with AdoptOpenJDK JRE. https://sourceforge.net/projects/jasperstudio/files/JaspersoftStudio-6.15.0/README.txt/download

Here is some red hot garbage that might do the trick: $V{Variable_1}.substring($V{Variable_1}.indexOf(""vin":") + new String(""vin":").length() + 1).substring(0,$V{Variable_1}.substring($V{Variable_1}.indexOf(""vin":") + new String(""vin":").length() + 1).indexOf("",""))[/code]This should return the value for "vin" for data stored in $V{Variable_1}. Yes. I know. This is disgusting. ;-) Update 2022: I'm stupid and this is the proper way to do it: new org.json.JSONObject($V{JSON}).get("vin").toString()[/code]

I think you used my expression as "Print When" while it's meant to be a Text Field expression with "Blank When NULL" checked.