[Direct printing multiple jasper reports at once]

Hello anhttn1909,

please consider including the 3 reports in a report book 

 

[Missing first row while loading table from json datasource]

Hello Bharathwajan,

please find in attachment a table that is using the json as datasource. I have only modified the second row to show that is a different record.

The Dataset1 used by the table is holding the link with the Json_data_adapter.jrdax that uses the Json file.

 

 

json_table.zip

[Login in JasperStudio 6.21.1]

Hello,

 

UnknownHostException typically indicates that there was a DNS resolution failure.

Please verify your DNS settings and check again

[Hi I am looking the help for my issue below:]

Hello, did you have selected the option for the Text Fields "Blank when null" for this specific report? 

[Jasper Server 8.0.0 runtime_dependencies folder missing]

Hello raja,

 

for version 8, repository.search.actions.js is in jasperserver-ui\ce\jrs-ui\src\repository folder.

 jobModel.js is in jasperserver-ui\ce\jrs-ui\src\scheduler\model

 

Also please refer to this Dr Jaspersoft session to know how to apply UI customizations since version 8 by using Webpack 

 

[Overflowing text in detail band missing, cut off by page header/footer.]

Hello,

 

please look at this example I have created staring from your. You can see how the text field in detail band is stretching to correctly adapt to the hardcoded long text.

 

Hope it helps

OverflowIssue.jrxml

[Overflowing text in detail band missing, cut off by page header/footer.]

Hello joox,

 

 

would it be possible for you to attach the jrxml for me to have a look?

[Publish message to queue on certain events (like report generation failed)]

Hello Ravi, 

I think you can achieve something similar by customizing the ReportExecutionJob.java class.

 

Hope it helps,

Domenico

[Nesting groups issue in Jaspersoft Studio 5.6.0]

Hey cmoon,

take  a look at this sample, where I built a group city within a group country that is using the sample DB.

