[#4016] - jasper report dropdown list not working in Jasper server 5.5

Category:
Bug report
Priority:
Urgent
Status:
New
Project: Severity:
Block
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:

We have developed a report in jasper server 5.1 version and the same has been deployed in Jasper Server 5.5. There are some single select list parameter i jasper server, which works fine in 5.1 but does not work in 5.5. Instead it shows a search box. PFA the screenshot FYR.
Would request you revert ASAP, as its ctitical for our current development.

AttachmentSize
File doc1.docx340.9 KB
v5.5.0
JasperReports Server
avik.paul's picture
Joined: Jul 23 2013 - 5:40am
Last seen: 7 years 6 months ago

2 Comments:

#1
  • Assigned:nobody»

also find the jrxml file for the same.

-----------------------------------------------------
<?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="LedgerOutstandingRPTDetails" language="groovy" pageWidth="1281" pageHeight="489" whenNoDataType="AllSectionsNoDetail" columnWidth="1277" leftMargin="2" rightMargin="2" topMargin="4" bottomMargin="4" uuid="7d665a9f-75ca-4d85-8ef2-fd2347644532">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<property name="ireport.jasperserver.reportUnit" value="/Reports_1/ReceivableDebtors/LedgerBookOutstanding"/>
<property name="ireport.jasperserver.url" value="http://124.153.92.146:80/jasperserver/services/repository"/>
<style name="table">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1">
<box>
<pen lineWidth="1.0" lineColor="#808080"/>
<topPen lineColor="#808080"/>
<leftPen lineColor="#808080"/>
<bottomPen lineColor="#808080"/>
<rightPen lineColor="#808080"/>
</box>
</style>
<style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_CH" mode="Opaque" backcolor="#B5CFD2">
<box>
<pen lineWidth="0.5" lineColor="#808080"/>
<topPen lineColor="#808080"/>
<leftPen lineColor="#808080"/>
<bottomPen lineColor="#808080"/>
<rightPen lineColor="#808080"/>
</box>
</style>
<style name="table 1_TD" mode="Opaque" backcolor="#FBF9F9">
<box>
<pen lineWidth="0.5" lineColor="#808080"/>
<topPen lineColor="#808080"/>
<leftPen lineColor="#808080"/>
<bottomPen lineColor="#808080"/>
<rightPen lineColor="#808080"/>
</box>
</style>
<subDataset name="OutstandingDS" uuid="ff0ebe43-4221-4b82-be14-b13d527a35d7">
<parameter name="HO_Only" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<parameter name="Ledger_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[30062]]></defaultValueExpression>
</parameter>
<parameter name="RO_Only" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<parameter name="AO_Only" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<parameter name="Region_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[-2]]></defaultValueExpression>
</parameter>
<parameter name="Area_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[-2]]></defaultValueExpression>
</parameter>
<parameter name="Branch_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[-2]]></defaultValueExpression>
</parameter>
<parameter name="End_Date" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="location" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Search_Type" class="java.lang.Integer">
<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
</parameter>
<parameter name="Bill_Type" class="java.lang.Integer">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Bill_status" class="java.lang.Integer">
<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
</parameter>
<parameter name="Reference_Type" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<queryString language="plsql">
<![CDATA[{call FALedgerOutstandingRPTDetailsForReceivable($P{HO_Only},$P{Ledger_Id},$P{RO_Only},$P{AO_Only},$P{Region_Id},$P{Area_Id},$P{Branch_Id},$P{End_Date},$P{Search_Type},$P{Bill_Type},$P{Bill_status},$P{Reference_Type})};]]>
</queryString>
<field name="Bill_Type" class="java.lang.Integer"/>
<field name="BillRef_Type" class="java.lang.Integer"/>
<field name="BillDate" class="java.lang.String"/>
<field name="Ref_No" class="java.lang.String"/>
<field name="TotalBillAmount" class="java.lang.String"/>
<field name="Pending_Amount" class="java.lang.String"/>
<field name="DueDate" class="java.lang.String"/>
<field name="Over_due_days" class="java.lang.Integer"/>
<field name="HO_Name" class="java.lang.String"/>
<field name="Region_Name" class="java.lang.String"/>
<field name="Area_Name" class="java.lang.String"/>
<field name="Branch_Name" class="java.lang.String"/>
<field name="Ledger_Name" class="java.lang.String"/>
<field name="SubmittedPending_Amount" class="java.lang.String"/>
<field name="UnSubmittedPending_Amount" class="java.lang.String"/>
<variable name="TotalBillAmount" class="java.lang.String" calculation="Sum">
<variableExpression><![CDATA[$F{TotalBillAmount}]]></variableExpression>
</variable>
<variable name="TotalPendingAmnt" class="java.lang.String" calculation="Sum">
<variableExpression><![CDATA[$F{Pending_Amount}]]></variableExpression>
</variable>
</subDataset>
<parameter name="HO_Only" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<parameter name="Ledger_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="RO_Only" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<parameter name="AO_Only" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<parameter name="Region_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[-2]]></defaultValueExpression>
</parameter>
<parameter name="Area_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[-2]]></defaultValueExpression>
</parameter>
<parameter name="Branch_Id" class="java.lang.Integer">
<defaultValueExpression><![CDATA[-2]]></defaultValueExpression>
</parameter>
<parameter name="End_Date" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="location" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Ledger_Name" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Search_Type" class="java.lang.Integer">
<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
</parameter>
<parameter name="Bill_Type" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<parameter name="Bill_status" class="java.lang.Integer">
<defaultValueExpression><![CDATA[1]]></defaultValueExpression>
</parameter>
<parameter name="Reference_Type" class="java.lang.Integer">
<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
</parameter>
<queryString language="plsql">
<![CDATA[{call FALedgerOutstandingRPTDetailsForReceivable($P{HO_Only},$P{Ledger_Id},$P{RO_Only},$P{AO_Only},$P{Region_Id},$P{Area_Id},$P{Branch_Id},$P{End_Date},$P{Search_Type},$P{Bill_Type},$P{Bill_status},$P{Reference_Type})};]]>
</queryString>
<field name="Bill_Type" class="java.lang.Integer"/>
<field name="BillRef_Type" class="java.lang.Integer"/>
<field name="BillDate" class="java.lang.String"/>
<field name="Ref_No" class="java.lang.String"/>
<field name="TotalBillAmount" class="java.lang.String"/>
<field name="Pending_Amount" class="java.lang.String"/>
<field name="DueDate" class="java.lang.String"/>
<field name="Over_due_days" class="java.lang.Integer"/>
<field name="HO_Name" class="java.lang.String"/>
<field name="Region_Name" class="java.lang.String"/>
<field name="Area_Name" class="java.lang.String"/>
<field name="Branch_Name" class="java.lang.String"/>
<field name="Ledger_Name" class="java.lang.String"/>
<field name="SubmittedPending_Amount" class="java.lang.String"/>
<field name="UnSubmittedPending_Amount" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="26" splitType="Stretch">
<staticText>
<reportElement uuid="5a3a0829-3a91-4d7b-bb3f-eee1702f2558" x="248" y="0" width="608" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Receivable Debtors Outstanding Report]]></text>
</staticText>
<staticText>
<reportElement uuid="3cc7dca3-c1ac-4faa-8c75-9093a1a741a2" x="856" y="-1" width="133" height="20" forecolor="#830000"/>
<textElement textAlignment="Right" verticalAlignment="Middle" markup="none">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[V-Trans (India) Limited]]></text>
</staticText>
<textField>
<reportElement uuid="e5f70f6e-93e8-4af0-84a5-0fae90a69033" x="137" y="-1" width="111" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$P{location}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="69c63619-45ae-461d-b2df-63f0534185da" x="0" y="-1" width="137" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA["Report View from Location: "]]></textFieldExpression>
</textField>
</band>
</title>
<columnHeader>
<band height="50">
<textField hyperlinkType="ReportExecution">
<reportElement uuid="afe91042-e109-4924-be94-ae9ddb43d166" style="table 1_CH" x="475" y="12" width="134" height="26"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA["With Aging Condensed"]]></textFieldExpression>
<hyperlinkParameter name="HO_Only">
<hyperlinkParameterExpression><![CDATA[$P{HO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ledger_Id">
<hyperlinkParameterExpression><![CDATA[$P{Ledger_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="RO_Only">
<hyperlinkParameterExpression><![CDATA[$P{RO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="AO_Only">
<hyperlinkParameterExpression><![CDATA[$P{AO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Region_Id">
<hyperlinkParameterExpression><![CDATA[$P{Region_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Area_Id">
<hyperlinkParameterExpression><![CDATA[$P{Area_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Branch_Id">
<hyperlinkParameterExpression><![CDATA[$P{Branch_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="End_Date">
<hyperlinkParameterExpression><![CDATA[$P{End_Date}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="_report">
<hyperlinkParameterExpression><![CDATA["/Reports_1/ReceivableDebtors/LedgerBookOutstanding_3"]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="location">
<hyperlinkParameterExpression><![CDATA[$P{location}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ledger_Name">
<hyperlinkParameterExpression><![CDATA[$P{Ledger_Name}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Search_Type">
<hyperlinkParameterExpression><![CDATA[$P{Search_Type}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Bill_Type">
<hyperlinkParameterExpression><![CDATA[$P{Bill_Type}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ageing_By">
<hyperlinkParameterExpression><![CDATA[1]]></hyperlinkParameterExpression>
</hyperlinkParameter>
</textField>
<textField hyperlinkType="ReportExecution">
<reportElement uuid="49d9c9bc-8609-436a-9d66-39fcfd6ec4fc" style="table 1_CH" x="650" y="12" width="111" height="26"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA["With Aging Detailed"]]></textFieldExpression>
<hyperlinkParameter name="HO_Only">
<hyperlinkParameterExpression><![CDATA[$P{HO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ledger_Id">
<hyperlinkParameterExpression><![CDATA[$P{Ledger_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="RO_Only">
<hyperlinkParameterExpression><![CDATA[$P{RO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="AO_Only">
<hyperlinkParameterExpression><![CDATA[$P{AO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Region_Id">
<hyperlinkParameterExpression><![CDATA[$P{Region_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Area_Id">
<hyperlinkParameterExpression><![CDATA[$P{Area_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Branch_Id">
<hyperlinkParameterExpression><![CDATA[$P{Branch_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="End_Date">
<hyperlinkParameterExpression><![CDATA[$P{End_Date}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="_report">
<hyperlinkParameterExpression><![CDATA["/Reports_1/ReceivableDebtors/LedgerBookOutstanding_1_3"]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="location">
<hyperlinkParameterExpression><![CDATA[$P{location}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ledger_Name">
<hyperlinkParameterExpression><![CDATA[$P{Ledger_Name}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Search_Type">
<hyperlinkParameterExpression><![CDATA[$P{Search_Type}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Bill_Type">
<hyperlinkParameterExpression><![CDATA[$P{Bill_Type}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ageing_By">
<hyperlinkParameterExpression><![CDATA[1]]></hyperlinkParameterExpression>
</hyperlinkParameter>
</textField>
<textField hyperlinkType="ReportExecution">
<reportElement uuid="e0aa4297-4cf7-4caa-b502-2fbf9ad73cf3" style="table 1_CH" x="795" y="12" width="73" height="26"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="false"/>
</textElement>
<textFieldExpression><![CDATA["Detailed"]]></textFieldExpression>
<hyperlinkParameter name="HO_Only">
<hyperlinkParameterExpression><![CDATA[$P{HO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ledger_Id">
<hyperlinkParameterExpression><![CDATA[$P{Ledger_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="RO_Only">
<hyperlinkParameterExpression><![CDATA[$P{RO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="AO_Only">
<hyperlinkParameterExpression><![CDATA[$P{AO_Only}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Region_Id">
<hyperlinkParameterExpression><![CDATA[$P{Region_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Area_Id">
<hyperlinkParameterExpression><![CDATA[$P{Area_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Branch_Id">
<hyperlinkParameterExpression><![CDATA[$P{Branch_Id}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="End_Date">
<hyperlinkParameterExpression><![CDATA[$P{End_Date}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="_report">
<hyperlinkParameterExpression><![CDATA["/Reports_1/ReceivableDebtors/LedgerBookOutstanding_1"]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="location">
<hyperlinkParameterExpression><![CDATA[$P{location}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Ledger_Name">
<hyperlinkParameterExpression><![CDATA[$P{Ledger_Name}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
<hyperlinkParameter name="Search_Type">
<hyperlinkParameterExpression><![CDATA[$P{Search_Type}]]></hyperlinkParameterExpression>
</hyperlinkParameter>
</textField>
<textField>
<reportElement uuid="1ff23ece-7b45-499f-96e0-8c9428c43e71" x="107" y="12" width="310" height="20"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$P{Ledger_Name}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="49bbd44a-c021-41e9-89eb-eb6c9fd6d9c4" x="7" y="12" width="100" height="20"/>
<textElement>
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["Ledger Name:"]]></textFieldExpression>
</textField>
</band>
</columnHeader>
<summary>
<band height="76" splitType="Stretch">
<componentElement>
<reportElement uuid="b833d34c-b796-4974-947e-ca4e7b034c07" key="table 1" style="table 1" x="0" y="0" width="1277" height="76"/>
<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail">
<datasetRun subDataset="OutstandingDS" uuid="cdb27feb-6a76-4074-bd7d-4e85e48b6d26">
<datasetParameter name="End_Date">
<datasetParameterExpression><![CDATA[$P{End_Date}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Branch_Id">
<datasetParameterExpression><![CDATA[$P{Branch_Id}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Area_Id">
<datasetParameterExpression><![CDATA[$P{Area_Id}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Region_Id">
<datasetParameterExpression><![CDATA[$P{Region_Id}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="AO_Only">
<datasetParameterExpression><![CDATA[$P{AO_Only}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="RO_Only">
<datasetParameterExpression><![CDATA[$P{RO_Only}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Ledger_Id">
<datasetParameterExpression><![CDATA[$P{Ledger_Id}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="HO_Only">
<datasetParameterExpression><![CDATA[$P{HO_Only}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="location">
<datasetParameterExpression><![CDATA[$P{location}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Search_Type">
<datasetParameterExpression><![CDATA[$P{Search_Type}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Bill_Type">
<datasetParameterExpression><![CDATA[$P{Bill_Type}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Bill_status">
<datasetParameterExpression><![CDATA[$P{Bill_status}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="Reference_Type">
<datasetParameterExpression><![CDATA[$P{Reference_Type}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:column width="67" uuid="87a44fac-0883-45c3-a22b-f52cda7039c5">
<printWhenExpression><![CDATA[$P{HO_Only}==1 || ($P{HO_Only}==0 && $P{RO_Only}==0 && $P{AO_Only}==0 && $P{Region_Id}==-2 && $P{Area_Id}==-2 && $P{Branch_Id}==-2)]]></printWhenExpression>
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="295d0c04-d476-476d-ab63-9e6cef380702" x="0" y="0" width="67" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[HO Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="6b5dacf2-6206-4d83-80df-3ae74cec48fe" x="0" y="0" width="67" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{HO_Name}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="90" uuid="afcea28a-49c6-41c0-9abb-22b6e9b0bb8d">
<printWhenExpression><![CDATA[$P{RO_Only}==1 || ($P{HO_Only}==0 && $P{RO_Only}==0 && $P{AO_Only}==0 && $P{Area_Id}==-2 && $P{Branch_Id}==-2)]]></printWhenExpression>
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="368734ac-da57-4669-8b95-c052c636660e" x="0" y="0" width="90" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Region Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="872ed51f-214a-4500-a1c3-05a96923b010" x="0" y="0" width="90" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{Region_Name}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="90" uuid="5cd03551-fb0e-4634-aee5-aac4cd17bd91">
<printWhenExpression><![CDATA[$P{AO_Only}==1 || ($P{HO_Only}==0 && $P{RO_Only}==0 && $P{AO_Only}==0 && $P{Branch_Id}==-2)]]></printWhenExpression>
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="5ff74510-03e5-4d04-96a3-215ac0366eb1" x="0" y="0" width="90" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Area Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="370d8421-2008-4222-a1ff-dfcd2642d115" x="0" y="0" width="90" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{Area_Name}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="90" uuid="0789baeb-abe5-4c3c-92a8-8e1b887da3fd">
<printWhenExpression><![CDATA[$P{HO_Only}==0 && $P{RO_Only}==0 && $P{AO_Only}==0]]></printWhenExpression>
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="ce0178f8-03b1-4e7e-beef-44c6950102a6" x="0" y="0" width="90" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Branch Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="b147b18f-05bf-486d-8285-4d508bb388df" x="0" y="0" width="90" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{Branch_Name}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="128" uuid="84041d17-f688-42ce-9c84-093c013d38c1">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="c3015029-15db-422d-834d-d048cb76233b" x="0" y="0" width="128" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Ledger Name]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="36b78bae-0a42-4990-98cf-01a133239fd8" x="0" y="0" width="128" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{Ledger_Name}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="116" uuid="e570b1e5-c7cc-4f48-83c0-4085c39ce5e0">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="d4fbb725-4d2e-49c0-ba04-90b57c780d7a" x="0" y="0" width="116" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Un Submitted]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="c1b90862-ad42-4bd5-b94e-68a5c76ee22e" x="0" y="0" width="116" height="15"/>
<box leftPadding="3"/>
<textElement textAlignment="Right">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{UnSubmittedPending_Amount}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="99" uuid="034ccdbf-7337-490a-9e07-819fbd6d209c">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="f97ab118-c5b7-45f2-8e8c-d31aa212b517" x="0" y="0" width="99" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Submitted]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="0e835c9e-b661-45ac-add5-1713e07b04ef" x="0" y="0" width="99" height="15"/>
<box leftPadding="3"/>
<textElement textAlignment="Right">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{SubmittedPending_Amount}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="79" uuid="e85c215c-0e25-45b0-9c6f-a963971fe0b3">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="a2ca2508-9b4b-4f79-a4d7-9619f105da15" x="0" y="0" width="79" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Bill Date]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="24f26560-9e72-4415-a576-f206d591e46f" x="0" y="0" width="79" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{BillDate}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="114" uuid="3773ec52-1fa8-4b9a-9f1b-a0c1d1facffb">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="1fab3011-e16c-4bde-91c1-19e459d85c0e" x="0" y="0" width="114" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Ref No.]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="6877ec5d-54f4-4492-8d75-9993d51cdcaf" x="0" y="0" width="114" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{Ref_No}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="114" uuid="92ccdea5-d4df-446e-b858-224f6f8823dd">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="0a0ae8b3-d226-4820-9ba3-d7c805447b96" x="0" y="0" width="114" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Reference Amount]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="b4e98a2a-f578-4990-935b-e9645ad6f977" x="0" y="0" width="114" height="15"/>
<textElement textAlignment="Right">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{TotalBillAmount}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="116" uuid="cd37f617-0864-4929-88bc-8261cb840d31">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="e2536d4b-abb4-4dd9-a652-df64080003e4" x="0" y="0" width="116" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Pending Amount]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="d75b5aa5-cc1c-479f-bb8a-7bce053a154d" x="0" y="0" width="116" height="15"/>
<textElement textAlignment="Right">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{Pending_Amount}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="68" uuid="0d2c3d50-9355-4a65-b1f3-9f5871dd762a">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="a5e94e22-cfef-49c4-9e20-ac41aa300e60" x="0" y="0" width="68" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Due Date]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="15375326-68d7-4d83-9fdf-52787cc5b318" x="0" y="0" width="68" height="15"/>
<box leftPadding="3"/>
<textElement>
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{DueDate}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
<jr:column width="100" uuid="9feb30fb-f6da-4d17-9a74-0546db2d0e9d">
<jr:columnHeader style="table 1_CH" height="20" rowSpan="1">
<staticText>
<reportElement uuid="4f1f8f72-2534-435c-94de-a8b93202b179" x="0" y="0" width="100" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="11" isBold="true"/>
</textElement>
<text><![CDATA[Over Due by Days]]></text>
</staticText>
</jr:columnHeader>
<jr:detailCell style="table 1_TD" height="15" rowSpan="1">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="a4e7fe46-8178-40db-b067-60ae20349b17" x="0" y="0" width="100" height="15"/>
<box leftPadding="3"/>
<textElement textAlignment="Right">
<font fontName="Arial" size="11"/>
</textElement>
<textFieldExpression><![CDATA[$F{Over_due_days}]]></textFieldExpression>
</textField>
</jr:detailCell>
</jr:column>
</jr:table>
</componentElement>
</band>
</summary>
</jasperReport>

#2
  • Assigned:» anonymous

could anyone please response on this... this is really critical.

Feedback
randomness