From 26e8efcce8a38ccb2582c4711993cb8c00b12ede Mon Sep 17 00:00:00 2001
From: Lam Voong <lkv@berkeley.edu>
Date: Fri, 22 Jul 2016 10:53:25 -0700
Subject: [PATCH] Add When No Data band; update query to allow for 0 records
 returned.

---
 .../src/main/resources/coreAcquisition.jrxml    | 17 +++++++++++++++--
 1 file changed, 15 insertions(+), 2 deletions(-)

diff --git a/services/report/3rdparty/jasper-cs-report/src/main/resources/coreAcquisition.jrxml b/services/report/3rdparty/jasper-cs-report/src/main/resources/coreAcquisition.jrxml
index 2bf574434..64d93c55e 100644
--- a/services/report/3rdparty/jasper-cs-report/src/main/resources/coreAcquisition.jrxml
+++ b/services/report/3rdparty/jasper-cs-report/src/main/resources/coreAcquisition.jrxml
@@ -1,5 +1,5 @@
 <?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="object" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="08c07c03-a97f-496c-ba55-729ff2d71763">
+<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="object" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" whenNoDataType="NoDataSection" columnWidth="752" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="08c07c03-a97f-496c-ba55-729ff2d71763">
 	<property name="ireport.zoom" value="1.0"/>
 	<property name="ireport.x" value="0"/>
 	<property name="ireport.y" value="0"/>
@@ -58,7 +58,9 @@ left outer join objectproductionorganizationgroup opog on (opog.id=h6.id)
 left outer join hierarchy h7 on (ac.id=h7.parentid and h7.pos=0and h7.name='acquisitions_common:acquisitionDateGroupList')
 left outer join structureddategroup dg on (dg.id=h7.id)
 LEFT OUTER JOIN acquisitions_common_acquisitionsources aca ON (aca.id=ac.id and aca.pos=0)
-WHERE h1.name = $P{csid}
+LEFT OUTER JOIN misc m ON (m.id = co.id)
+WHERE m.lifecyclestate != 'deleted'
+AND h1.name = $P{csid}
 ORDER BY objectnumber]]>
 	</queryString>
 	<field name="acquisitionnumber" class="java.lang.String"/>
@@ -283,4 +285,15 @@ ORDER BY objectnumber]]>
 	<summary>
 		<band splitType="Stretch"/>
 	</summary>
+	<noData>
+		<band height="50">
+			<staticText>
+				<reportElement uuid="f449dbd9-0782-4ffc-9296-1c09a978c94b" style="Column header" x="0" y="22" width="375" height="28"/>
+				<textElement>
+					<font size="14"/>
+				</textElement>
+				<text><![CDATA[No related objects found for this Acquisition.]]></text>
+			</staticText>
+		</band>
+	</noData>
 </jasperReport>
-- 
2.47.3