Issue with Parameter, can't figure out.

jburczyk · January 15, 2020

Hi, I have written the program below, and I'm struggling with a "Parameter type not suppoprted in query" error. Any suggestions about what I'm doing wrong? I've used this type of parameter before, without any issues...

<?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="invoiceable_items" pageWidth="1690" pageHeight="954" orientation="Landscape" columnWidth="1690" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenResourceMissingType="Empty" uuid="7f369dea-094c-458f-97fb-6f6d351dea7f">
 <property name="net.sf.jasperreports.print.keep.full.text" value="true"/>
 <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
 <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
 <property name="com.jaspersoft.studio.data.defaultdataadapter" value="OnCore Test2"/>
 <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
 <property name="com.jaspersoft.studio.unit." value="pixel"/>
 <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
 <parameter name="fromDate" class="java.util.Date"/>
 <parameter name="thruDate" class="java.util.Date"/>
 <parameter name="ChoosePatientType" class="java.util.Collection">
 <defaultValueExpression><![CDATA[new ArrayList()]]></defaultValueExpression>
 </parameter>
 <parameter name="userContactId" class="java.lang.String" isForPrompting="false">
 <parameterDescription><![CDATA[]]></parameterDescription>
 </parameter>
 <queryString>
 <![CDATA[(select * from
 (select
summ.PROTOCOL_ID
, summ.PROTOCOL_NO
, summ.CONSENTED_COUNT
, summ.CONSENT_TOTAL_COUNT
, summ.NOT_ELIGIBLE_COUNT
, summ.ON_STUDY_COUNT
, summ.ON_TREATMENT_COUNT
, summ.OFF_TREATMENT_COUNT
, summ.OFF_STUDY_COUNT
, summ.EXPIRED_COUNT
, summ.ON_FOLLOWUP_COUNT
, summ.ON_LTFU_COUNT
, case $P{ChoosePatientType}
 when 'Consented' then CONSENT_TOTAL_COUNT
 when 'On Study' then ON_STUDY_COUNT
 when 'On Treatment' then ON_TREATMENT_COUNT
end as PATIENT_TYPE_COUNT
, hist.STATUS
, hist.START_DATE
, hist.END_DATE
, row_number() over (partition by summ.PROTOCOL_NO, hist.START_DATE order by END_DATE desc) as rn
from sv_pcl_accrual_summary summ
left outer join sv_pcl_status_history hist on summ.PROTOCOL_NO = hist.PROTOCOL_NO
where hist.START_DATE between $P{fromDate} and $P{thruDate}
and hist.STATUS in ('TERMINATED','CLOSED TO ACCRUAL','ABANDONED')
)
where rn = 1
and PATIENT_TYPE_COUNT = 0) step1
--protocol privileges
LEFT JOIN (
 SELECT protocol_id
 ,(
 CASE
 WHEN EXISTS (
 SELECT 1
 FROM sv_user_pcl_permission
 WHERE function_group = 'PROTOCOL-SEARCH'
 AND protocol_id = pcl.protocol_id
 AND contact_id = $P{userContactId}
 )
 THEN 'Y'
 ELSE 'N'
 END
 ) has_protocol_search
 FROM smrs_protocol pcl
 ) pcl_privileges ON step1.protocol_id = pcl_privileges.protocol_id]]>
 </queryString>
 <field name="PROTOCOL_ID" class="java.math.BigDecimal"/>
 <field name="PROTOCOL_NO" class="java.lang.String"/>
 <field name="CONSENTED_COUNT" class="java.math.BigDecimal"/>
 <field name="CONSENT_TOTAL_COUNT" class="java.math.BigDecimal"/>
 <field name="NOT_ELIGIBLE_COUNT" class="java.math.BigDecimal"/>
 <field name="ON_STUDY_COUNT" class="java.math.BigDecimal"/>
 <field name="ON_TREATMENT_COUNT" class="java.math.BigDecimal"/>
 <field name="OFF_TREATMENT_COUNT" class="java.math.BigDecimal"/>
 <field name="OFF_STUDY_COUNT" class="java.math.BigDecimal"/>
 <field name="EXPIRED_COUNT" class="java.math.BigDecimal"/>
 <field name="ON_FOLLOWUP_COUNT" class="java.math.BigDecimal"/>
 <field name="ON_LTFU_COUNT" class="java.math.BigDecimal"/>
 <field name="PATIENT_TYPE_COUNT" class="java.math.BigDecimal"/>
 <field name="STATUS" class="java.lang.String"/>
 <field name="START_DATE" class="java.sql.Timestamp"/>
 <field name="END_DATE" class="java.sql.Timestamp"/>
 <field name="RN" class="java.math.BigDecimal"/>
 <field name="HAS_PROTOCOL_SEARCH" class="java.lang.String"/>
 <title>
 <band height="102">
 <property name="local_mesure_unitheight" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <frame>
 <reportElement mode="Opaque" x="0" y="0" width="1690" height="72" backcolor="#006699" uuid="2f9e325f-5726-45f7-980d-45df3aefc4ea">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <staticText>
 <reportElement x="0" y="0" width="946" height="72" forecolor="#FFFFFF" uuid="c8271c97-a3f6-4dc1-83e0-f40231bdab3f">
 <property name="local_mesure_unitheight" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[Ended Protocols]]></text>
 </staticText>
 <staticText>
 <reportElement x="1221" y="0" width="465" height="72" forecolor="#FFFFFF" uuid="c89de18d-0f2f-4fe9-a2d2-6cbee0c1c1e7">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle">
 
 </textElement>
 <text><![CDATA[All protocols, by item type]]></text>
 </staticText>
 </frame>
 <frame>
 <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="72" width="1690" height="30" backcolor="#006699" uuid="a9a52697-082e-42e1-89ec-68dd0b049098">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <staticText>
 <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="88" height="30" forecolor="#FFFFFF" uuid="3afa32d5-2f7d-4eb8-a131-28fdda4bc83b"/>
 <textElement textAlignment="Right"/>
 <text><![CDATA[start Date:]]></text>
 </staticText>
 <staticText>
 <reportElement stretchType="RelativeToTallestObject" x="167" y="0" width="106" height="30" forecolor="#FFFFFF" uuid="2d71ca4b-6729-46eb-a0a4-ab7decdab5c6"/>
 <textElement textAlignment="Right"/>
 <text><![CDATA[End Date:]]></text>
 </staticText>
 <textField pattern="MM/dd/yyyy">
 <reportElement stretchType="RelativeToTallestObject" x="88" y="0" width="79" height="30" forecolor="#FFFFFF" uuid="55296cab-b55c-4bfa-95de-7c268febe10e"/>
 <textFieldExpression><![CDATA[$P{fromDate}]]></textFieldExpression>
 </textField>
 <textField pattern="MM/dd/yyyy">
 <reportElement stretchType="RelativeToTallestObject" x="273" y="0" width="72" height="30" forecolor="#FFFFFF" uuid="c091402d-3826-4336-a1f3-95cdc021eaaa"/>
 <textFieldExpression><![CDATA[$P{thruDate}]]></textFieldExpression>
 </textField>
 </frame>
 </band>
 </title>
 <columnHeader>
 <band height="22" splitType="Stretch">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <staticText>
 <reportElement mode="Opaque" x="0" y="0" width="100" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="b1dcfa37-fe41-4dd3-ba8c-1132cca71ed2"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Protocol No.]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="100" y="0" width="100" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="1928f95a-28f0-4497-995c-e008308bff8c"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Protocol Status]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="200" y="0" width="72" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="9e8369e1-45fe-4a67-845f-0a4fe441169e"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[start Date]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="272" y="0" width="72" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="fa7b5671-3185-4328-ba28-fa3f57d38c95"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[End Date]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="344" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="8448a272-89ca-4966-8527-f2c38d4d6fa0">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Consented Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="430" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="5e7fd45d-792f-499e-83b9-e2075c938224">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Total Consented Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="516" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="4a6ebe9b-a072-4f48-bf3b-a8347dc047b9"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Not Eligible Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="602" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="c591bc04-dc74-41d8-94d7-e2aab81e21fc"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[On Study Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="688" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="5c8d0443-f637-4202-9259-38a4122fc2b7"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[On Treatment Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="774" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="2c3fed66-2675-4f75-96f9-d67194495e1d"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Off Treatment Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="860" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="6822b1bc-3d29-4e50-a96a-0be70ea18855"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Off Study Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="946" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="f21fa8bd-0e0d-4f38-a6f7-dc98632918e1"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Expired Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="1032" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="0cd2dcaf-09a6-4d3d-a927-1ccb6eea7daf"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[On Followup Subjects]]></text>
 </staticText>
 <staticText>
 <reportElement mode="Opaque" x="1118" y="0" width="86" height="22" forecolor="#006699" backcolor="#E6E6E6" uuid="84e996e6-c9a7-427e-85da-56127c21d313"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <text><![CDATA[Lost to Followup Subjects]]></text>
 </staticText>
 </band>
 </columnHeader>
 <detail>
 <band height="27" splitType="Prevent">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="100" height="27" uuid="3f984aa3-f917-4330-85e8-5a07cc66650a"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement verticalAlignment="Middle"/>
 <textFieldExpression><![CDATA[$F{PROTOCOL_NO}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="100" y="0" width="100" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="da3929a7-d752-4ba9-830c-fe93ef1cdc22"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{STATUS}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="200" y="0" width="72" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="1257da62-9027-4101-b32c-504e606b701a"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{START_DATE}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="272" y="0" width="72" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="dea22672-42b8-4c4e-bca6-d0eebfcd4181"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{END_DATE}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="344" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="e5b65c06-b8c8-47fb-b1fa-a1052e4a2111">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{CONSENTED_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="430" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="9a905988-f100-45d0-9b3b-0fac589372a3">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <textFieldExpression><![CDATA[$F{CONSENT_TOTAL_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="516" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="ccf720d2-779b-4bc4-b1b4-3fa253629c5d"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 <paragraph lineSpacing="Single"/>
 </textElement>
 <textFieldExpression><![CDATA[$F{NOT_ELIGIBLE_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="602" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="14dcbcda-6498-412f-b21e-a3fcb5018502"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{ON_STUDY_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="688" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="613bbd4e-6774-4cce-ad88-7e7fa8b3077d"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{ON_TREATMENT_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="774" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="c9073fec-8b08-4620-bf9d-82060c93f0e4"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{OFF_TREATMENT_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="860" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="a7830fc3-d9b8-4790-85d8-7810a9591f0d"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{OFF_STUDY_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="946" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="b654a9a5-7e1e-4197-9107-577e91b277f4"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{EXPIRED_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1032" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="6f1b1463-21fb-4cb3-92a5-e29639debbc5"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{ON_FOLLOWUP_COUNT}]]></textFieldExpression>
 </textField>
 <textField isStretchWithOverflow="true" isBlankWhenNull="true">
 <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="1118" y="0" width="86" height="27" forecolor="#000000" backcolor="#FFFFFF" uuid="17078554-b751-42c3-9b9d-7cf920281e08"/>
 <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$F{ON_LTFU_COUNT}]]></textFieldExpression>
 </textField>
 </band>
 </detail>
 <pageFooter>
 <band height="25" splitType="Prevent">
 <property name="local_mesure_unitheight" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <staticText>
 <reportElement mode="Opaque" x="0" y="0" width="89" height="25" backcolor="#E6E6E6" uuid="00b71e79-08b5-44a3-af35-e114fc18433b">
 <property name="local_mesure_unity" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.y" value="px"/>
 <property name="local_mesure_unitheight" value="pixel"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle"/>
 <text><![CDATA[Report Date:]]></text>
 </staticText>
 <textField pattern="MM/dd/yyyy">
 <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="89" y="0" width="1411" height="25" backcolor="#E6E6E6" uuid="4306bff6-d9b7-498f-8124-8c583de632a9">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <textElement textAlignment="Left" verticalAlignment="Middle">
 <paragraph firstLineIndent="20"/>
 </textElement>
 <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
 </textField>
 <textField isBlankWhenNull="false">
 <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="1501" y="0" width="100" height="25" forecolor="#000000" backcolor="#E6E6E6" uuid="16866726-e0e9-4b0b-86b7-17528b27e5e7">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 </reportElement>
 <textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of "]]></textFieldExpression>
 </textField>
 <textField evaluationTime="Report" isBlankWhenNull="false">
 <reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="1601" y="0" width="90" height="25" forecolor="#000000" backcolor="#E6E6E6" uuid="43c13917-328f-49cc-84e0-fd0ca42186ba">
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 </reportElement>
 <box leftPadding="2"/>
 <textElement textAlignment="Left" verticalAlignment="Middle" rotation="None" markup="none">
 
 </textElement>
 <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
 </textField>
 </band>
 </pageFooter>
 <noData>
 <band height="20">
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <staticText>
 <reportElement x="0" y="0" width="1690" height="20" uuid="29dde353-6dcd-4817-a15e-599cff469095">
 <property name="com.jaspersoft.studio.unit.x" value="px"/>
 <property name="com.jaspersoft.studio.unit.y" value="px"/>
 <property name="com.jaspersoft.studio.unit.height" value="px"/>
 <property name="com.jaspersoft.studio.unit.width" value="px"/>
 </reportElement>
 <text><![CDATA[No invoiceable items found for the parameters entered and user's access.]]></text>
 </staticText>
 </band>
 </noData>
</jasperReport>

I am Leo · January 16, 2020

May be ChoosePatientType is not supported in your query.

Sign In

Issue with Parameter, can't figure out.

Recommended Posts

jburczyk

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

I am Leo

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore