Report hangs: Java OutOfMemory error on iReport; SQL looping on Jasper Reports Server

0

Hi. I've got a report that only runs intermittently; lately, it's been failing consistently. I've had it hosted on a Jasper Reports Server (v4.0.0), and when it's there, if the server has been rebooted recently, the report may run. But, there seems to be some kind of memory leak I don't know how to track down, and when this condition is met, running the report causes the SQL in one of my sub-datasets to "loop". It's the weirdest thing: the dataset should only run once, yet I can watch the MySQL processes on my warehouse server and see the SQL getting executed again and again and again. Eventually the report times out.

Recently (today) I pulled down the JRXML to my local system to try to diagnose the problem. After removing/replacing the repository references (i.e. for corp. logos, fonts, etc.) I can get the report to compile, yet when I run it in iReport, it just hangs. No excessive CPU usage, just hourglass and no response. It's not even sending the SQL to the DB server, as I've been monitoring that. (For reference, it's iReport 4.0.2 - yeah, don't give me too hard a time - can't upgrade yet due to an error we get integrating newer JRXMLs on another app server).

Really no idea where to go from here. The error I get in iReport (10 minutes later) is:

 

Error filling print... java.lang.OutOfMemoryError: Java heap space null 
Setting up the file resolver... Added file resolver... Active top component: 2014INT.jrxml /home/tunes/Documents/CCHIT/Reporting/TestReports/2014INT.jrxml java.lang.OutOfMemoryError: Java heap space     at java.util.Arrays.copyOf(Arrays.java:2798)     at java.io.ByteArrayOutputStream.toByteArray(ByteArrayOutputStream.java:150)     at net.sf.jasperreports.engine.util.JRLoader.loadBytes(JRLoader.java:403)     at net.sf.jasperreports.engine.util.JRLoader.loadBytesFromLocation(JRLoader.java:554)     at net.sf.jasperreports.engine.JRImageRenderer.getInstance(JRImageRenderer.java:217)     at net.sf.jasperreports.engine.fill.JRFillImage.evaluateImage(JRFillImage.java:1057)     at net.sf.jasperreports.engine.fill.JRFillImage.evaluate(JRFillImage.java:1004)     at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258)     at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:439)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:403)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryOverflow(JRVerticalFiller.java:1745)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterNewPage(JRVerticalFiller.java:1208)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1041)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:301)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:135)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:878)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Print not filled. Try to use an EmptyDataSource...
 
 
Any and all suggestions welcome. I can post the JRXML, and even go scrape some of the catalina.out file from my JR Server if someone would review them and offer some suggestions.
 
Thanks in advance,
 
Ben
benu's picture
79
Joined: Dec 20 2006 - 6:20am
Last seen: 10 months 2 weeks ago

9 Answers:

0

HI Ben,

I am also facing similar issue, If you have found any solution, please let me know. Thanks in advance..

jakasjava's picture
Joined: Jan 31 2013 - 2:39pm
Last seen: 6 years 7 months ago
0

Hi,

We had a similar problem and we found the reason. Can you post the JRXML please to check if it's the same.

KGZ

KGZ's picture
KGZ
37
Joined: Jan 8 2013 - 9:15am
Last seen: 1 year 11 months ago

