Tom C

<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="BlahBlahBlah" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" uuid="bbcb539b-1bc4-4aae-b4e0-xx123456dxyz">

FYI....... https://community.jaspersoft.com/wiki/tibco-jasperreports-server-780-installation-using-windows-binary-installer-might-have-problem

1) You need to make perfect alignment for all fields in vertical direction; 2) Do not overlap fields.

With all due respect, the sample is not a fake report but the content of a "correct"/working/tested report template jrxml file. You just need a (any) PostgreSQL data source to test run it in Jaspersoft Studio (JSS) and produce the result as shown in my posting. The intention here is to show users how this can be accomplished using JasperReports engine (JRL) to meet your particular requirement. Please refer to Jaspoersoft Studio User Guide to learn how the product is supposed to work in general. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/getting-started-jaspersoft-studio You can also review many of Jaspersoft studio tutorial videos from the user community on YouTube to get yourself familiar with the features and capabilities of our product. Hope this provides enough guidance level information and helps to steer you into the right direction.

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/working-charts

JasperReports Server commercial edition available features: – Ad Hoc Designer– Analysis/OLAP– Audit– Dashboard– Fusion Chart– Multitenancy

This looks like a defect when JasperReports engine (JRL) calculates the remaining space on a page involving the RemoveLineWhenBlank property. The work around is to put your image in the second detail band and use band print when condition to determine whether the band will be called to display the image. This will avoid relying on RemoveLineWhenBlank property to shrink the band height causing the miscalculation.

Here is the video.

