christopher.astles's Content - Jaspersoft Community

Group footer field not printing when overflowing

christopher.astles replied to christopher.astles's topic in Products

Hello, the multiple fields will never show at the same time, because of the 'Print When Expression' set against them.

Start New Page for Excel only

christopher.astles replied to christopher.astles's topic in Products

@shertage sorry for the slow response - the email notification went to my spam and in the end we did the report a different way. I tried your suggestion but it still creates a new pdf page every time the group changes, and because of <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="false"/>[/code]now the groups don't come out on different tabs

Group footer field not printing when overflowing

christopher.astles replied to christopher.astles's topic in Products

@ riodavid When it's set to 'float', that's when I get the blank fields in the second picture of my OP, shown below

Group footer field not printing when overflowing

christopher.astles replied to christopher.astles's topic in Products

@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

Group footer field not printing when overflowing

christopher.astles posted a topic in Products

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

Start New Page for Excel only

christopher.astles posted a topic in Products

I want to create a report which will break at natural places when exported to PDF, but I want to use the 'Start New Page' property on the group when exporting to Excel, so that I can combine this with the net.sf.jasperreports.export.xls.one.page.per.sheet property to have all of my groups on different sheets within my excel. Is there a way to do this?

Crosstab borders between groups

christopher.astles posted a topic in Products

I'm trying to create a report showing analyses grouped by element. I tried putting a line at the bottom of each of the cells below... However, when I generate the report, if there is an element which spans two pages then I get this... Is there any way to stop this from happening? Preference would be for there to be no line at all there, but alternatively to make sure that the element never spans pages would also be suitable. Thanks in advance.

Stretch with overflow on crosstab - size bug

christopher.astles replied to chriswt314's topic in Products

I managed to find the solution to the problem that I was having. It was because the totals are considered a different entity to the row group text fields, and as such were only stretching to the tallest among the totals, so I had to change to strech Relative to Band Height. "Container height" seems to do the trick too

JasperReport Excel export cuts content after wordwrap (Stretch with overflow)

christopher.astles replied to parthbhagat's topic in Products

I'm also experiencing this problem, if anyone has any suggestions?

Stretch with overflow on crosstab - size bug

christopher.astles replied to chriswt314's topic in Products

Dear Chris and Chris, I am also having this problem, but Chris's solution didn't seem to work. My columns are headers all in line but the measures aren't stretching, even though I have the 'Stretch with Overflow' property checked and all the text fields are opaque and same background colours and styles. Hope you can help... Chris (seriously!)

Stretch With Overflow failing only on certain rows

christopher.astles posted a topic in Products

I have a report on which only some rows are stretching, but others are not. The detail band is set to stretch relative to tallest object and the field is set to Stretch With Overflow. As you can see, some other rows are stretching but the second one is not.

Sign In

christopher.astles

Posts

Joined

Last visited

Content Type

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by christopher.astles

Group footer field not printing when overflowing

Start New Page for Excel only

Group footer field not printing when overflowing

Group footer field not printing when overflowing

Group footer field not printing when overflowing

Start New Page for Excel only

Crosstab borders between groups

Stretch with overflow on crosstab - size bug

JasperReport Excel export cuts content after wordwrap (Stretch with overflow)

Stretch with overflow on crosstab - size bug

Stretch With Overflow failing only on certain rows

Activity

Products

Explore