I have added a group header for both. You can start from this sample and modify it to adapt to your case, also notice how the sql must return ordered result. Hope it helps.

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 8.2.0.final using JasperReports Library version 6.20.3-415f9428cffdb6805c6f85bbb29ebaf18813a2ab  -->
<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" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="c9e1b20f-8319-4047-8846-5208e2e54c3a">
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Sample DB"/>
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<queryString>
		<![CDATA[select * from orders order by shipcountry, shipcity]]>
	</queryString>
	<field name="ORDERID" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="ORDERID"/>
		<property name="com.jaspersoft.studio.field.label" value="ORDERID"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="CUSTOMERID" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="CUSTOMERID"/>
		<property name="com.jaspersoft.studio.field.label" value="CUSTOMERID"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="EMPLOYEEID" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="EMPLOYEEID"/>
		<property name="com.jaspersoft.studio.field.label" value="EMPLOYEEID"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="ORDERDATE" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.name" value="ORDERDATE"/>
		<property name="com.jaspersoft.studio.field.label" value="ORDERDATE"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="REQUIREDDATE" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.name" value="REQUIREDDATE"/>
		<property name="com.jaspersoft.studio.field.label" value="REQUIREDDATE"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPPEDDATE" class="java.sql.Timestamp">
		<property name="com.jaspersoft.studio.field.name" value="SHIPPEDDATE"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPPEDDATE"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPVIA" class="java.lang.Integer">
		<property name="com.jaspersoft.studio.field.name" value="SHIPVIA"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPVIA"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="FREIGHT" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.name" value="FREIGHT"/>
		<property name="com.jaspersoft.studio.field.label" value="FREIGHT"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPNAME" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="SHIPNAME"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPNAME"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPADDRESS" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="SHIPADDRESS"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPADDRESS"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPCITY" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="SHIPCITY"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPCITY"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPREGION" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="SHIPREGION"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPREGION"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPPOSTALCODE" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="SHIPPOSTALCODE"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPPOSTALCODE"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<field name="SHIPCOUNTRY" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.name" value="SHIPCOUNTRY"/>
		<property name="com.jaspersoft.studio.field.label" value="SHIPCOUNTRY"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="ORDERS"/>
	</field>
	<group name="GroupCountry">
		<groupExpression><![CDATA[$F{SHIPCOUNTRY}]]></groupExpression>
		<groupHeader>
			<band height="50">
				<textField>
					<reportElement x="220" y="14" width="100" height="30" uuid="c52201d9-2143-4ffe-b2bc-3c63a7501304"/>
					<textFieldExpression><![CDATA[$F{SHIPCOUNTRY}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="50"/>
		</groupFooter>
	</group>
	<group name="Group City">
		<groupExpression><![CDATA[$F{SHIPCITY}]]></groupExpression>
		<groupHeader>
			<band height="50">
				<textField>
					<reportElement x="220" y="10" width="100" height="30" uuid="805a81de-a3a1-4014-bb03-2ca836c2cbb4"/>
					<textFieldExpression><![CDATA[$F{SHIPCITY}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="50"/>
		</groupFooter>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="79" splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="35" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="30" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="0" width="95" height="30" uuid="b36ce90d-7321-4497-96e5-18625e067e36">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="103b9571-fbf4-4a6e-8ef0-45052048d9ab"/>
				</reportElement>
				<text><![CDATA[ORDERID]]></text>
			</staticText>
			<staticText>
				<reportElement x="95" y="0" width="92" height="30" uuid="6ad15c93-1406-4d78-a5d1-6847e855ad52">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0c1caf7f-101d-4d46-9dfc-824fc66d0411"/>
				</reportElement>
				<text><![CDATA[ORDERDATE]]></text>
			</staticText>
			<staticText>
				<reportElement x="187" y="0" width="92" height="30" uuid="3d077b3e-d4a6-43b0-98d1-0bd5f03e18ee">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fb04f75a-c93e-4766-9dac-97628630a87b"/>
				</reportElement>
				<text><![CDATA[SHIPPEDDATE]]></text>
			</staticText>
			<staticText>
				<reportElement x="279" y="0" width="92" height="30" uuid="69692d7d-3f2d-452d-9cbe-94e089ceaaab">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2ee2dd96-7fdd-4e9f-b9d2-4117f7108b9d"/>
				</reportElement>
				<text><![CDATA[SHIPCITY]]></text>
			</staticText>
			<staticText>
				<reportElement x="371" y="0" width="92" height="30" uuid="ddd61149-20e3-4378-851f-e0e00bcd4847">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6737e27e-de0e-47c8-a75d-55eccf0433a8"/>
				</reportElement>
				<text><![CDATA[SHIPREGION]]></text>
			</staticText>
			<staticText>
				<reportElement x="463" y="0" width="92" height="30" uuid="922fdf7b-1103-4d2c-acd5-dd62713c9bb4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a1f0cecf-ab66-4b7b-adb4-fde81ad696f7"/>
				</reportElement>
				<text><![CDATA[SHIPCOUNTRY]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="30" splitType="Stretch">
			<textField>
				<reportElement x="0" y="0" width="95" height="30" uuid="1ae7576e-1307-4d16-ae41-843f7d51a590">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="103b9571-fbf4-4a6e-8ef0-45052048d9ab"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{ORDERID}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="95" y="0" width="92" height="30" uuid="b974bf12-ab1f-4747-b3b9-05311308524d">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0c1caf7f-101d-4d46-9dfc-824fc66d0411"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{ORDERDATE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="187" y="0" width="92" height="30" uuid="0916bb73-b4ff-42f0-9c0d-bfd7ab846eb4">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fb04f75a-c93e-4766-9dac-97628630a87b"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{SHIPPEDDATE}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="279" y="0" width="92" height="30" uuid="93faa7f7-2f71-4088-852d-293fca01f8cc">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2ee2dd96-7fdd-4e9f-b9d2-4117f7108b9d"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{SHIPCITY}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="371" y="0" width="92" height="30" uuid="f61aa1d5-7925-45f8-bbea-749d5d9163bd">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6737e27e-de0e-47c8-a75d-55eccf0433a8"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{SHIPREGION}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="463" y="0" width="92" height="30" uuid="6edfa78c-0522-4fa8-ae93-653706178079">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a1f0cecf-ab66-4b7b-adb4-fde81ad696f7"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{SHIPCOUNTRY}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="45" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>

 

[Increment parameter and reset page number]

Hello agostinho, 

in any jasper report there is the bundled variable $V{PAGE_NUMBER}  that can be used to track page numbers.

Specifically:

 

You can set the $V{PAGE_NUMBER}'s print when expression to "REPORT" when you have to display total pages and,

$V{PAGE_NUMBER}'s print when expression to "NOW" when you have to display current page number.

[Jasperserver ( v8.2.0) reports on webpage rendering slowly. Also loader dialogbox hides before page renders completely.]

Hello karan,

the freshData is used in combination with DataSnapshot feature to speed up report execution, so if you don't have these last ones enabled, this parameter is not getting considered. More information about datasnapshot here: 

 

https://www.youtube.com/watch?v=F_aApuTBwDQ

Also there have been several changes on version 8 with regards to version 7.9 on the UI, so that's why you are observing chunks being loaded, but this is expected. 

Can I also ask how you are embedding Jasper? 

[Get ReportsExecution details of reports via rest_v2, scheduled within JasperServer UI]

Hello,

 

in order to get a job status you can use the following API:
/rest_v2/jobs/<jobID>/state/

 

It will return the state descriptor of the job, for example:

<state>
<nextFireTime>2022-03-29T18:01:00-07:00</nextFireTime>
<previousFireTime>2022-03-28T18:01:00-07:00</previousFireTime>
<value>NORMAL</value>
</state>

 

Hope it helps

 

[Buenos días. Quería saber si puedo sacar en word o pdf la pantalla de designer en la que los campos todavia no han pasado por la query de base da datos y estan vacios.]

Hello consultorfran,

Para exportar a Word o PDF sin valores puedes crear una copia del report y eliminar del mismo los parámetros (los que empiezan por $P) y los campos (los que empiezan por $F). Ejecute el informe que luego dará un resultado vacío y luego podrá exportarlo al formato deseado. Espero haber sido útil.

[How to set the shape of the line points]

Hello could you please details your question a bit more? Thanks

[show full STACKTRACE]

Hello Erik,

the reason the entire exception stack is not shown is for readability reasons. To change this behavior it would be necessary to modify the front end of the application to have a behavior different from the standard one out of the box.

In any case, for debugging purposes it is always advisable to look at the back end logs and have access to all the available information like the one you posted.

 

 

[Clausula UNION no Jaspersot - Error executindg SQL satemente.]

Hello alvarofs,

 

can you please check that the columns you are selecting in both queries are the same?

For instance I can see that in the first statement in DATA_OCORRENCIA there is an accent on the E that is not present in the second query.

Hope it helps

 

[Adhoc Reporting - DistinctCount issues]

Hello David,

as the message is saying, you should try to define a new measure instead of a new field in order to use this calculated field.

You can find the measures list at the bottom left of the ad hoc editor and then click on the 3 points to add the new measure with the same expression you have been using already

 

[Source jrxml version settings]

Hello, this is looks like a bug. 

It is missing translated strings most probably, preventing the user to pick the right version. Will open an internal ticket to get it fixed. Thanks for raising this.

[Generated report returns NULL values in JasperServer]

Hello Liana,

 

are you sure that on JasperServer the report is correctly using the same datasource that you are using on the Studio?

 

[How to merge cells depends on number of cells below]

Hi, can you try setting the column position to Stretch in the column group properties:

 

 

[How to merge cells depends on number of cells below]

Hi, can you try setting the column position to Stretch in the column group properties:

[Unable to merge two word files from different sources]

Hello, this error is mostly related to Apache poi internal behaviour. Would it be possible for you to provide the project src code and docx files you are trying to merge? 

 

Regards

[Compatibility Issues between Intel i7 vPro Laptop and Jaspersoft]

Hello shrutigrover97,

please note that JasperServer is an application that runs in the Java Virtual Machine that provides an abstraction of the machine you use at the hardware level.

What you can do is provide more memory to the Java Virtual Machine, also depending on the physically available memory.

For example for a Windows/Tomcat installation, you can modify the Tomcat bin/setenv.bat file to give up to 8 Giga of memory to the JVM, using the following line.

set JAVA_OPTS=%JAVA_OPTS% -Xms2048m -Xmx8192m -XX:PermSize=32m

This is just an example and to have a more specific configuration for your installation you need to know its details.

 

Hope it helps.

[Following are the issues that needs to be adddressed to achieve the expected crosstab report : 1). Set the Header for each column 2). Need to increase the width of the Row group,Column group,Measures as per the data size, which currently is not being]

Hello kaushikaraju1609,

 

Expected_Crosstab_Sample.png screenshot is not included as attachment, can you please share it?

[Jasper server War file deploy in websphere server - Getting error while starting the server]

Hello, would you evaluate installing the Jasper Server latest community edition 8.2 which also supports JDK 1.8?
https://community.jaspersoft.com/project/jasperreports-server