You can use a report list element to lay out cities horizontally. See sample report: Report data: Simple report layout: Report output: Report design template (JRXML file): <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.9.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928 --><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="demo-20210603" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="3e4d9a69-d315-4243-ad30-8f6cef2f29ce"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JRSrepo"/> <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="338"/> <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="651"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="473"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="526"/> <subDataset name="Dataset1" uuid="fc1c4348-9a3a-42b2-a750-597914f2db75"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JRSrepo"/> <parameter name="name" class="java.lang.String"> <defaultValueExpression><![CDATA["Mr A"]]></defaultValueExpression> </parameter> <queryString language="SQL"> <![CDATA[select city from (select * from (values ('Mr A','City 1'),('Mr A','City 2'),('Mr A','City 3'),('Mr A','City 4'),('Mr A','City 5'),('Mr A','City 6'),('Mr B','City 1'),('Mr B','City 2'),('Mr B','City 3')) as t (Name,city) order by 1, 2) as reportdatawhere name = $P{name} order by city]]> </queryString> <field name="city" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="city"/> <property name="com.jaspersoft.studio.field.label" value="city"/> </field> </subDataset> <queryString language="SQL"> <![CDATA[select name from (select * from (values ('Mr A','City 1'),('Mr A','City 2'),('Mr A','City 3'),('Mr A','City 4'),('Mr A','City 5'),('Mr A','City 6'),('Mr B','City 1'),('Mr B','City 2'),('Mr B','City 3')) as t (Name,city) order by 1, 2) as reportdatagroup by name]]> </queryString> <field name="name" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="name"/> <property name="com.jaspersoft.studio.field.label" value="name"/> </field> <detail> <band height="30" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="100" height="30" uuid="c18292b9-fff5-4867-b0c6-2d10f095338e"/> <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> </textField> <componentElement> <reportElement x="100" y="0" width="400" height="30" uuid="103320d3-4fd6-4d03-b189-74d441bb2e3f"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.CONTENTS.width" value="px"/> </reportElement> <jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Horizontal"> <datasetRun subDataset="Dataset1" uuid="4d4c98c6-5416-4786-a6d6-2b0fcc4a0926"> <datasetParameter name="name"> <datasetParameterExpression><![CDATA[$F{name}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:listContents height="30" width="100"> <textField> <reportElement x="0" y="0" width="100" height="30" uuid="4a917ea1-6b17-4ccc-a722-6c0a9b1e3dae"/> <textFieldExpression><![CDATA[$F{city}]]></textFieldExpression> </textField> </jr:listContents> </jr:list> </componentElement> </band> </detail></jasperReport>

Try "remove line when blank" setting for the image properties.

The current release version for the JRS community edition is 7.8. The 7.9 version is primarily for JRIO At-Scale release which does not have a lot of JRS features in the open source (community) version. We will have a new JRS product release for both editions (commercial and community) in this fall of 2021.

You can create a group based on $F{ordnum} but do not need to add group header and group footer (heights are zero for those bands). Just make sure to select "Start New Page" for the group header property. The screenshots are from a Jaspersoft Studio product (JSS) but this feature should work for iReport as well (iReport is no longer supported by Tibco Jaspersoft). Case in point, you do not need the group header to be visible to trigger the new page class method in JasperReports engine (JRL) when rendering a report output. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.9.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928 --><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="demo4brandon" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b51c190a-e11f-4fdc-9f2a-937ed1d5efcd"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sugarcrm"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <queryString> <![CDATA[select orderid||'' as ordnum from orders limit 3]]> </queryString> <field name="ordnum" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="ordnum"/> <property name="com.jaspersoft.studio.field.label" value="ordnum"/> </field> <group name="Order" isStartNewPage="true"> <groupExpression><![CDATA[$F{ordnum}]]></groupExpression> </group> <columnHeader> <band height="35" splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <staticText> <reportElement x="0" y="0" width="180" height="30" uuid="1884c8ac-0b3c-4bdf-9eb0-741b527be444"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="644491ef-a4e2-4f9b-81ce-54b081f3728e"/> </reportElement> <text><![CDATA[ordnum]]></text> </staticText> </band> </columnHeader> <detail> <band height="300" splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <textField> <reportElement x="0" y="0" width="180" height="30" uuid="33a37ffd-051f-4383-a557-4bbfbcab3059"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="644491ef-a4e2-4f9b-81ce-54b081f3728e"/> </reportElement> <textFieldExpression><![CDATA[$F{ordnum}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="80" y="40" width="482" height="250" forecolor="#339900" backcolor="#FFFF33" uuid="882de33a-5705-46c4-a5f9-213b31a83246"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="26"/> </textElement> <text><![CDATA[Order Details]]></text> </staticText> </band> </detail></jasperReport>

Your report template looks strange. Refer to the green colored element - Are you using an image to display report content? How are those parameters getting into the template? Are you superimposing them on top of the image? Refer to orange colored element - What we need to make sure is the input control unit id matches the report parameter name in the template (you need to expand the parameter list and see the names).

Check the Page and Size Handlings settings in printer properties and experiment with different one to see if the label can be correctly aligned in Zebra ZT230 print.

Custom calculations during report generation - if the calculation is simple, you can use in line Java expression and ternary operator in a report variable to meet your requirement. The tricky part is the evaluation time if your calculation is iteration specific across several rows. In such a case, scriptlet can help but you still need to put the call in the correct report location to get the information that you need. You can also rely on sub components (sub report, list, etc.) to conduct the calculation to avoid coding and implementation hassle with the scriptlet approach. In summary, it is all depending upon what you need to determine the simplest approach to meet your reporting requirement.

For week range report - You need to break your data into five items based on the date range then display them horizontally using a list element. Something like: 1) Main report query gives the unique work/compaings record 2) Use list element to get the details of those work/compaings record into five rows then lay them out horizontally. The subdataset feeding the list could be something like: with workdata as (select * from your report_table where work_compaings = $P{work_compaigns})select 1 as week, * from workdata where {week is in week 1 range}union allselect 2 as week, * from workdata where {week is in week 2 range}union allselect 3 as week, * from workdata where {week is in week 3 range}union allselect 4 as week, * from workdata where {week is in week 4 range}union allselect 5 as week, * from workdata where {week is in week 5 range}[/code]

One data source and 3 queries - Assuming those three queries produce identicle meta data result set, you can combine them together to product one result set: query1unionquery2unionquery3[/code]