<?xml version="1.0" encoding="UTF-8"?>
<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="TestReportInt2014" columnCount="4" pageWidth="612" pageHeight="792" columnWidth="117" leftMargin="72" rightMargin="72" topMargin="20" bottomMargin="20" isSummaryWithPageHeaderAndFooter="true" isFloatColumnFooter="true">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<property name="ireport.jasperserver.reportUnit" value="/Production/TestingTeam/TestReport2_1_2"/>
<property name="ireport.jasperserver.url" value="https://reporting.cchit.org:8443/jasperserver/services/repository"/>
<style name="table">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" mode="Opaque" backcolor="#6495ED">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" mode="Opaque" backcolor="#BFD6FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="main">
<parameter name="InspectionId" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT RIGHT(c.Id,9) AS TestReportNo,
CASE
WHEN c.RecordTypeId = '012500000001QD8AAM' THEN 'Inpatient'
WHEN c.RecordTypeId = '012500000001QD7AAM' THEN 'Ambulatory'
END AS TestType,
-- ROLL-UP FROM ALL INSPECTIONS
GROUP_CONCAT(CONCAT(DATE_FORMAT(i.Completed__c,"%Y-%m-%d"),IF(i.Amendment_to__c<>"","(A)", ""),IF(i.Retest__c=TRUE,"(R)", "")) ORDER BY i.Completed__c SEPARATOR ", ") AS DateOfTest,
a.`Name` AS OrgName,
CASE
WHEN c.RecordTypeId IN ('012500000001QD8AAM') THEN 'Hospitals'
WHEN c.RecordTypeId IN ('012500000001QD7AAM') THEN 'Eligible Providers'
END AS Domain,
CONCAT(a.BillingStreet,'\n',a.BillingCity,', ',a.BillingState,' ',a.BillingPostalCode) AS Address,
c.Market_Company_URL__c AS Website,
c.Market_Email__c AS Email,
c.Market_Phone__c AS Phone,
c.Product_Name_Tested__c AS ProductName,
c.Product_Version_Tested__c AS ProductVersion,
c.Quality_Reports_Passed__c AS NQFs,
IF((SELECT COUNT(*)
FROM (salesforce.ehr_component__c e INNER JOIN salesforce.certification__c ec ON e.Certification__c = ec.Id)
INNER JOIN salesforce.inspection__c ei ON ec.Id = ei.Certification__c
WHERE ei.Id LIKE CONCAT($P{InspectionId},"%")) > 0,True,False) AS EHRComps,
IF(LENGTH(GROUP_CONCAT(i.Amendment_to__c SEPARATOR ""))>0,"Amended ","") AS Amended,
GROUP_CONCAT(CONCAT(DATE_FORMAT(i.Completed__c,"%Y-%m-%d")," ",i.Notes_to_tester__c) ORDER BY i.Completed__c SEPARATOR "\n") AS NotesToTester,
GROUP_CONCAT(CONCAT(DATE_FORMAT(i.Completed__c,"%Y-%m-%d")," ",i.Notes_from_tester__c) ORDER BY i.Completed__c SEPARATOR "\n") AS NotesFromTester,
GROUP_CONCAT(i.QMS__c ORDER BY i.Completed__c SEPARATOR "\n") AS QMS,
GROUP_CONCAT(i.SED__c ORDER BY i.Completed__c SEPARATOR "\n") AS SED,
GROUP_CONCAT(CONCAT(DATE_FORMAT(i.Completed__c,"%Y-%m-%d")," ",i.Deviations__c) ORDER BY i.Completed__c SEPARATOR "\n") AS Deviations,
GROUP_CONCAT(CONCAT(DATE_FORMAT(i.Completed__c,"%Y-%m-%d")," ",i.Optional_Standards_Tested__c) ORDER BY i.Completed__c SEPARATOR "\n") AS OptStandards,
GROUP_CONCAT(CONCAT(DATE_FORMAT(i.Completed__c,"%Y-%m-%d")," ",i.Newer_Standards__c) ORDER BY i.Completed__c SEPARATOR "\n") AS NewerStandards,
IF(c.Complete_EHR__c,"Complete","Modular") AS CompMod

