christopher.astles Posted May 9, 2018 Share Posted May 9, 2018 I have a report where the completed analyses are supposed to show below the outstanding work.If there is a lot of completed work, the field seems to stretch but does not print the information.I changed this completed analyses field to be fixed relative to top, and now it prints all of the information but overlaps if the Outstanding field expandsThanks in advance for anybody who can help. Can't see an option to upload the jrxml file but here is the code.<?xml version="1.0" encoding="UTF-8"?><br><!-- Created with Jaspersoft Studio version 6.4.3.final using JasperReports Library version 5.0.1 --><br><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="OutstandingAnalysesDistributions" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="NoPages" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30" scriptletClass="scriptlets.OutstandingAnalyses" uuid="35380a3d-224e-4f3f-bec8-a446c1445fa5"><br> <property name="com.jasperassistant.designer.Grid" value="false"/><br> <property name="com.jasperassistant.designer.SnapToGrid" value="false"/><br> <property name="com.jasperassistant.designer.GridWidth" value="12"/><br> <property name="com.jasperassistant.designer.GridHeight" value="12"/><br> <property name="com.jasperassistant.designer.DataSource" value="LabCreate"/><br> <property name="com.jasperassistant.designer.Units" value="Millimeters"/><br> <property name="ireport.zoom" value="1.4641000000000006"/><br> <property name="ireport.x" value="316"/><br> <property name="ireport.y" value="0"/><br> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="QA2018-3"/><br> <property name="com.jaspersoft.studio.data.sql.tables" value=""/><br> <parameter name="Distributions" class="java.lang.String"><br> <defaultValueExpression><![CDATA["%"]]></defaultValueExpression><br> </parameter><br> <parameter name="DistributionsOrder" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{REPORT_SCRIPTLET}.getDistributionsOrder($P{Distributions})]]></defaultValueExpression><br> </parameter><br> <parameter name="DateVersion" class="java.lang.String"/><br> <parameter name="Totals" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{REPORT_SCRIPTLET}.getTotals($P{Distributions},$P{DateVersion})]]></defaultValueExpression><br> </parameter><br> <parameter name="DistinctOverdueCount" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{Totals}.split(",")[0]]]></defaultValueExpression><br> </parameter><br> <parameter name="DistinctNextSevenDaysCount" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{Totals}.split(",")[1]]]></defaultValueExpression><br> </parameter><br> <parameter name="DistinctOverSevenDaysCount" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{Totals}.split(",")[2]]]></defaultValueExpression><br> </parameter><br> <parameter name="pReportID" class="java.lang.String"><br> <defaultValueExpression><![CDATA[""]]></defaultValueExpression><br> </parameter><br> <parameter name="MinDueDate" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{DateVersion}.equals("0")?<br> "DateDue"<br>:$P{DateVersion}.equals("1")?<br> "LabDueDate"<br>:<br> "DateDue"]]></defaultValueExpression><br> </parameter><br> <parameter name="Days" class="java.lang.String"><br> <defaultValueExpression><![CDATA["0"]]></defaultValueExpression><br> </parameter><br> <parameter name="pGroupByDayRec" class="java.lang.String"><br> <defaultValueExpression><![CDATA["0"]]></defaultValueExpression><br> </parameter><br> <parameter name="pPreviousDistribution" class="java.lang.String"><br> <defaultValueExpression><![CDATA["'none'"]]></defaultValueExpression><br> </parameter><br> <parameter name="pPreviousDistributionSQL" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{pPreviousDistribution}.equalsIgnoreCase("'None'") ? "" : " WHERE PreviousDistributionFinish IS NOT NULL "]]></defaultValueExpression><br> </parameter><br> <parameter name="DayRecord" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{pGroupByDayRec}.equals("1") ? " ,DATEPART(YEAR,PreviousDistributionFinish) " + " ,DATEPART(MONTH,PreviousDistributionFinish) " + " ,DATEPART(DAY,PreviousDistributionFinish) " : ""]]></defaultValueExpression><br> </parameter><br> <parameter name="resolveQualityCode" class="java.lang.String"><br> <defaultValueExpression><![CDATA["0"]]></defaultValueExpression><br> </parameter><br> <parameter name="MaterialType" class="java.lang.String"><br> <defaultValueExpression><![CDATA["All"]]></defaultValueExpression><br> </parameter><br> <parameter name="pMaterialTypeIncOrExc" class="java.lang.String"><br> <parameterDescription><![CDATA[sets whether the specified material types are used to include or exclude jobs.]]></parameterDescription><br> <defaultValueExpression><![CDATA["Include"]]></defaultValueExpression><br> </parameter><br> <parameter name="pMaterialTypeFilterSQL" class="java.lang.String"><br> <defaultValueExpression><![CDATA[$P{pMaterialTypeIncOrExc}.equalsIgnoreCase( "Include" )?<br> (($P{MaterialType}.equalsIgnoreCase("All")||$P{MaterialType}.equalsIgnoreCase(""))?<br> ""<br> :<br> "AND p.Material_type IN ($P!{MaterialType})")<br>:<br> "AND p.Material_type NOT IN ($P!{MaterialType})"]]></defaultValueExpression><br> </parameter><br> <parameter name="runDate" class="java.util.Date" isForPrompting="false"><br> <defaultValueExpression><![CDATA[new Date()]]></defaultValueExpression><br> </parameter><br> <parameter name="cal" class="java.util.Calendar" isForPrompting="false"><br> <defaultValueExpression><![CDATA[Calendar.getInstance()]]></defaultValueExpression><br> </parameter><br> <parameter name="showCompAnalysisSeparate" class="java.lang.String"><br> <defaultValueExpression><![CDATA["0"]]></defaultValueExpression><br> </parameter><br> <parameter name="showDaysOverDue" class="java.lang.String"><br> <defaultValueExpression><![CDATA["0"]]></defaultValueExpression><br> </parameter><br> <parameter name="pAnalysesFilterSQL" class="java.lang.String"><br> <defaultValueExpression><![CDATA[($P{Analyses}.equalsIgnoreCase("All")||$P{Analyses}.equalsIgnoreCase(""))?<br> ("1")<br>:<br> ("CASE WHEN t.analysis in ($P!{Analyses}) THEN 1 ELSE 0 END")]]></defaultValueExpression><br> </parameter><br> <parameter name="Analyses" class="java.lang.String"><br> <defaultValueExpression><![CDATA["All"]]></defaultValueExpression><br> </parameter><br> <parameter name="showAssayState" class="java.lang.String"><br> <defaultValueExpression><![CDATA["0"]]></defaultValueExpression><br> </parameter><br> <queryString><br> <![CDATA[sELECT *,<br> CASE<br> WHEN PreviousDistributionFinish IS NULL Then 'Not Ticked Out'<br> ELSE<br> DATENAME(DAY,PreviousDistributionFinish ) + '-' +<br> DATENAME(MONTH,PreviousDistributionFinish) + '-' +<br> DATENAME(YEAR,PreviousDistributionFinish )<br> END AS GroupDate<br>FROM (<br>SELECT DistributionName =<br> Case<br> when DistributionName = 'Sub Contractor' and Sub_Contract = 'LMA' then 'Sub Contractor - LMA'<br> when DistributionName = 'Peru Cu/Pb/Zn'<br> then Case<br> when Material_Type = 'CU-CONCS' then 'Peru Cu'<br> when Material_Type = 'CU-CON-ERD' then 'Peru Cu'<br> when Material_Type = 'CU-SUL-CON' then 'Peru Cu'<br> when Material_Type = 'ZN-CONCS' then 'Peru Zn'<br> when Material_Type = 'ZN-PB-CON' then 'Peru Zn'<br> when Material_Type = 'PB-AG-CONC' then 'Peru Pb'<br> when Material_Type = 'PB-CONCS' then 'Peru Pb'<br> when Material_Type = 'PB-SUL-CON' then 'Peru Pb'<br> else 'Peru Other'<br> end<br> else DistributionName<br> end,<br> PeruOrder =<br> case DistributionName<br> when 'Peru Cu/Pb/Zn' then<br> case<br> when Material_Type = 'CU-CONCS' then 0<br> when Material_Type = 'CU-CON-ERD' then 0<br> when Material_Type = 'CU-SUL-CON' then 0<br> when Material_Type = 'ZN-CONCS' then 1<br> when Material_Type = 'ZN-PB-CON' then 1<br> when Material_Type = 'PB-AG-CONC' then 2<br> when Material_Type = 'PB-CONCS' then 2<br> when Material_Type = 'PB-SUL-CON' then 2<br> else 3<br> end<br> else 0<br> end,<br> DistOrder = $P!{DistributionsOrder} <br> p.Name,<br> NumSamples = (select count(sample_number) from sample where project = p.name and status <> 'X'),<br> Customer1,<br> Company_Name,<br> Quality,<br> ISNULL(le.value,'') AS QualityResolved,<br> Material_Desc,<br> Material_Type,<br> Analysis,<br> DateDue,LabDueDate,<br> assay_state,<br> (SELECT CASE<br> WHEN jd2.Completed IS NULL THEN NULL<br> ELSE jd2.Completed<br> END AS PreviousDistributionFinish<br> FROM jobdistributions jd2<br> WHERE p.Name = jd2.JobNumber<br> AND jd2.distributionname = $P!{pPreviousDistribution} <br> AND jd.Value = '1') AS PreviousDistributionFinish,<br> NumAnalyses = count(Analysis),<br> ShowAnalysis = $P!{pAnalysesFilterSQL},<br> Tommorrow = dateAdd(day,datediff(day,0,dateAdd(day,1,getDate())),0),<br> SevenDays = dateAdd(day,datediff(day,0,dateAdd(day,7,getDate())),0),<br> MajorClient = (select Top 1 GroupName from ReportGroup where ReportID = '$P!{pReportID}' and ItemName in (Customer1,Customer2,Customer3,Customer4) and GroupName is not null),<br> MinDueDate = (select min($P!{MinDueDate}) from Test<br> inner join sample on Test.Sample_Number = Sample.Sample_Number<br> where Sample.Project = p.Name and Test.Status != 'X' and Test.Status != 'A'),<br> Complete = count(case<br> when t.Status = 'C' or t.Status = 'A' then 1<br> else null<br> end),<br> Incomplete = count(case<br> when t.Status = 'I' or t.Status = 'P' then 1<br> else null<br> end),<br> 'Overdue' as Overdue,<br> 'Due in Next Seven Days' as NextSevenDays,<br> 'Due in Over Seven Days' as OverSevenDays,<br> (SELECT STUFF( ( SELECT DISTINCT ', ' + t3.Analysis<br> FROM sample s3<br> INNER JOIN test t3 ON s3.Sample_number = t3.Sample_number<br> WHERE Project = p.name<br> AND t3.status NOT IN ('A','C','X')<br> ORDER BY ', ' + Analysis<br> FOR XML PATH('')),1, 1,'')) AS [OutstandingAnalyses] ,<br> (SELECT STUFF( ( SELECT DISTINCT ', ' + t4.Analysis<br> FROM sample s4<br> INNER JOIN test t4 ON s4.Sample_number = t4.Sample_number<br> WHERE Project = p.name<br> AND t4.status IN ('A','C','X')<br> ORDER BY ', ' + Analysis<br> FOR XML PATH('')),1, 1,'')) AS [CompletedAnalyses] ,<br> Case when (select min(DateDue) from Test<br> inner join sample on Test.Sample_Number = Sample.Sample_Number<br> where Sample.Project = p.Name and Test.Status != 'X' and Test.Status != 'A') < dateAdd(day,datediff(day,0,dateAdd(day,1,getDate())),0) then 'overdue'<br> when (select min(DateDue) from Test<br> inner join sample on Test.Sample_Number = Sample.Sample_Number<br> where Sample.Project = p.Name and Test.Status != 'X' and Test.Status != 'A') > dateAdd(day,datediff(day,0,dateAdd(day,1,getDate())),0) then 'SevenDays'<br> else 'NextSevenDays'<br> end as WholeJobDueDateStatus<br><br>from Project p<br>inner join JobDistributions jd on p.Name = jd.JobNumber<br>inner join Sample s on p.Name = s.Project<br>inner join Test t on s.Sample_Number = t.Sample_Number<br>inner join Customer c on c.Name = p.Customer1<br>left join list_entry le on p.Quality = le.name and le.list = 'QualityCod'<br><br>where DistributionName in ($P!{Distributions})<br> and p.Archived = 0 and t.Status != 'A' and t.Status != 'X' and p.Status != 'V' and (jd.completed is null) and ISNUMERIC(jd.Value) =1 and jd.value = '1'<br> and (($P{Days} = 0)<br> OR<br> ((DATEADD(dd,-CAST($P{Days} AS Integer),GetDate()) >=<br> (select min(DateDue) from Test<br> inner join<br> sample<br> on Test.Sample_Number = Sample.Sample_Number<br> where Sample.Project = p.Name and Test.Status != 'X' and Test.Status != 'A') ) AND ($P{Days} <> 0)))<br> $P!{pMaterialTypeFilterSQL}<br><br>group by jd.DistributionName,p.name,jd.Value,Customer1,Company_Name,Material_Desc,Material_Type,Analysis,DateDue,LabDueDate,assay_state,Sub_Contract,Customer2,Customer3,Customer4,Quality,ISNULL(le.value,'')) x<br>$P!{pPreviousDistributionSQL}<br>order by DistOrder<br> ,PeruOrder<br> ,DistributionName desc<br> $P!{DayRecord}<br> ,MinDueDate<br> ,x.name<br> ,DateDue<br> ,Analysis]]><br> </queryString><br> <field name="Analysis" class="java.lang.String"/><br> <field name="Company_Name" class="java.lang.String"/><br> <field name="Complete" class="java.lang.Integer"/><br> <field name="Customer1" class="java.lang.String"/><br> <field name="DateDue" class="java.sql.Timestamp"/><br> <field name="DistributionName" class="java.lang.String"/><br> <field name="Incomplete" class="java.lang.Integer"/><br> <field name="MajorClient" class="java.lang.String"/><br> <field name="Material_Desc" class="java.lang.String"/><br> <field name="Material_Type" class="java.lang.String"/><br> <field name="MinDueDate" class="java.sql.Timestamp"/><br> <field name="Name" class="java.lang.String"/><br> <field name="NumAnalyses" class="java.lang.Integer"/><br> <field name="NumSamples" class="java.lang.Integer"/><br> <field name="SevenDays" class="java.sql.Timestamp"/><br> <field name="Tommorrow" class="java.sql.Timestamp"/><br> <field name="DistOrder" class="java.lang.String"/><br> <field name="Overdue" class="java.lang.String"/><br> <field name="NextSevenDays" class="java.lang.String"/><br> <field name="OverSevenDays" class="java.lang.String"/><br> <field name="Quality" class="java.lang.String"/><br> <field name="LabDueDate" class="java.sql.Timestamp"/><br> <field name="GroupDate" class="java.lang.String"/><br> <field name="QualityResolved" class="java.lang.String"/><br> <field name="OutstandingAnalyses" class="java.lang.String"/><br> <field name="CompletedAnalyses" class="java.lang.String"/><br> <field name="assay_state" class="java.lang.String"/><br> <variable name="MajorClient1" class="java.lang.String" resetType="Page"><br> <variableExpression><![CDATA[$F{MajorClient}!=null && $F{MajorClient}.substring(0,1).equals("1") ? $F{MajorClient}.substring(2) : $V{MajorClient1}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="MajorClient2" class="java.lang.String" resetType="Page"><br> <variableExpression><![CDATA[$F{MajorClient}!=null && $F{MajorClient}.substring(0,1).equals("2") ? $F{MajorClient}.substring(2) : $V{MajorClient2}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="MajorClient3" class="java.lang.String" resetType="Page"><br> <variableExpression><![CDATA[$F{MajorClient}!=null && $F{MajorClient}.substring(0,1).equals("3") ? $F{MajorClient}.substring(2) : $V{MajorClient3}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="MajorClient4" class="java.lang.String" resetType="Page"><br> <variableExpression><![CDATA[$F{MajorClient}!=null && $F{MajorClient}.substring(0,1).equals("4") ? $F{MajorClient}.substring(2) : $V{MajorClient4}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="MajorClient5" class="java.lang.String" resetType="Page"><br> <variableExpression><![CDATA[$F{MajorClient}!=null && $F{MajorClient}.substring(0,1).equals("5") ? $F{MajorClient}.substring(2) : $V{MajorClient5}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="Analyses" class="java.lang.String" resetType="Group" resetGroup="Group_2"><br> <variableExpression><![CDATA[$V{Analyses}.equals("")?<br> $F{Complete}.compareTo($F{NumAnalyses}) == 0?<br> $F{Analysis} + "*"<br> :<br> $F{Complete}.intValue() > 0 && $F{Incomplete}.intValue() > 0?<br> $F{Analysis} + "~"<br> :<br> $F{Analysis}<br>:<br> $F{Complete}.compareTo($F{NumAnalyses}) == 0?<br> $V{Analyses} + ", " + $F{Analysis} + "*"<br> :<br> $F{Complete}.intValue() > 0 && $F{Incomplete}.intValue() > 0?<br> $V{Analyses} + ", " + $F{Analysis} + "~"<br> :<br> $V{Analyses} + ", " + $F{Analysis}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="JobNumberTracker" class="java.lang.String"><br> <variableExpression><![CDATA[!$V{JobNumberTracker}.replace("*","").equals($F{Name}) ? $F{Name}+"*" : $V{JobNumberTracker}.replace("*","")]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="OverdueCount" class="java.lang.Integer" resetType="Group" resetGroup="Group_1"><br> <variableExpression><![CDATA[$V{JobNumberTracker}.contains("*") && $F{MinDueDate}!=null && $F{MinDueDate}.before($F{Tommorrow})? new Integer($V{OverdueCount}.intValue()+1) : $V{OverdueCount}]]></variableExpression><br> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression><br> </variable><br> <variable name="NextSevenDaysCount" class="java.lang.Integer" resetType="Group" resetGroup="Group_1"><br> <variableExpression><![CDATA[$V{JobNumberTracker}.contains("*") && ($F{MinDueDate}==null || $F{MinDueDate}.compareTo($F{Tommorrow}) == 0 || ($F{MinDueDate}.after($F{Tommorrow}) && $F{MinDueDate}.before($F{SevenDays})))? new Integer($V{NextSevenDaysCount}.intValue()+1) : $V{NextSevenDaysCount}]]></variableExpression><br> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression><br> </variable><br> <variable name="OverSevenDaysCount" class="java.lang.Integer" resetType="Group" resetGroup="Group_1"><br> <variableExpression><![CDATA[$V{JobNumberTracker}.contains("*") && $F{MinDueDate}!= null && ($F{MinDueDate}.compareTo($F{SevenDays}) == 0 || $F{MinDueDate}.after($F{SevenDays}) )? new Integer($V{OverSevenDaysCount}.intValue()+1) : $V{OverSevenDaysCount}]]></variableExpression><br> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression><br> </variable><br> <variable name="SummaryTableData" class="java.lang.String"><br> <variableExpression><![CDATA[!$V{SummaryTableData}.equals("")?<br> $V{SummaryTableData}.contains(","+$F{DistributionName}+"=") ? $V{SummaryTableData}.substring(0,$V{SummaryTableData}.indexOf(","+$F{DistributionName}+"=")) + "," + $F{DistributionName} + "=" + $V{OverdueCount} + "*" + $V{NextSevenDaysCount} + "*" + $V{OverSevenDaysCount} : $V{SummaryTableData} + "," + $F{DistributionName} + "=" + $V{OverdueCount} + "*" + $V{NextSevenDaysCount} + "*" + $V{OverSevenDaysCount}<br> : ","+$F{DistributionName} + "=" + $V{OverdueCount} + "*" + $V{NextSevenDaysCount} + "*" + $V{OverSevenDaysCount}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="JobCountByDateReceived" class="java.lang.Integer" resetType="Group" resetGroup="DateCreated" incrementType="Report" calculation="DistinctCount"><br> <variableExpression><![CDATA[$F{Name}]]></variableExpression><br> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression><br> </variable><br> <variable name="SampleCount" class="java.lang.Integer" resetType="Group" resetGroup="DateCreated"><br> <variableExpression><![CDATA[$V{CurrentJob}.equals("")<br>? new Integer($F{NumSamples}.intValue())<br>:<br>(!$V{CurrentJob}.equals($F{Name}))<br>? new Integer($V{SampleCount}.intValue() + $F{NumSamples}.intValue())<br>: $V{SampleCount}]]></variableExpression><br> <initialValueExpression><![CDATA[new Integer(0)]]></initialValueExpression><br> </variable><br> <variable name="CurrentJob" class="java.lang.String" resetType="Group" resetGroup="DateCreated" incrementType="Report"><br> <variableExpression><![CDATA[$F{Name}]]></variableExpression><br> <initialValueExpression><![CDATA[""]]></initialValueExpression><br> </variable><br> <variable name="overDue" class="java.lang.Long"><br> <variableExpression><![CDATA[$P{DateVersion}.equals("1")<br>?<br>new Long(($F{LabDueDate}.getTime() - $P{runDate}.getTime())/(1000 * 60 * 60 * 24))<br>:<br>new Long(($F{DateDue}.getTime() - $P{runDate}.getTime())/(1000 * 60 * 60 * 24))]]></variableExpression><br> <initialValueExpression><![CDATA[$P{DateVersion}.equals("1")<br>?<br>new Long(($F{LabDueDate}.getTime() - $P{runDate}.getTime())/(1000 * 60 * 60 * 24))<br>:<br>new Long(($F{DateDue}.getTime() - $P{runDate}.getTime())/(1000 * 60 * 60 * 24))]]></initialValueExpression><br> </variable><br> <group name="Group_1" isStartNewPage="true" isReprintHeaderOnEachPage="true"><br> <groupExpression><![CDATA[$F{DistributionName}]]></groupExpression><br> <groupHeader><br> <band height="81" splitType="Stretch"><br> <textField><br> <reportElement x="512" y="0" width="290" height="18" uuid="d8bf30b8-c67f-4e57-ae49-ddc5af2416d9"/><br> <textElement textAlignment="Right" markup="none"><br> <font fontName="SansSerif" size="12" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <textFieldExpression><![CDATA["Outstanding Analyses" + (!$P{Days}.equals("0") ? (" " + $P{Days} + " Or More Days Overdue") : "")]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="1" y="20" width="800" height="41" uuid="ccb8141f-f6e4-4cfb-a701-5bf00f4b2abd"/><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="10" isBold="true" isUnderline="false" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <textFieldExpression><![CDATA["Laboratory : " + $F{DistributionName}<br>+<br>(($P{MaterialType}.equalsIgnoreCase("All")||$P{MaterialType}.equalsIgnoreCase(""))?<br> ""<br>:<br> $P{pMaterialTypeIncOrExc}.equalsIgnoreCase( "Include" )?<br> " n Material Types: " +$P{MaterialType}.replace( "','", ", " ).replace( "'", "" )<br> :<br> "n Excluded Material Types: " + $P{MaterialType}.replace( "','", ", " ).replace( "'", "" ))]]></textFieldExpression><br> </textField><br> <staticText><br> <reportElement x="13" y="63" width="40" height="13" uuid="1e3ba12d-b1a2-4b36-a7a6-4d50c5839331"/><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Job]]></text><br> </staticText><br> <line><br> <reportElement x="0" y="76" width="802" height="1" uuid="7781f779-0c6b-444c-abc3-4b1396d158ab"/><br> </line><br> <staticText><br> <reportElement x="75" y="63" width="61" height="13" uuid="01d8d89f-b347-4335-9071-07fe64e957b4"/><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Client]]></text><br> </staticText><br> <staticText><br> <reportElement x="253" y="63" width="94" height="13" uuid="e7399c8c-6efa-4049-876e-486ebc02a50a"/><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Material Description<br>]]></text><br> </staticText><br> <staticText><br> <reportElement x="410" y="63" width="60" height="13" uuid="aca3c5bf-850e-44e4-8b72-08ae4d6dfa2d"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Material Type]]></text><br> </staticText><br> <staticText><br> <reportElement x="486" y="63" width="41" height="13" uuid="2ddd0f96-66c1-4778-acea-b4f3bf589638"><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("0") && $P{showAssayState}.equals("0")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Analysis]]></text><br> </staticText><br> <staticText><br> <reportElement x="472" y="63" width="41" height="13" uuid="b6fa4663-c5e7-4350-8253-f0d0547fede0"><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("0") && $P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Analysis]]></text><br> </staticText><br> <staticText><br> <reportElement x="715" y="63" width="45" height="13" uuid="e2750712-ccb3-4a5b-8147-a90bca6abb50"><br> <printWhenExpression><![CDATA[new Boolean($P{DateVersion}.equals("0") || $P{DateVersion}.equals("2"))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Right" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Due Date]]></text><br> </staticText><br> <subreport><br> <reportElement x="24" y="0" width="258" height="20" uuid="42439b00-9ac8-48a3-b10a-d2f5e118ae78"/><br> <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression><br> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><br> <subreportExpression><![CDATA[".//Reports//CompanyNameSub.jasper"]]></subreportExpression><br> </subreport><br> <image><br> <reportElement positionType="Float" x="0" y="0" width="24" height="20" uuid="e9322b4f-137a-4869-a2bc-93d455ee2d16"/><br> <imageExpression><![CDATA["Reports/Icons/CompanyLogo.jpg"]]></imageExpression><br> </image><br> <line><br> <reportElement x="0" y="20" width="802" height="1" uuid="2b6acf02-9715-4433-994c-f4c496adf194"/><br> </line><br> <line><br> <reportElement x="0" y="62" width="802" height="1" uuid="937d90c9-052d-4f31-8e11-d236723f7681"/><br> </line><br> <staticText><br> <reportElement x="672" y="63" width="43" height="13" uuid="cdd6def6-5be9-46c9-a3ad-5c3aca125d9f"><br> <printWhenExpression><![CDATA[new Boolean($P{DateVersion}.equals("1") || $P{DateVersion}.equals("2"))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Right" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Lab Date]]></text><br> </staticText><br> <staticText><br> <reportElement x="760" y="63" width="42" height="13" uuid="53cbe8e9-7db7-442c-a7d8-defbde7734ac"><br> <printWhenExpression><![CDATA[$P{showDaysOverDue}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Right" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Overdue]]></text><br> </staticText><br> <staticText><br> <reportElement x="477" y="63" width="90" height="13" uuid="5299926a-5136-4e13-9598-3b68167087b2"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("0")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Analysis (Outstanding / ]]></text><br> </staticText><br> <staticText><br> <reportElement mode="Transparent" x="567" y="63" width="88" height="13" forecolor="#999999" backcolor="#999999" uuid="52387871-8f5f-4336-b5ab-cf9575999f05"><br> <property name="com.jaspersoft.studio.unit.x" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("0")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" isItalic="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[ Completed)]]></text><br> </staticText><br> <staticText><br> <reportElement x="472" y="63" width="90" height="13" uuid="ea81c10d-488b-48cf-882e-443a78ac89ac"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Analysis (Outstanding / ]]></text><br> </staticText><br> <staticText><br> <reportElement mode="Transparent" x="561" y="63" width="88" height="13" forecolor="#999999" backcolor="#999999" uuid="63990224-b091-4be2-b417-269c0051f5ec"><br> <property name="com.jaspersoft.studio.unit.x" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" isItalic="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[ Completed)]]></text><br> </staticText><br> <staticText><br> <reportElement x="620" y="63" width="51" height="13" uuid="67162568-57ec-4f5c-84bd-7df9016b2a11"><br> <printWhenExpression><![CDATA[$P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Left" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Assay State]]></text><br> </staticText><br> </band><br> </groupHeader><br> </group><br> <group name="DateCreated"><br> <groupExpression><![CDATA[$F{GroupDate}]]></groupExpression><br> <groupHeader><br> <band height="16" splitType="Stretch"><br> <printWhenExpression><![CDATA[new Boolean($P{pGroupByDayRec}.equals("1"))]]></printWhenExpression><br> <textField><br> <reportElement mode="Opaque" x="0" y="1" width="801" height="13" backcolor="#C0C0C0" uuid="d9137ef4-6d8e-4a39-965c-0e873870377c"/><br> <box topPadding="0" leftPadding="1" bottomPadding="0" rightPadding="0"><br> <pen lineWidth="0.0" lineStyle="Solid"/><br> </box><br> <textElement><br> <font isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{pPreviousDistribution}.replaceAll("'", "") + " " + "Finished: " + $F{GroupDate}]]></textFieldExpression><br> </textField><br> </band><br> </groupHeader><br> <groupFooter><br> <band height="14" splitType="Stretch"><br> <printWhenExpression><![CDATA[new Boolean($P{pGroupByDayRec}.equals("1"))]]></printWhenExpression><br> <textField><br> <reportElement x="0" y="1" width="138" height="13" uuid="7ce0ebfb-3d1a-4f06-962c-78e10c7eccf3"/><br> <textElement verticalAlignment="Middle" markup="none"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <textFieldExpression><![CDATA["Total No Of Jobs: " + $V{JobCountByDateReceived}.toString()]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="138" y="1" width="141" height="13" uuid="9f268e5c-b124-4af0-9713-886f5e3a0c15"/><br> <textElement verticalAlignment="Middle" markup="none"><br> <font fontName="SansSerif" size="8" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <textFieldExpression><![CDATA["Total No Of Samples: " + $V{SampleCount}.toString()]]></textFieldExpression><br> </textField><br> </band><br> </groupFooter><br> </group><br> <group name="Group_2"><br> <groupExpression><![CDATA[$P{DateVersion}.equals("0") || $P{DateVersion}.equals("2") ? $F{Name}+$F{Customer1}+$F{DateDue} : $F{Name}+$F{Customer1}+$F{LabDueDate}]]></groupExpression><br> <groupFooter><br> <band height="24" splitType="Stretch"><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> <textField><br> <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="802" height="12" backcolor="#FFBFBF" uuid="b0409e8f-9e20-428d-9817-efc6a9fa0979"><br> <printWhenExpression><![CDATA[new Boolean($F{MajorClient}.substring(2).equals($V{MajorClient1}))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="802" height="12" backcolor="#BBDDFF" uuid="a83b8eb6-f256-4f65-a2ea-13ac8a27ca9c"><br> <printWhenExpression><![CDATA[new Boolean($F{MajorClient}.substring(2).equals($V{MajorClient2}))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="802" height="12" backcolor="#CEFFCE" uuid="cfbf3657-6a8b-430b-a798-7c1e6a794563"><br> <printWhenExpression><![CDATA[new Boolean($F{MajorClient}.substring(2).equals($V{MajorClient3}))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="802" height="12" backcolor="#E4E4E4" uuid="c9823d91-4fb4-4205-912c-230f9308d7bb"><br> <printWhenExpression><![CDATA[new Boolean($F{MajorClient}.substring(2).equals($V{MajorClient4}))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="802" height="12" backcolor="#FFFFC6" uuid="ecdc3dd6-b59a-40cc-a3e5-72fed0591bc1"><br> <printWhenExpression><![CDATA[new Boolean($F{MajorClient}.substring(2).equals($V{MajorClient5}))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement x="486" y="0" width="176" height="12" uuid="e04a9139-e187-40ab-adb3-94eba03be346"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("0") && $P{showAssayState}.equals("0")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{Analyses}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement x="472" y="0" width="126" height="12" uuid="d9548a33-87e2-4876-907c-3428e6009864"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <property name="com.jaspersoft.studio.unit.x" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("0") && $P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{Analyses}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement x="715" y="0" width="45" height="12" uuid="6740330b-6943-49b4-af32-3367183da25c"><br> <printWhenExpression><![CDATA[new Boolean($P{DateVersion}.equals("0") || $P{DateVersion}.equals("2"))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Right" verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{DateDue} != null ? new SimpleDateFormat("dd MMM yy").format($F{DateDue}) : "No Date"]]></textFieldExpression><br> </textField><br> <frame><br> <reportElement isPrintRepeatedValues="false" x="0" y="0" width="485" height="12" uuid="fbf8097d-ad51-4257-a3e1-06bf6165cb4a"/><br> <textField><br> <reportElement x="13" y="0" width="60" height="12" uuid="c3be1e79-b646-4cb5-92e4-f5a2e35271d8"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{NumSamples}.intValue() > 1 ? $F{Name} + "/1-" + $F{NumSamples} : $F{Name} + "/1"]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="75" y="0" width="177" height="12" uuid="42992eb1-fe0a-4698-b694-7a426d4dfc63"/><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{Company_Name}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="253" y="0" width="155" height="12" uuid="8ec99896-7a0f-492a-9ab4-7f391100ea77"/><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{resolveQualityCode}.equals("0")<br>?<br>($F{Quality} + " " + $F{Material_Desc}).trim()<br>:<br>($F{QualityResolved} + " " + $F{Material_Desc}).trim()]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="410" y="0" width="60" height="12" uuid="61b03c92-c8bb-416b-97cf-9ca9c2f3f2c1"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{Material_Type}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Opaque" x="3" y="3" width="6" height="6" backcolor="#FF0000" uuid="0c404e4b-b892-4382-a375-6b8882f3d7d1"><br> <printWhenExpression><![CDATA[new Boolean($F{MinDueDate}!=null && $F{MinDueDate}.before($F{Tommorrow}))]]></printWhenExpression><br> </reportElement><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> <ellipse><br> <reportElement x="3" y="3" width="6" height="6" forecolor="#0000FF" backcolor="#0000FF" uuid="52b8e1b5-cee9-4664-afcb-d86bc6d31b5c"><br> <printWhenExpression><![CDATA[new Boolean($F{MinDueDate}!=null && ($F{MinDueDate}.compareTo($F{Tommorrow}) == 0) || ($F{MinDueDate}.after($F{Tommorrow}) && $F{MinDueDate}.before($F{SevenDays})))]]></printWhenExpression><br> </reportElement><br> </ellipse><br> </frame><br> <textField isStretchWithOverflow="true"><br> <reportElement x="477" y="0" width="182" height="12" uuid="e50f0ec4-3d61-49e0-bcfc-0146ca3557b9"><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("0")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[($F{OutstandingAnalyses} == null || $F{OutstandingAnalyses}.equals(""))<br>? "(None)"<br>: $F{OutstandingAnalyses}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement positionType="FixRelativeToBottom" stretchType="RelativeToBandHeight" x="472" y="12" width="135" height="12" isRemoveLineWhenBlank="true" forecolor="#999999" uuid="d69050da-a34e-4f2f-a82b-e3c865ee29e6"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <property name="com.jaspersoft.studio.unit.x" value="px"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8" isItalic="true" isUnderline="false"/><br> </textElement><br> <textFieldExpression><![CDATA[($F{CompletedAnalyses} == null || $F{CompletedAnalyses}.equals(""))<br>? "(None)"<br>: $F{CompletedAnalyses}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement x="472" y="0" width="135" height="12" uuid="4dff7152-d77a-4382-a1f1-81fb6abb7ffd"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[($F{OutstandingAnalyses} == null || $F{OutstandingAnalyses}.equals(""))<br>? "(None)"<br>: $F{OutstandingAnalyses}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement stretchType="RelativeToBandHeight" x="477" y="12" width="182" height="12" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true" forecolor="#999999" uuid="2a4faa28-497b-4d87-80fd-fece71047c9a"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> <printWhenExpression><![CDATA[$P{showCompAnalysisSeparate}.equals("1") && $P{showAssayState}.equals("0")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8" isItalic="true" isUnderline="false"/><br> </textElement><br> <textFieldExpression><![CDATA[($F{CompletedAnalyses} == null || $F{CompletedAnalyses}.equals(""))<br>? "(None)"<br>: $F{CompletedAnalyses}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement x="672" y="0" width="43" height="12" uuid="f18ddff0-a7cb-43de-b5e6-7b67712a7616"><br> <printWhenExpression><![CDATA[new Boolean($P{DateVersion}.equals("1") || $P{DateVersion}.equals("2"))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Right" verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{LabDueDate} != null ? new SimpleDateFormat("dd MMM yy").format($F{LabDueDate}) : "No Date"]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false"><br> <reportElement x="760" y="0" width="42" height="12" forecolor="#FF0000" uuid="e07d2001-319a-4217-a0c0-97466a1956b3"><br> <printWhenExpression><![CDATA[new Boolean(($V{overDue}.longValue() < 1) && $P{showDaysOverDue}.equals("1"))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Right" verticalAlignment="Middle"><br> <font size="8" isBold="true"/><br> </textElement><br> <textFieldExpression><![CDATA[Math.abs($V{overDue}) + " Day(s)"]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true"><br> <reportElement x="620" y="0" width="51" height="12" uuid="bde7b5a6-f358-461b-8344-763b97ef18cc"><br> <printWhenExpression><![CDATA[$P{showAssayState}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{assay_state}]]></textFieldExpression><br> </textField><br> </band><br> </groupFooter><br> </group><br> <detail><br> <band splitType="Stretch"/><br> </detail><br> <pageFooter><br> <band height="34" splitType="Stretch"><br> <line><br> <reportElement x="0" y="0" width="802" height="1" uuid="5237aa14-2548-467b-a926-b01c716e024a"/><br> </line><br> <textField><br> <reportElement x="0" y="23" width="178" height="11" uuid="0af42299-6379-480e-9dcd-472f443d2f8c"/><br> <textElement><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA["Created Date: " + new SimpleDateFormat("dd MMM yyyy HH:mm").format(new Date())]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Opaque" x="0" y="3" width="81" height="12" backcolor="#FFBFBF" uuid="e870745d-3c30-4115-bbe4-336cc6c68bc9"><br> <printWhenExpression><![CDATA[new Boolean(!$V{MajorClient1}.equals(""))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{MajorClient1}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Opaque" x="82" y="3" width="81" height="12" backcolor="#BBDDFF" uuid="4cf1557d-4b5d-4827-9f4b-9ce0ca06c813"><br> <printWhenExpression><![CDATA[new Boolean(!$V{MajorClient2}.equals(""))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{MajorClient2}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Opaque" x="164" y="3" width="81" height="12" backcolor="#CEFFCE" uuid="e902a6eb-67db-407f-b9bc-607658e01be1"><br> <printWhenExpression><![CDATA[new Boolean(!$V{MajorClient3}.equals(""))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{MajorClient3}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Opaque" x="246" y="3" width="81" height="12" backcolor="#E4E4E4" uuid="f4c0e5d9-f986-42cb-951a-fb1f60b01c4b"><br> <printWhenExpression><![CDATA[new Boolean(!$V{MajorClient4}.equals(""))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{MajorClient4}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Opaque" x="328" y="3" width="81" height="12" backcolor="#FFFFC6" uuid="fa5829dd-a258-4ced-a17e-fbc7121156e7"><br> <printWhenExpression><![CDATA[new Boolean(!$V{MajorClient5}.equals(""))]]></printWhenExpression><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{MajorClient5}]]></textFieldExpression><br> </textField><br> <staticText><br> <reportElement x="557" y="3" width="49" height="9" forecolor="#000000" uuid="9c56cb96-9ca3-4994-9b61-907183f4ff15"/><br> <textElement><br> <font fontName="SansSerif" size="7" isBold="false" pdfFontName="Helvetica"/><br> </textElement><br> <text><![CDATA[Jobs Overdue]]></text><br> </staticText><br> <staticText><br> <reportElement x="557" y="12" width="85" height="9" forecolor="#000000" uuid="ab6bbd5c-5ef0-4bc9-910b-e1166bf274f7"/><br> <textElement><br> <font fontName="SansSerif" size="7" isBold="false"/><br> </textElement><br> <text><![CDATA[Jobs Due in Next 7 Days]]></text><br> </staticText><br> <staticText><br> <reportElement x="656" y="3" width="146" height="9" uuid="06a7b8f8-1a6c-49a0-93f1-1220a89f2abc"><br> <printWhenExpression><![CDATA[!$P{showCompAnalysisSeparate}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement><br> <font fontName="SansSerif" size="7" isBold="false"/><br> </textElement><br> <text><![CDATA[* All tests are Complete or Authorised]]></text><br> </staticText><br> <staticText><br> <reportElement x="656" y="12" width="146" height="9" uuid="4b3aa356-a73b-458e-933b-032ff23aef77"><br> <printWhenExpression><![CDATA[!$P{showCompAnalysisSeparate}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement><br> <font fontName="SansSerif" size="7" isBold="false"/><br> </textElement><br> <text><![CDATA[~ Some tests are Complete or Authorised and<br> ]]></text><br> </staticText><br> <staticText><br> <reportElement x="662" y="20" width="140" height="9" uuid="ff7adcbb-f7e4-4033-bf11-934ba5bf6ec8"><br> <printWhenExpression><![CDATA[!$P{showCompAnalysisSeparate}.equals("1")]]></printWhenExpression><br> </reportElement><br> <textElement><br> <font fontName="SansSerif" size="7" isBold="false"/><br> </textElement><br> <text><![CDATA[some are Incomplete or In-Progress<br> ]]></text><br> </staticText><br> <textField><br> <reportElement mode="Opaque" x="549" y="5" width="6" height="6" backcolor="#FF0000" uuid="c1812cd9-d426-4b0f-96db-0fda4d9b3e16"/><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> <ellipse><br> <reportElement x="549" y="14" width="6" height="6" forecolor="#0000FF" backcolor="#0000FF" uuid="6032d466-c11b-4b1f-90dd-4411b7a12ead"/><br> </ellipse><br> <textField><br> <reportElement x="368" y="23" width="43" height="11" uuid="165df1cc-7f53-45c4-ad9b-2ab8827f7ddc"/><br> <textElement textAlignment="Right"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}.toString() + " of"]]></textFieldExpression><br> </textField><br> <textField evaluationTime="Report"><br> <reportElement x="414" y="23" width="20" height="11" uuid="8555d6d0-d1c1-4016-b42e-a60f38ef1ffe"/><br> <textElement textAlignment="Left"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}.toString()]]></textFieldExpression><br> </textField><br> </band><br> </pageFooter><br> <summary><br> <band height="533" splitType="Stretch"><br> <crosstab><br> <reportElement x="22" y="43" width="193" height="473" uuid="f49661e7-a616-4548-ac36-b0d30b3fe245"/><br> <crosstabParameter name="SummaryTableData"><br> <parameterValueExpression><![CDATA[$V{SummaryTableData}+","]]></parameterValueExpression><br> </crosstabParameter><br> <crosstabParameter name="DistinctOverdueCount"/><br> <crosstabParameter name="Days"><br> <parameterValueExpression><![CDATA[]]></parameterValueExpression><br> </crosstabParameter><br> <crosstabDataset isDataPreSorted="true"/><br> <crosstabHeaderCell><br> <cellContents><br> <textField><br> <reportElement x="0" y="0" width="137" height="30" uuid="9cb5d78b-67dd-42f3-ba1b-f16c9928454c"/><br> <box padding="0"><br> <topPen lineWidth="0.0" lineStyle="Solid"/><br> <leftPen lineWidth="0.0" lineStyle="Solid"/><br> <bottomPen lineWidth="0.5" lineStyle="Solid"/><br> <rightPen lineWidth="0.0" lineStyle="Solid"/><br> </box><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[""]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabHeaderCell><br> <rowGroup name="RowGroup_3" width="137"><br> <bucket order="Descending" class="java.lang.String"><br> <bucketExpression><![CDATA[$F{DistributionName}]]></bucketExpression><br> </bucket><br> <crosstabRowHeader><br> <cellContents><br> <textField><br> <reportElement x="0" y="0" width="137" height="16" uuid="3ddac321-5acf-4189-aec2-cdc4780eae72"/><br> <box padding="0"><br> <topPen lineWidth="0.0" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.5" lineStyle="Solid"/><br> <rightPen lineWidth="0.0" lineStyle="Solid"/><br> </box><br> <textElement verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[" " +$V{RowGroup_3}]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabRowHeader><br> <crosstabTotalRowHeader><br> <cellContents/><br> </crosstabTotalRowHeader><br> </rowGroup><br> <columnGroup name="ColumnGroup_3" height="30"><br> <bucket class="java.lang.String"><br> <bucketExpression><![CDATA[!$P{Days}.equals("0") ? $P{Days} + " Or More Days Overdue" : $F{Overdue}]]></bucketExpression><br> </bucket><br> <crosstabColumnHeader><br> <cellContents><br> <textField isStretchWithOverflow="true"><br> <reportElement mode="Transparent" x="0" y="0" width="55" height="30" backcolor="#FFFFFF" uuid="ab08400a-7e29-4bcb-ba9d-76df2006d6ac"/><br> <box padding="0"><br> <pen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{ColumnGroup_3}]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabColumnHeader><br> <crosstabTotalColumnHeader><br> <cellContents/><br> </crosstabTotalColumnHeader><br> </columnGroup><br> <measure name="Measure_1" class="java.lang.String"><br> <measureExpression><![CDATA[$V{SummaryTableData}]]></measureExpression><br> </measure><br> <crosstabCell width="55" height="16"><br> <cellContents><br> <textField><br> <reportElement x="0" y="0" width="55" height="16" uuid="5f43fae6-6a8d-4bd8-aeee-2fb9b16b9cd6"/><br> <box padding="0"><br> <topPen lineWidth="0.0" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.5" lineStyle="Solid"/><br> <rightPen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false" pdfFontName="Helvetica" pdfEncoding="Cp1252"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{SummaryTableData}.substring($P{SummaryTableData}.indexOf(","+$V{RowGroup_3}+"="),$P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf(","+$V{RowGroup_3}+"="))).replace(","+$V{RowGroup_3}+"=","")]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabCell><br> <whenNoDataCell><br> <cellContents/><br> </whenNoDataCell><br> </crosstab><br> <crosstab><br> <reportElement x="215" y="43" width="60" height="473" uuid="2834ac5c-bbfc-43ef-9932-6f38ad514d08"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <crosstabParameter name="SummaryTableData"><br> <parameterValueExpression><![CDATA[$V{SummaryTableData}+","]]></parameterValueExpression><br> </crosstabParameter><br> <crosstabDataset isDataPreSorted="true"/><br> <crosstabHeaderCell><br> <cellContents/><br> </crosstabHeaderCell><br> <rowGroup name="RowGroup_3" width="1"><br> <bucket order="Descending" class="java.lang.String"><br> <bucketExpression><![CDATA[$F{DistributionName}]]></bucketExpression><br> </bucket><br> <crosstabRowHeader><br> <cellContents/><br> </crosstabRowHeader><br> <crosstabTotalRowHeader><br> <cellContents/><br> </crosstabTotalRowHeader><br> </rowGroup><br> <columnGroup name="ColumnGroup_3" height="30"><br> <bucket class="java.lang.String"><br> <bucketExpression><![CDATA[$F{NextSevenDays}]]></bucketExpression><br> </bucket><br> <crosstabColumnHeader><br> <cellContents><br> <textField><br> <reportElement x="0" y="0" width="54" height="30" uuid="54262230-265a-42a7-82d6-b6f3e965c4f7"/><br> <box padding="0"><br> <pen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{ColumnGroup_3}]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabColumnHeader><br> <crosstabTotalColumnHeader><br> <cellContents/><br> </crosstabTotalColumnHeader><br> </columnGroup><br> <measure name="Measure_1" class="java.lang.String"><br> <measureExpression><![CDATA[$V{SummaryTableData}]]></measureExpression><br> </measure><br> <crosstabCell width="56" height="16"><br> <cellContents><br> <textField><br> <reportElement x="0" y="0" width="54" height="16" uuid="a991457e-997a-46a7-89d4-4486f7a1a47b"/><br> <box padding="0"><br> <topPen lineWidth="0.0" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.5" lineStyle="Solid"/><br> <rightPen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{SummaryTableData}.substring($P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf(","+$V{RowGroup_3}+"="))+1,$P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf(","+$V{RowGroup_3}+"="))+1))]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabCell><br> <whenNoDataCell><br> <cellContents/><br> </whenNoDataCell><br> </crosstab><br> <crosstab><br> <reportElement x="271" y="43" width="93" height="473" uuid="600851b2-bd72-4514-81f1-d36a9526d307"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <crosstabParameter name="SummaryTableData"><br> <parameterValueExpression><![CDATA[$V{SummaryTableData}+","]]></parameterValueExpression><br> </crosstabParameter><br> <crosstabDataset isDataPreSorted="true"/><br> <crosstabHeaderCell><br> <cellContents/><br> </crosstabHeaderCell><br> <rowGroup name="RowGroup_3" width="1"><br> <bucket order="Descending" class="java.lang.String"><br> <bucketExpression><![CDATA[$F{DistributionName}]]></bucketExpression><br> </bucket><br> <crosstabRowHeader><br> <cellContents/><br> </crosstabRowHeader><br> <crosstabTotalRowHeader><br> <cellContents/><br> </crosstabTotalRowHeader><br> </rowGroup><br> <columnGroup name="ColumnGroup_3" height="30"><br> <bucket class="java.lang.String"><br> <bucketExpression><![CDATA[$F{OverSevenDays}]]></bucketExpression><br> </bucket><br> <crosstabColumnHeader><br> <cellContents><br> <textField><br> <reportElement x="0" y="0" width="54" height="30" uuid="412d29fa-113f-45c3-8a31-bbfff2a1a45d"/><br> <box padding="0"><br> <pen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font size="8" isItalic="false" pdfFontName="Helvetica"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{ColumnGroup_3}]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabColumnHeader><br> <crosstabTotalColumnHeader><br> <cellContents/><br> </crosstabTotalColumnHeader><br> </columnGroup><br> <measure name="Measure_1" class="java.lang.String"><br> <measureExpression><![CDATA[$V{SummaryTableData}]]></measureExpression><br> </measure><br> <crosstabCell width="56" height="16"><br> <cellContents><br> <textField><br> <reportElement x="0" y="0" width="54" height="16" uuid="2c956176-a234-4b20-aa6b-d65e42c5465b"/><br> <box padding="0"><br> <topPen lineWidth="0.0" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.5" lineStyle="Solid"/><br> <rightPen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isItalic="false" pdfFontName="Helvetica"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{SummaryTableData}.substring($P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf(","+$V{RowGroup_3}+"="))+1)+1,$P{SummaryTableData}.indexOf(",",$P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf("*",$P{SummaryTableData}.indexOf(","+$V{RowGroup_3}+"="))+1)))]]></textFieldExpression><br> </textField><br> </cellContents><br> </crosstabCell><br> <whenNoDataCell><br> <cellContents/><br> </whenNoDataCell><br> </crosstab><br> <staticText><br> <reportElement x="22" y="23" width="65" height="13" uuid="eedd5626-96df-445e-b02f-e8868d6f4418"/><br> <textElement><br> <font fontName="SansSerif" size="8" isBold="true"/><br> </textElement><br> <text><![CDATA[summary]]></text><br> </staticText><br> <textField><br> <reportElement mode="Transparent" x="485" y="43" width="55" height="30" backcolor="#FFFFFF" uuid="02924d61-9bb0-4827-a38e-e5a9f386e106"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <box padding="0"><br> <topPen lineWidth="0.5" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.0" lineStyle="Solid"/><br> <rightPen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false" pdfFontName="Helvetica"/><br> </textElement><br> <textFieldExpression><![CDATA["Overdue"]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="485" y="71" width="55" height="18" uuid="bc3f724a-33d0-43b7-9be0-9b1e5ec2fdb6"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <box padding="0"><br> <pen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false" pdfFontName="Helvetica"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{DistinctOverdueCount}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Transparent" x="542" y="43" width="55" height="30" backcolor="#FFFFFF" uuid="7bfddd70-6203-4b0c-944f-ee3c0fc2cb10"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <box padding="0"><br> <topPen lineWidth="0.5" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.0" lineStyle="Solid"/><br> <rightPen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA["Due in Next Seven Days"]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement mode="Transparent" x="599" y="43" width="55" height="30" backcolor="#FFFFFF" uuid="4da411f6-3e58-4cb7-a79a-014b302f085e"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <box padding="0"><br> <topPen lineWidth="0.5" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.0" lineStyle="Solid"/><br> <rightPen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false" isItalic="false" pdfFontName="Helvetica"/><br> </textElement><br> <textFieldExpression><![CDATA["Due in Over Seven Days"]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="542" y="71" width="55" height="18" uuid="7d1640a5-609f-452a-92c9-0cc1c2856972"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <box padding="0"><br> <pen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{DistinctNextSevenDaysCount}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="599" y="71" width="55" height="18" uuid="45a1bbb6-7151-4be2-8f02-ea4be3d8329f"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <box padding="0"><br> <pen lineWidth="0.5" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false" isItalic="false" pdfFontName="Helvetica"/><br> </textElement><br> <textFieldExpression><![CDATA[$P{DistinctOverSevenDaysCount}]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="399" y="71" width="86" height="18" uuid="0776ed63-d36e-4ad3-936f-eb4f8822b109"><br> <printWhenExpression><![CDATA[new Boolean($P{Days}.equals("0"))]]></printWhenExpression><br> </reportElement><br> <box padding="0"><br> <topPen lineWidth="0.5" lineStyle="Solid"/><br> <leftPen lineWidth="0.5" lineStyle="Solid"/><br> <bottomPen lineWidth="0.5" lineStyle="Solid"/><br> <rightPen lineWidth="0.0" lineStyle="Solid"/><br> </box><br> <textElement textAlignment="Left" verticalAlignment="Middle"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[" Total"]]></textFieldExpression><br> </textField><br> <textField><br> <reportElement x="0" y="521" width="178" height="11" uuid="493ea5f8-1c2d-467b-b5fe-2d3c72b6c66c"/><br> <textElement><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA["Created Date: " + new SimpleDateFormat("dd MMM yyyy HH:mm").format(new Date())]]></textFieldExpression><br> </textField><br> <line><br> <reportElement x="0" y="515" width="802" height="1" uuid="258c082f-e80b-4fa9-9e63-5232db8d654a"/><br> </line><br> <subreport><br> <reportElement x="24" y="0" width="258" height="20" uuid="4c67905a-2969-4167-8810-820fc15e107b"/><br> <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression><br> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><br> <subreportExpression><![CDATA[".//Reports//CompanyNameSub.jasper"]]></subreportExpression><br> </subreport><br> <image><br> <reportElement positionType="Float" x="0" y="0" width="24" height="20" uuid="6d4b1b81-816b-4d50-82ca-6698535ae4eb"/><br> <imageExpression><![CDATA["Reports/Icons/CompanyLogo.jpg"]]></imageExpression><br> </image><br> <staticText><br> <reportElement x="536" y="0" width="266" height="18" uuid="4ea63f2b-cfd1-4bd2-a376-3723b36fe923"/><br> <textElement textAlignment="Right"><br> <font fontName="SansSerif" size="12" isBold="true" pdfFontName="Helvetica-Bold"/><br> </textElement><br> <text><![CDATA[Outstanding Analyses]]></text><br> </staticText><br> <line><br> <reportElement x="0" y="20" width="802" height="1" uuid="45391266-8c3c-479f-a881-bb48128b1375"/><br> </line><br> <textField><br> <reportElement x="368" y="521" width="43" height="11" uuid="d4e6dcd2-845b-4b14-9b2a-23afec9fd124"/><br> <textElement textAlignment="Right"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}.toString() + " of"]]></textFieldExpression><br> </textField><br> <textField evaluationTime="Report"><br> <reportElement x="414" y="521" width="20" height="11" uuid="9a85137e-b317-490f-a1c8-6b38c7ec85af"/><br> <textElement textAlignment="Left"><br> <font fontName="SansSerif" size="8" isBold="false"/><br> </textElement><br> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}.toString()]]></textFieldExpression><br> </textField><br> </band><br> </summary><br></jasperReport><br>[/code] Link to comment Share on other sites More sharing options...
Ankur Gupta Posted May 10, 2018 Share Posted May 10, 2018 Hi Christopher, I tried the code you have pasted, what I can see the issue is that there is not enough space to squezze the amount of data being printed in that band, I would suggest try couple of things1. Try increasing the height of the Group Footer Band2. There is property called Keep Together in the advanced Properties in the Footer Band Property, make it true which is currently false- this should work.Let me know if this helps.Thanks Ankur Gupta Link to comment Share on other sites More sharing options...
riodavid Posted May 10, 2018 Share Posted May 10, 2018 Hi Chris,I noticed you set [completed analyses] field to be [fixed relative to top]. You should set it to [float].BRD Link to comment Share on other sites More sharing options...
christopher.astles Posted May 10, 2018 Author Share Posted May 10, 2018 @Ankur Gupta - when I change the band height the large strings fit, but it means that if there is a string of just one line there are unnecessary large gaps. Keep Together does not seem to have made a difference Link to comment Share on other sites More sharing options...
christopher.astles Posted May 10, 2018 Author Share Posted May 10, 2018 @ riodavid When it's set to 'float', that's when I get the blank fields in the second picture of my OP, shown below Link to comment Share on other sites More sharing options...
riodavid Posted May 11, 2018 Share Posted May 11, 2018 OK. Looks like you have put many expressions(some of the expressions are totally identical?) at the same place, it may cause over lap issue. Try put one textfield only. Float should be the right option. Link to comment Share on other sites More sharing options...
christopher.astles Posted May 17, 2018 Author Share Posted May 17, 2018 Hello, the multiple fields will never show at the same time, because of the 'Print When Expression' set against them. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now