FROM ((salesforce.inspection__c i INNER JOIN salesforce.certification__c c ON i.Certification__c = c.Id)
INNER JOIN salesforce.account a ON c.Vendor__c = a.Id)
LEFT JOIN salesforce.inspection__c am ON i.Amendment_to__c = am.Id
WHERE c.RecordTypeId IN ('012500000001QD8AAM','012500000001QD7AAM')
AND i.Id IN(SELECT xi.Id FROM
(salesforce.inspection__c xi INNER JOIN salesforce.certification__c xc ON xi.Certification__c = xc.Id) INNER JOIN
salesforce.inspection__c yi ON xc.Id = yi.Certification__c
WHERE yi.Id LIKE CONCAT($P{InspectionId},"%"))
AND i.Id NOT IN(SELECT zi.Amendment_to__c FROM salesforce.inspection__c zi WHERE NOT zi.Amendment_to__c IS NULL)
GROUP BY c.Id
ORDER BY i.Completed__c;]]>
</queryString>
<field name="TestReportNo" class="java.lang.String"/>
<field name="TestType" class="java.lang.String"/>
<field name="DateOfTest" class="java.lang.String"/>
<field name="OrgName" class="java.lang.String"/>
<field name="Domain" class="java.lang.String"/>
<field name="Address" class="java.lang.String"/>
<field name="Website" class="java.lang.String"/>
<field name="Email" class="java.lang.String"/>
<field name="Phone" class="java.lang.String"/>
<field name="ProductName" class="java.lang.String"/>
<field name="ProductVersion" class="java.lang.String"/>
<field name="NQFs" class="java.lang.String"/>
<field name="EHRComps" class="java.lang.Long"/>
<field name="Amended" class="java.lang.String"/>
<field name="NotesToTester" class="java.lang.String"/>
<field name="NotesFromTester" class="java.lang.String"/>
<field name="QMS" class="java.lang.String"/>
<field name="SED" class="java.lang.String"/>
<field name="Deviations" class="java.lang.String"/>
<field name="OptStandards" class="java.lang.String"/>
<field name="NewerStandards" class="java.lang.String"/>
<field name="CompMod" class="java.lang.String"/>
</subDataset>
<subDataset name="ehr_configuration">
<parameter name="InspectionId" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT e.Architecture__c AS Architecture,
e.Hosting_Model__c AS HostingModel,
CONCAT(e.Database__c,IF(e.Other_Database__c="",""," - "),e.Other_Database__c) AS DB,
CONCAT(e.Database_Server_OS__c,IF(e.Other_DB_OS__c="",""," - "),e.Other_DB_OS__c) AS DBOS,
CONCAT(e.Client_OS__c,IF(e.Other_Client_OS__c="",""," - "),e.Other_Client_OS__c) AS ClientOS,
CONCAT(e.Browser__c,IF(e.Other_Browser__c="",""," - "),e.Other_Browser__c) AS Browser,
e.Other_Components__c AS OtherComponents
FROM salesforce.ehr_configuration__c e INNER JOIN salesforce.inspection__c i USING(Certification__c)
WHERE i.Id LIKE CONCAT($P{InspectionId},"%") AND e.Tested_Configuration__c = "true";]]>
</queryString>
<field name="Architecture" class="java.lang.String"/>
<field name="HostingModel" class="java.lang.String"/>
<field name="DB" class="java.lang.String"/>
<field name="DBOS" class="java.lang.String"/>
<field name="ClientOS" class="java.lang.String"/>
<field name="Browser" class="java.lang.String"/>
<field name="OtherComponents" class="java.lang.String"/>
</subDataset>
<subDataset name="rpt_test_report_sub_ehr_components">
<parameter name="InspectionId" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[CALL rpt_test_report_sub_ehr_components($P{InspectionId});]]>
</queryString>
<field name="ProductName" class="java.lang.String"/>
<field name="ProductVersion" class="java.lang.String"/>
<field name="Supplier" class="java.lang.String"/>
<field name="Criteria" class="java.lang.String"/>
</subDataset>
<subDataset name="rpt_test_report_sub_cqms">
<parameter name="InspectionId" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[CALL salesforce.rpt_test_report_sub_cqms($P{InspectionId});]]>
</queryString>
<field name="Identifier" class="java.lang.String"/>
<field name="TitleShort" class="java.lang.String"/>
<field name="Criteria" class="java.lang.String"/>
</subDataset>
<parameter name="InspectionId" class="java.lang.String">
<defaultValueExpression><![CDATA["a005000000OWf30"]]></defaultValueExpression>
</parameter>
<parameter name="date_current" class="java.util.Date" isForPrompting="false">
<defaultValueExpression><![CDATA[new java.util.Date()]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[CALL salesforce.rpt_test_report_sub_criteria2014($P{InspectionId});]]>
</queryString>
<field name="Category" class="java.lang.String"/>
<field name="TestingOrder" class="java.lang.Integer"/>
<field name="vIndex" class="java.lang.Integer"/>
<field name="Criterion" class="java.lang.String"/>
<field name="Outcome" class="java.lang.String"/>
<variable name="rpt_certificate_sub_ehr_components_RECORDCOUNT" class="java.lang.Integer" calculation="System"/>
<pageHeader>
<band height="413" splitType="Stretch">
<staticText>
<reportElement x="309" y="44" width="159" height="15"/>
<textElement textAlignment="Right">
<font fontName="Arial" size="10" isBold="true"/>
</textElement>
<text><![CDATA[NVLAP LAB CODE 200980]]></text>
</staticText>
<componentElement>
<reportElement isPrintRepeatedValues="false" x="0" y="70" width="468" height="343" isRemoveLineWhenBlank="true">
<printWhenExpression><![CDATA[$V{PAGE_NUMBER}==1]]></printWhenExpression>
</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="Vertical">
<datasetRun subDataset="main">
<datasetParameter name="InspectionId">
<datasetParameterExpression><![CDATA[$P{InspectionId}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="343" width="468">
<textField isStretchWithOverflow="true" hyperlinkType="Reference" hyperlinkTarget="Blank">
<reportElement positionType="Float" x="0" y="264" width="468" height="79" forecolor="#000000"/>
<textElement markup="styled">
<font fontName="Arial" size="10" isUnderline="false"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["The above-named product was tested according to the test procedures for evaluating conformance of EHRs or EHR modules to the certification criteria defined in Health Information Technology: Standards, Implementation Specifications, and Certification Criteria for Electronic Health Record Technology, 2014 Edition as published on September 4, 2012. The specific test procedures (“2014 Edition Test Method”) can be found at <style isUnderline=\"true\" forecolor=\"blue\">http://www.healthit.gov/policy-researchers-implementers/2014-edition-fin... criteria were tested on this date and the results are as follows:"]]></textFieldExpression>
<hyperlinkReferenceExpression><![CDATA["http://www.healthit.gov/policy-researchers-implementers/2014-edition-fin...
<hyperlinkTooltipExpression><![CDATA["Link to 45 CFR Part 170, RIN 0991-AB58"]]></hyperlinkTooltipExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="121" y="226" width="279" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ProductVersion}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="86" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Applicant Name:]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement x="121" y="86" width="279" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{OrgName}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement x="121" y="103" width="279" height="37"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Address}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="226" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Product Version:]]></text>
</staticText>
<staticText>
<reportElement x="0" y="208" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Product Name:]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement x="121" y="208" width="279" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ProductName}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="103" width="121" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Applicant Address:]]></text>
</staticText>
<staticText>
<reportElement x="0" y="29" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Test Report #]]></text>
</staticText>
<textField>
<reportElement x="121" y="29" width="100" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{TestReportNo}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="46" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Date(s) of Test:]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement x="121" y="46" width="220" height="38"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{DateOfTest}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="245" y="29" width="96" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Domain:]]></text>
</staticText>
<textField>
<reportElement x="341" y="29" width="100" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{TestType}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="0" y="0" width="468" height="23"/>
<textElement textAlignment="Center" markup="styled">
<font fontName="Arial" size="18" isBold="true"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA["ONC 2014 Test Report <style forecolor=\"red\">" + $F{Amended} + "</style>"]]></textFieldExpression>
</textField>
<line>
<reportElement x="0" y="23" width="468" height="1"/>
</line>
<staticText>
<reportElement x="0" y="244" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Test Type:]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement x="121" y="244" width="279" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{CompMod}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="62" width="100" height="10"/>
<textElement textAlignment="Center">
<font fontName="Arial Narrow" size="8"/>
</textElement>
<text><![CDATA[("A"=Amended, "R"=Retest)]]></text>
</staticText>
<staticText>
<reportElement x="0" y="143" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Website:]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement x="121" y="143" width="279" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Website}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="162" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Contact:]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement x="121" y="162" width="279" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Email}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement x="121" y="182" width="279" height="16"/>
<textElement>
<font fontName="Courier New" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Phone}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="0" y="182" width="100" height="16"/>
<textElement>
<font fontName="Arial" size="12"/>
</textElement>
<text><![CDATA[Phone:]]></text>
</staticText>
</jr:listContents>
</jr:list>
</componentElement>
<image>
<reportElement x="0" y="11" width="309" height="48"/>
<imageExpression class="java.lang.String"><![CDATA["/home/tunes/Documents/CCHIT/Reporting/TestReports/CCHITLetterhead.jpg"]]></imageExpression>
</image>
<image hAlign="Right" isUsingCache="false">
<reportElement x="309" y="0" width="159" height="44"/>
<imageExpression class="java.lang.String"><![CDATA["/home/tunes/Documents/CCHIT/Reporting/TestReports/nvlap1.jpg"]]></imageExpression>
</image>
</band>
</pageHeader>
<columnHeader>
<band height="5">
<line>
<reportElement x="0" y="2" width="468" height="1">
<printWhenExpression><![CDATA[$V{COLUMN_NUMBER}==1]]></printWhenExpression>
</reportElement>
</line>
</band>
</columnHeader>
<detail>
<band height="13">
<textField>
<reportElement mode="Transparent" x="0" y="0" width="52" height="12" backcolor="#FFFFFF"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial Narrow" size="8"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Criterion}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="52" y="0" width="63" height="12"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New" size="6"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Outcome}]]></textFieldExpression>
</textField>
<rectangle>
<reportElement mode="Opaque" x="52" y="0" width="63" height="11" forecolor="#FF0000" backcolor="#FF0000">
<printWhenExpression><![CDATA[$F{Outcome}.equalsIgnoreCase("")]]></printWhenExpression>
</reportElement>
</rectangle>
<break type="Column">
<reportElement x="0" y="11" width="100" height="1">
<printWhenExpression><![CDATA[$V{REPORT_COUNT}<40 &&
$V{REPORT_COUNT}%11==0 &&
$V{REPORT_COUNT}>=11]]></printWhenExpression>
</reportElement>
</break>
</band>
</detail>
<columnFooter>
<band height="4">
<printWhenExpression><![CDATA[$V{COLUMN_NUMBER}==1]]></printWhenExpression>
<line>
<reportElement x="0" y="0" width="468" height="1"/>
</line>
</band>
</columnFooter>
<pageFooter>
<band height="16" splitType="Stretch">
<line>
<reportElement x="0" y="0" width="468" height="1"/>
<graphicElement>
<pen lineStyle="Double"/>
</graphicElement>
</line>
<staticText>
<reportElement x="126" y="4" width="217" height="10"/>
<textElement textAlignment="Center">
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Version 1.0, January 2, 2013 Copyright © CCHIT]]></text>
</staticText>
</band>
</pageFooter>
<summary>
<band height="492">
<componentElement>
<reportElement positionType="Float" x="0" y="59" width="468" height="218" isPrintWhenDetailOverflows="true"/>
<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="Vertical">
<datasetRun subDataset="main">
<datasetParameter name="InspectionId">
<datasetParameterExpression><![CDATA[$P{InspectionId}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="218" width="468">
<staticText>
<reportElement positionType="Float" x="0" y="103" width="299" height="12"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Quality Management Systems]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="Float" x="0" y="115" width="468" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{QMS}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="Float" x="0" y="145" width="468" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{SED}]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="0" y="133" width="322" height="12"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Safety Enhanced Design]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="Float" x="0" y="12" width="468" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{NotesToTester}]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="0" y="30" width="100" height="12"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Notes from Tester]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="Float" x="0" y="42" width="468" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{NotesFromTester}]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="0" y="0" width="100" height="12"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Notes to Tester]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="Float" x="0" y="85" width="468" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Deviations}]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="0" y="60" width="468" height="25"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[The deviations from, additions to, or exclusions from the aforementioned test methods, test conditions and test setup, including the use of applicant-supplied test data, are as follows:]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="0" y="193" width="322" height="12"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Newer Standards Tested]]></text>
</staticText>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="Float" x="0" y="175" width="468" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{OptStandards}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement positionType="Float" x="0" y="205" width="468" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{NewerStandards}]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="0" y="163" width="299" height="12"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Optional Standards Tested]]></text>
</staticText>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement positionType="Float" x="0" y="281" width="468" height="155" isPrintWhenDetailOverflows="true"/>
<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="Vertical">
<datasetRun subDataset="ehr_configuration">
<datasetParameter name="InspectionId">
<datasetParameterExpression><![CDATA[$P{InspectionId}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="155" width="468">
<textField>
<reportElement positionType="Float" x="106" y="12" width="313" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Architecture}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" x="0" y="109" width="468" height="44"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{OtherComponents}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="106" y="48" width="313" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{DBOS}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="106" y="24" width="313" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{HostingModel}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="106" y="72" width="313" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Browser}]]></textFieldExpression>
</textField>
<textField>
<reportElement positionType="Float" x="106" y="36" width="313" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{DB}]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="0" y="12" width="100" height="12"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Architecture:]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="0" y="24" width="100" height="12"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Hosting Model:]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="0" y="36" width="100" height="12"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Database:]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="0" y="48" width="100" height="12"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Database Server OS:]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="0" y="60" width="100" height="12"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Client OS:]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="0" y="72" width="100" height="12"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Browser:]]></text>
</staticText>
<staticText>
<reportElement positionType="Float" x="0" y="95" width="100" height="14"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Other Components:]]></text>
</staticText>
<textField>
<reportElement positionType="Float" x="106" y="60" width="313" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ClientOS}]]></textFieldExpression>
</textField>
<staticText>
<reportElement positionType="Float" x="0" y="0" width="221" height="12"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Software Configuration Tested]]></text>
</staticText>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement key="table 1" style="table 1" positionType="Float" x="0" y="440" width="468" height="50" isPrintWhenDetailOverflows="true"/>
<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="rpt_test_report_sub_ehr_components">
<datasetParameter name="InspectionId">
<datasetParameterExpression><![CDATA[$P{InspectionId}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:columnGroup width="465">
<jr:tableHeader height="18" rowSpan="1">
<box>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement positionType="Float" mode="Opaque" x="2" y="2" width="360" height="14"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Additional Software Used in Testing]]></text>
</staticText>
</jr:tableHeader>
<jr:column width="126">
<jr:columnHeader height="26" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement mode="Opaque" x="2" y="0" width="120" height="24"/>
<textElement verticalAlignment="Bottom">
<font fontName="Arial" isBold="false"/>
</textElement>
<text><![CDATA[Product Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="16" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textField isStretchWithOverflow="true">
<reportElement stretchType="RelativeToTallestObject" x="2" y="2" width="122" height="12" isPrintWhenDetailOverflows="true"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ProductName}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="54">
<jr:columnHeader height="26" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement mode="Opaque" x="2" y="0" width="46" height="24"/>
<textElement verticalAlignment="Bottom">
<font fontName="Arial" isBold="false"/>
</textElement>
<text><![CDATA[Product Version]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="16" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textField isStretchWithOverflow="true">
<reportElement stretchType="RelativeToTallestObject" x="2" y="2" width="48" height="12" isPrintWhenDetailOverflows="true"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{ProductVersion}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="139">
<jr:columnHeader height="26" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement mode="Opaque" x="2" y="0" width="80" height="24"/>
<textElement verticalAlignment="Bottom">
<font fontName="Arial" isBold="false"/>
</textElement>
<text><![CDATA[Supplier]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="16" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textField isStretchWithOverflow="true">
<reportElement stretchType="RelativeToTallestObject" x="2" y="2" width="135" height="12" isPrintWhenDetailOverflows="true"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Supplier}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="146">
<jr:columnHeader height="26" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement mode="Opaque" x="2" y="0" width="130" height="24"/>
<textElement verticalAlignment="Bottom">
<font fontName="Arial" isBold="false"/>
</textElement>
<text><![CDATA[Criteria this product supports]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="16" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textField isStretchWithOverflow="true">
<reportElement stretchType="RelativeToTallestObject" x="2" y="2" width="141" height="12" isPrintWhenDetailOverflows="true"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Criteria}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:columnGroup>
</jr:table>
</componentElement>
<frame>
<reportElement key="CQM_frame" x="0" y="0" width="468" height="57"/>
<componentElement>
<reportElement key="table 2" x="0" y="0" width="468" height="50"/>
<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="rpt_test_report_sub_cqms">
<datasetParameter name="InspectionId">
<datasetParameterExpression><![CDATA[$P{InspectionId}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:columnGroup width="467">
<jr:tableHeader height="17" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement x="2" y="2" width="270" height="15"/>
<textElement>
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[Clinical Quality Measures Passed]]></text>
</staticText>
</jr:tableHeader>
<jr:column width="61">
<jr:columnHeader height="19" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement x="2" y="0" width="45" height="16"/>
<textElement verticalAlignment="Bottom">
<font fontName="Arial" isBold="false"/>
</textElement>
<text><![CDATA[Identifier]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell height="16" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textField isStretchWithOverflow="true">
<reportElement stretchType="RelativeToTallestObject" x="2" y="2" width="57" height="12" isPrintWhenDetailOverflows="true"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Identifier}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="244">
<jr:columnHeader height="19" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement x="2" y="0" width="240" height="16"/>
<textElement verticalAlignment="Bottom">
<font fontName="Arial" isBold="false"/>
</textElement>
<text><![CDATA[Measure Title]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell height="16" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textField isStretchWithOverflow="true">
<reportElement stretchType="RelativeToTallestObject" x="2" y="2" width="240" height="12" isPrintWhenDetailOverflows="true"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{TitleShort}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="162">
<jr:columnHeader height="19" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<staticText>
<reportElement x="2" y="0" width="134" height="16"/>
<textElement verticalAlignment="Bottom">
<font fontName="Arial" isBold="false"/>
</textElement>
<text><![CDATA[Applicable Criteria]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell height="16" rowSpan="1">
<box>
<pen lineWidth="0.5"/>
<topPen lineWidth="0.5" lineStyle="Solid"/>
<leftPen lineWidth="0.5" lineStyle="Solid"/>
<bottomPen lineWidth="0.5" lineStyle="Solid"/>
<rightPen lineWidth="0.5" lineStyle="Solid"/>
</box>
<textField isStretchWithOverflow="true">
<reportElement stretchType="RelativeToTallestObject" x="2" y="2" width="158" height="12" isPrintWhenDetailOverflows="true"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{Criteria}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:columnGroup>
</jr:table>
</componentElement>
</frame>
</band>
</summary>
</jasperReport>

benu - 6 years 7 months ago

Sorry, meant to add some niceties: Thanks, KGZ - I hope you do have an answer for us! BTW, tried upping my Xms & Xmx values for iReport to 1024m and 2048m respectively - same error; just took longer to fail. Thanks much -Ben

benu - 6 years 7 months ago
1

Hi Ben,

I can't open your jrxml in iReport but, I had a look to the xml and it seems you have the same problem we had.

I noticed that you use page header band with a hight = 413. Page header is repeated in each page. I think your are using dynamic elements within it.

Your band stretch with your data and when it won't find enough place it will try to go to next page which must contain the page header band !!

I think this is the reason of the loop.

In plus you have a summary band with a hight = 492 and the property isSummaryWithPageHeaderAndFooter="true"

I hope this will help you.

KGZ

KGZ's picture
KGZ
37
Joined: Jan 8 2013 - 9:15am
Last seen: 1 year 11 months ago

KGZ - that did the trick. Thanks SO much! I'll have some fine-tuning to do in order to get everything ordered properly, but moving elements out of the repeating page header seemed to solve the problem. I'll implement the Title band, and control what's visible with a few "Print When" expressions; I think I'm good. Thanks again! -Ben

benu - 6 years 7 months ago

And to confirm, this did solve the problem. I'm good to go, and report is pushed to production. Have a great weekend, and thanks again, KGZ! -Ben

benu - 6 years 7 months ago

My pleasure.

KGZ - 6 years 7 months ago
0

Hi KGZ,

In our Jrxml we have height set to be 33/34.. when we click on report multiple times we get java.lang.OutOfMemoryError: PermGen space. 

Thanks in advance :)

..fanny

jakasjava's picture
Joined: Jan 31 2013 - 2:39pm
Last seen: 6 years 7 months ago
0

Hi KGZ,

In our Jrxml we have height set to be 33/34.. when we click on report multiple times we get java.lang.OutOfMemoryError: PermGen space. 

Thanks in advance :)

..fanny

jakasjava's picture
Joined: Jan 31 2013 - 2:39pm
Last seen: 6 years 7 months ago

Hi fanny,
Do you have this problem in both iReport and Jasperserver ?
did u try to up Xms & Xmx ?
Can you attach your jrxml ?

KGZ

KGZ - 6 years 7 months ago
1

Thanks KGZ, I dont see this issue in Ireport, I see it in our code, when i click on reports button multiple times the permgen space increases and it comes down very slowly. Data is very small just couple of rows. I am not sure is there any leak happening through my sql query  or infinite loop??? Increasing the permgen space is not a permanent solution.. I am planning to use Visualizer but guess it helps when we have large data.

here is my Jrxml:(I have 2 sub reports in this jrxml) 

 

jakasjava's picture
Joined: Jan 31 2013 - 2:39pm
Last seen: 6 years 7 months ago
0

Hi KGF, I am  not able to paste the jrxml here, Its not displaying the whole file????

 

jakasjava's picture
Joined: Jan 31 2013 - 2:39pm
Last seen: 6 years 7 months ago
0
<band height="49"><textfield pattern="EEEEE dd MMMMM yyyy"><reportelement mode="Transparent" x="234" y="20" width="144" height="20"></reportelement><textelement><font fontname="Verdana" size="8" isbold="true"></font> </textelement><textfieldexpression class="java.lang.String"></textfieldexpression></textfield><statictext><reportelement mode="Transparent" x="198" y="0" width="144" height="20"></reportelement><textelement><font fontname="Verdana" isbold="true"></font> </textelement><text></text></statictext><line><reportelement mode="Opaque" x="0" y="40" width="555" height="1"></reportelement></line><statictext><reportelement mode="Transparent" x="179" y="20" width="55" height="20"></reportelement><textelement><font size="8" isbold="true"></font> </textelement><text></text></statictext></band>
jakasjava's picture
Joined: Jan 31 2013 - 2:39pm
Last seen: 6 years 7 months ago
0

More follow-up: this problem occurred AGAIN, and I just could not figure out how to keep the subdataset form re-executing in an endless loop. So, the final solution was to break the report in two:

  1. Master report: query returns just a single row; data placed in elements in title, page header and summary bands
  2. Sub report: query returns ~60 rows; needs to be formatted in four columns

Doing it this way allowed me to remove the list components, which were required when trying to tie elements on the original "master" report to a subdataset.

Happy to provide details to anyone this might help - just add a note to this thread.

benu's picture
79
Joined: Dec 20 2006 - 6:20am
Last seen: 10 months 2 weeks ago
Feedback