dennis.board Posted July 23, 2015 Share Posted July 23, 2015 I am working on the report below. It is a title and summary band only with a table in the summary band. The report works great in JS Studio Pro and returns the data I would expect using the defined parameters. When I save the report to the JS Server though and run it there, the report will print the title bar and an empty table only. I have tinkered with many of the When no data type settings to no avail here.I am guessing I am doing something wrong with the parameters, but am too new to tell what that might be.Could someone please take a look at my xml below and see if you can figure it out?Also any tips on things you see that I could possibly do better would be appreciated.Thank you in advance!!!<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.0.final using JasperReports Library version 6.1.0 --><!-- 2015-07-23T13:23:12 --><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="Location_Sum_Arbitration_Status_Report" pageWidth="3368" pageHeight="2380" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="3328" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Empty" uuid="65ed871d-57ae-415a-8400-d353820d59b3"> <property name="ireport.jasperserver.url" value="http://***-**********.***.***:8080/jasperserver-pro/"/> <property name="ireport.jasperserver.user" value="*******"/> <property name="ireport.domainUri" value="/Domains/Arb_Status_Rpt_JS"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Domain JRS"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="ireport.jasperserver.report.resource" value="/reports/Location_Sum_Arbitration_Status_Report_files/main_jrxml"/> <property name="ireport.jasperserver.reportUnit" value="/reports/Location_Sum_Arbitration_Status_Report"/> <style name="Table_TH" mode="Opaque" backcolor="#FCFCFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#D8D8ED"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> <conditionalStyle> <conditionExpression> <![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]> </conditionExpression> <style backcolor="#BFBFDF"/> </conditionalStyle> </style> <subDataset name="Dataset1" whenResourceMissingType="Empty" uuid="8f695cff-9744-4d18-b44b-269fae18a159"> <property name="ireport.jasperserver.url" value="http://poc-jasperapp01.man.lab:8080/jasperserver-pro/"/> <property name="ireport.jasperserver.user" value="jasperadmin"/> <property name="ireport.domainUri" value="/Domains/Arb_Status_Rpt_JS"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Domain JRS" /> <parameter name="TimeID_0" class="java.lang.String"> <parameterDescription> <![CDATA[Time Period Format MYYYYMM]]> </parameterDescription> <defaultValueExpression> <![CDATA[$P{TimeID_0}]]> </defaultValueExpression> </parameter> <parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User" isForPrompting="false"/> <parameter name="LoggedInUsername" class="java.lang.String" isForPrompting="false"/> <queryString language="domain"> <![CDATA[<query>]]> <queryFields> <queryField id="STAGING_LOCATION_DIMENSION_ARB.MARKET"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.VehiclesSoldWithECR"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.UnitSales"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerCar"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerArb"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TotalDaystoResolve"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TimeID"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.SettledCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.RankingTotal"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.RankingAverageRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.RankingAverage"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PSIsSold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PSI_PLPerPSISoldRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PSI_PLPerPSISold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossPSI"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossExpense"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerCarSold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerArbRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerArb"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPCSRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossCR"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PLGWPCStoGoal"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PLGWGoal"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PLGWBaseline"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PendingCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PctViaPSIFail"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PctLessThanEqual2DaysRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PctLessThanEqual2Days"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.OpenedCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.LossPerInherit"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.LocationName"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedWCOutlay"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedVehicles"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedRatioRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedRatioPctOfArbs"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedCalcLoss"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillExpense"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerCarSoldRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerArbRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerArb"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDolarsPerCarSold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.CR_PLPerCarInspectedRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.CR_PLPerCarInspected"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.CasesViaPSIFail"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.BBPctRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.BBPct"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.BBCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.AvgDaystoResolve"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.ArbsLessThanEqual2Days"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.ArbRateRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.ArbRate"/> </queryFields> <queryFilterString>STAGING_ARB_STATUS_REPORT_JS.TimeID == TimeID_0</queryFilterString></query>]]> </queryString> <field name="STAGING_LOCATION_DIMENSION_ARB.MARKET" class="java.lang.String"> <fieldDescription> <![CDATA[MARKET]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.LocationName" class="java.lang.String"> <fieldDescription> <![CDATA[LocationName]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.OpenedCases" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[OpenedCases]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.SettledCases" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[settledCases]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.UnitSales" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[unitSales]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.ArbRate" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[ArbRate]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.CasesViaPSIFail" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[CasesViaPSIFail]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.BBCases" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[bBCases]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.BBPct" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[bBPct]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.AvgDaystoResolve" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[AvgDaystoResolve]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PctLessThanEqual2Days" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PctLessThanEqual2Days]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerArb" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[TotalPLGWPerArb]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerCar" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[TotalPLGWPerCar]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.GoodwillExpense" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[GoodwillExpense]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerArb" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[GoodwillDollarsPerArb]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.GoodwillDolarsPerCarSold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[GoodwillDolarsPerCarSold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.VehiclesSoldWithECR" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[VehiclesSoldWithECR]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PolicyLossCR" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PolicyLossCR]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.CR_PLPerCarInspected" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[CR_PLPerCarInspected]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PSIsSold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PSIsSold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PolicyLossPSI" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PolicyLossPSI]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PSI_PLPerPSISold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PSI_PLPerPSISold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedVehicles" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedVehicles]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedCalcLoss" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedCalcLoss]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.LossPerInherit" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[LossPerInherit]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedWCOutlay" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedWCOutlay]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedRatioPctOfArbs" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedRatioPctOfArbs]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PLGWBaseline" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PLGWBaseline]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PLGWGoal" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PLGWGoal]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerCarSold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PolicyLossDollarsPerCarSold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.ArbsLessThanEqual2Days" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[ArbsLessThanEqual2Days]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.TotalDaystoResolve" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[TotalDaystoResolve]]> </fieldDescription> </field> <sortField name="STAGING_LOCATION_DIMENSION_ARB.MARKET"/> <sortField name="STAGING_ARB_STATUS_REPORT_JS.LocationName"/> <filterExpression> <![CDATA[$F{STAGING_LOCATION_DIMENSION_ARB.MARKET} != null]]> </filterExpression> <group name="STAGING_LOCATION_DIMENSION_ARB.MARKET"> <groupExpression> <![CDATA[$F{STAGING_LOCATION_DIMENSION_ARB.MARKET}]]> </groupExpression> </group> <group name="STAGING_ARB_STATUS_REPORT_JS.LocationName"> <groupExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.LocationName}]]> </groupExpression> </group> </subDataset> <parameter name="LoggedInUser" class="com.jaspersoft.jasperserver.api.metadata.user.domain.User" isForPrompting="false"/> <parameter name="LoggedInUsername" class="java.lang.String" isForPrompting="false"/> <parameter name="LocationName_0" class="java.util.Collection" nestedType="java.lang.String" isForPrompting="false"> <property name="inputControl" value="true"/> <parameterDescription> <![CDATA[LocationName]]> </parameterDescription> <defaultValueExpression> <![CDATA[java.util.Arrays.asList(new java.lang.String[] {"Canada","Canada Region","Digital","East Region","Florida", "Mid Atlantic","Midwest","North Central","Northeast","Pacific", "Peer 1a","Peer 1b","Peer 1c","Peer 2","Peer 3","Peer 4", "Peer Canada","Southeast","Southwest","Texas","Total Canada", "Total North America","Total US","West Region"})]]> </defaultValueExpression> </parameter> <parameter name="TimeID_0" class="java.lang.String"> <property name="inputControl" value="true"/> <parameterDescription> <![CDATA[TimeID]]> </parameterDescription> <defaultValueExpression> <![CDATA[new String("M201501")]]> </defaultValueExpression> </parameter> <queryString language="domain"> <![CDATA[<query> <queryFields> <queryField id="STAGING_LOCATION_DIMENSION_ARB.MARKET"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.VehiclesSoldWithECR"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.UnitSales"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerCar"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerArb"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TotalDaystoResolve"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.TimeID"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.SettledCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.RankingTotal"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.RankingAverageRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.RankingAverage"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PSIsSold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PSI_PLPerPSISoldRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PSI_PLPerPSISold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossPSI"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossExpense"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerCarSold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerArbRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerArb"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPCSRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PolicyLossCR"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PLGWPCStoGoal"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PLGWGoal"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PLGWBaseline"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PendingCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PctViaPSIFail"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PctLessThanEqual2DaysRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.PctLessThanEqual2Days"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.OpenedCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.LossPerInherit"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.LocationName"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedWCOutlay"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedVehicles"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedRatioRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedRatioPctOfArbs"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.InheritedCalcLoss"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillExpense"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerCarSoldRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerArbRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerArb"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.GoodwillDolarsPerCarSold"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.CR_PLPerCarInspectedRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.CR_PLPerCarInspected"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.CasesViaPSIFail"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.BBPctRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.BBPct"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.BBCases"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.AvgDaystoResolve"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.ArbsLessThanEqual2Days"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.ArbRateRank"/> <queryField id="STAGING_ARB_STATUS_REPORT_JS.ArbRate"/> </queryFields> <queryFilterString>STAGING_ARB_STATUS_REPORT_JS.TimeID == TimeID_0</queryFilterString></query>]]> </queryString> <field name="STAGING_ARB_STATUS_REPORT_JS.TimeID" class="java.lang.String"> <fieldDescription> <![CDATA[TimeID]]> </fieldDescription> </field> <field name="STAGING_LOCATION_DIMENSION_ARB.MARKET" class="java.lang.String"> <fieldDescription> <![CDATA[MARKET]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.LocationName" class="java.lang.String"> <fieldDescription> <![CDATA[LocationName]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.OpenedCases" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[OpenedCases]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.SettledCases" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[settledCases]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.UnitSales" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[unitSales]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.ArbRate" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[ArbRate]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.CasesViaPSIFail" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[CasesViaPSIFail]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.BBCases" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[bBCases]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.BBPct" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[bBPct]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.AvgDaystoResolve" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[AvgDaystoResolve]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PctLessThanEqual2Days" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PctLessThanEqual2Days]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerArb" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[TotalPLGWPerArb]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerCar" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[TotalPLGWPerCar]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.GoodwillExpense" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[GoodwillExpense]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerArb" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[GoodwillDollarsPerArb]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.GoodwillDolarsPerCarSold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[GoodwillDolarsPerCarSold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.VehiclesSoldWithECR" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[VehiclesSoldWithECR]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PSIsSold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PSIsSold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PolicyLossPSI" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PolicyLossPSI]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PSI_PLPerPSISold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PSI_PLPerPSISold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedVehicles" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedVehicles]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedCalcLoss" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedCalcLoss]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.LossPerInherit" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[LossPerInherit]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedWCOutlay" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedWCOutlay]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.InheritedRatioPctOfArbs" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[inheritedRatioPctOfArbs]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PLGWBaseline" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PLGWBaseline]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PLGWGoal" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PLGWGoal]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerCarSold" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[PolicyLossDollarsPerCarSold]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.ArbsLessThanEqual2Days" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[ArbsLessThanEqual2Days]]> </fieldDescription> </field> <field name="STAGING_ARB_STATUS_REPORT_JS.TotalDaystoResolve" class="java.math.BigDecimal"> <fieldDescription> <![CDATA[TotalDaystoResolve]]> </fieldDescription> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="60" splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <textField pattern="MMMMM dd, yyyy"> <reportElement x="2530" y="1" width="100" height="30" uuid="fa68e6b8-cbd5-439e-abd0-f4c3006f501c"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textFieldExpression> <![CDATA[new java.util.Date()]]> </textFieldExpression> </textField> <staticText> <reportElement x="1" y="1" width="118" height="30" uuid="1f5df1ff-1c59-432f-9ba5-2d21cb8f5a88"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textElement> <font size="14"/> </textElement> <text> <![CDATA[Time Period]]> </text> </staticText> <staticText> <reportElement x="132" y="1" width="456" height="39" uuid="00981802-b878-4bea-a0df-a411df05992d"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textElement> <font size="26"/> </textElement> <text><![CDATA[Manheim Arbitration Summary Report]]></text> </staticText> <staticText> <reportElement x="2380" y="1" width="140" height="30" uuid="5a753e0f-809b-4c71-9ca7-fbf96e494f52"> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <textElement> <font size="12"/> </textElement> <text> <![CDATA[Last Print Date: ]]> </text> </staticText> <textField> <reportElement x="1" y="42" width="70" height="16" uuid="1e57b4d7-2ce8-4c5f-afb0-7e3cc02cab0c"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textFieldExpression> <![CDATA[$P{TimeID_0}]]> </textFieldExpression> </textField> </band> </title> <summary> <band height="201" splitType="Stretch"> <componentElement> <reportElement key="" mode="Transparent" x="0" y="0" width="2622" height="200" isRemoveLineWhenBlank="true" isPrintInFirstWholeBand="true" backcolor="#FFFF00" uuid="6ac58585-ec31-4585-8141-6ab84d9e783a"> <property name="net.sf.jasperreports.export.headertoolbar.table.name" value="Location Sum"/> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.HorizontalRowLayout"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <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="Dataset1" uuid="37b10700-1a5e-434e-8416-25c517c7f7b0"> <datasetParameter name="slSchema"> <datasetParameterExpression> <![CDATA[$P{slSchema}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="slFactory"> <datasetParameterExpression> <![CDATA[$P{slFactory}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="LoggedInUser"> <datasetParameterExpression> <![CDATA[$P{LoggedInUser}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="LoggedInUsername"> <datasetParameterExpression> <![CDATA[$P{LoggedInUsername}]]> </datasetParameterExpression> </datasetParameter> <datasetParameter name="TimeID_0"> <datasetParameterExpression> <![CDATA[$P{TimeID_0}]]> </datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="82" uuid="1ab77984-98f4-4068-8e4f-c2bb6ab80cbd"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:tableHeader style="Table_TH" height="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> </jr:tableHeader> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="21f78d0b-d6dd-43b2-af15-0ba1bf675cbe"/> <text> <![CDATA[Market]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="f710a9aa-42bd-4670-997f-64aec1d0fcee"> <printWhenExpression> <![CDATA[$F{STAGING_LOCATION_DIMENSION_ARB.MARKET} == null ? new Boolean(false) : new Boolean(true)]]> </printWhenExpression> </reportElement> <textFieldExpression> <![CDATA[$F{STAGING_LOCATION_DIMENSION_ARB.MARKET}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="80" uuid="67a18638-ab98-4a75-812d-2f74bd3fe3cb"> <jr:tableHeader style="Table_TH" height="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableHeader> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="80" height="30" uuid="55d306e7-3744-4439-98a5-024495aeb1fc"/> <text> <![CDATA[Location]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="d9fd8784-f203-4c16-8424-1e2c724a0076"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.LocationName}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="d9409aec-d999-4623-809e-767740e0a37b"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="80ac154c-b9e4-43d3-a9cd-6162f56798a2"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <text> <![CDATA[Opened Cases]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="56698209-7bea-415a-bb22-5675d4f93173"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.OpenedCases}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="18e7ccbb-ef52-43c5-9989-6a4f0fe9ecc4"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="7a698ca1-2f5f-49f2-9ecc-c9b7e5d49af3"/> <text> <![CDATA[settled Cases]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="ccb85af9-aac7-4ee3-8527-5a9fe6f510e0"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.SettledCases}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="e6cf1d89-101f-4d60-8894-d51fc196535e"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="8018ffc1-474b-40a2-bd2f-f2e07f40b457"/> <text> <![CDATA[unit Sales]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="e43e7ce0-1ad5-410a-91b6-b2863acace22"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.UnitSales}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="b28f7402-2008-4efe-8cbe-e6de73cb7f0f"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="5f5e3c56-3fd3-4091-9974-d56c607001da"/> <text> <![CDATA[Arbitration Rate]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="dedf821f-6906-4e18-b702-1ca8374b3faa"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.ArbRate}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="45ec56e7-153b-4bb2-99f0-74b2309c8fe8"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="898ba5ea-633f-4cab-b112-149d8ee2c23d"/> <text> <![CDATA[Cases Via PSI Fail]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="5d2c1589-404a-4a34-ac95-ae83b6863e01"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.CasesViaPSIFail}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="988a2d7e-5f77-4877-8e67-fd5789180576"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="c8ce9200-b3ae-4a2f-a5ce-788631afb3df"/> <text> <![CDATA[bB Cases]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="2e4f8847-99c8-4e3f-abaa-94fbe67cd1c6"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.BBCases}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="3722017a-7ca9-4dde-8fec-6f0168688c5e"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="1555b376-951f-4d3d-aa6c-f1a81d0f6765"/> <text> <![CDATA[bB%]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="75be7c46-2fed-4729-8432-190714bcdb45"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.BBPct}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="ea87c128-37e4-471c-8bc5-a461f21ec5c3"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="d9edb193-bfd1-4db3-be16-993e487bbf30"/> <text> <![CDATA[Avg Days to Resolve]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="c796c969-a816-425e-8d69-cec574e9cfb5"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.AvgDaystoResolve}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="5a4cf4e2-720e-45e8-9cd5-6056668c0d26"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="82" height="30" backcolor="#FFFF00" uuid="ca70b913-9943-4a4f-9c27-92f7f3b9458b"/> <text> <![CDATA[% <= 2 Days]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement mode="Opaque" x="0" y="0" width="80" height="30" backcolor="#FFFF00" uuid="4ca22e9c-423b-4f5c-8148-0009a13fb41a"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PctLessThanEqual2Days}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="c3cbb644-fb89-4621-b19a-995b85aec2f0"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="7d201335-798c-4b39-a18e-08b8906a2986"/> <text> <![CDATA[Total PLGW Per Arbitration]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="d5c6f08c-2cc9-473e-87c3-9033c8d87534"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerArb}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="42061c5c-5d91-49be-9e14-deb8af541b02"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="f5a22c91-e274-4448-9a1c-2ebb42a74332"/> <text> <![CDATA[Total PLGW Per Car]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="8f502f1a-4762-45fd-a889-90e7c523f3a4"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.TotalPLGWPerCar}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="98c66858-cbab-4690-874a-fb9903110f9a"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="d1e8c54c-634c-467b-9f13-fccd38ffee35"/> <text> <![CDATA[Goodwill Expense]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="c016380a-fc08-4289-a143-343ad48f700b"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.GoodwillExpense}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="16c496d6-75ac-482c-8024-f00e94f9c1b9"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="34438a71-4cc3-4c3a-8d4f-e9a999ef204d"/> <text> <![CDATA[Goodwill $ Per Arbitration]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="de4af9c5-b3b8-4f95-8434-60c6efabe6b3"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.GoodwillDollarsPerArb}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="d3cdad2e-d971-4e7a-ba76-7113c8c4d9bb"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="2f3792ee-b60c-4c90-8cc1-f760fb287da9"/> <text> <![CDATA[Goodwill $ Per Car Sold]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="551fd09c-9a50-4d3f-a2d3-661010df2aa7"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.GoodwillDolarsPerCarSold}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="80c26e0b-003d-4afe-a69f-07666717d744"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="8553e9c1-1314-41d9-8a49-d33d75ef0a66"/> <text> <![CDATA[Vehicles Sold With ECR]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="df76a449-6f1c-4753-9c1b-78af471bc837"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.VehiclesSoldWithECR}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="268ed2a5-5db6-44ed-ab99-b1898f1f7d89"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="3a119be1-a4a8-4e6d-8596-507e0e68ba3c"/> <text> <![CDATA[Policy Loss CR]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="056145fc-b432-4ce2-bd0a-301b27c92d2f"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PolicyLossCR}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="ef45ee7b-c559-43d6-a17f-5d46cb378980"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="250309c5-1c20-4a7c-8640-f2cb6eadd088"/> <text> <![CDATA[CR/PL Per Car Inspected]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="0d5a182f-de68-409f-8546-e231b6f02efb"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.CR_PLPerCarInspected}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="54966a6c-9cdb-4a1e-a2e3-c359594d6023"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="d7f82fe4-f1e4-4aa6-8bba-cae62c19ed12"/> <text> <![CDATA[PSI Sold]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="0162b57d-785b-486b-b0b2-62387552238c"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PSIsSold}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="5f09f1c8-6185-482e-b248-11df4de06591"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="10e1dd62-1147-4c34-9f63-a9c018ba89de"/> <text> <![CDATA[Policy Loss PSI]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="ec92d259-0073-4aaf-8ef7-2410a7ad1c6a"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PolicyLossPSI}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="ec715b8f-aa27-4006-8eef-d966d8f80602"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="2933f52f-9e86-466d-b6c4-aed9963febd7"/> <text> <![CDATA[PSI PL Per PSI Sold]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="67360154-680d-45fe-bc2c-0623c235e758"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PSI_PLPerPSISold}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="ff4906b9-b6d1-4779-9f7c-12b2c7590934"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="bd5c81fc-e8bd-4de8-8c23-5be3416d6588"/> <text> <![CDATA[inherited Vehicles]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="cf052b0e-22d2-4921-a4ba-f8672260fb5f"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.InheritedVehicles}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="c25fa7ea-2bf1-4cbf-97b5-7f850f72a144"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="c6f2f774-fe76-46d5-8d18-1e27e0727f93"/> <text> <![CDATA[inherited Calc Loss]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="044f817d-2421-474b-b984-03fefbc52274"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.InheritedCalcLoss}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="9844fa41-ef9b-4d80-8b41-c7c33e3ac6d6"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="b20d7de9-342f-40b3-b6d7-b50dc86c8dc5"/> <text> <![CDATA[Loss Per Inherit]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="4917b100-6753-4103-afe0-8120b7313c54"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.LossPerInherit}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="77649de3-6c93-4fee-8695-fcf706a98053"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="216fbec3-275d-4dba-86b7-d60c0383a9b5"/> <text> <![CDATA[inherited WC Outlay]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="c1c5c413-be2a-4a8f-8840-c18b2454a9be"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.InheritedWCOutlay}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="d687d98b-1110-4be2-81fe-cdf5f3438682"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="4ddd3f80-1b1c-4835-a03f-ca54d8984b5a"/> <text> <![CDATA[inherited Ratio (% Of Arbs)]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="2f51e902-6a93-4ed8-bec4-5b3afadacd73"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.InheritedRatioPctOfArbs}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="a7348645-d9dc-4789-9bec-f836037af7c0"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="af0b9238-54b1-49f4-8ac7-4d6acef34ec7"/> <text> <![CDATA[PLGW Baseline]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="f6fe8dd7-d4af-43bf-a354-8c51fe0c02e6"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PLGWBaseline}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="4fab7d5c-bfaf-4773-aeed-30eeff077b0e"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="b5df0487-5de6-404e-8132-1174ac43bf2e"/> <text> <![CDATA[PLGW Goal]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="85327d15-aa4a-43e3-a94e-10b09122fccf"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PLGWGoal}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="51ee73ab-dac9-4dc4-acd7-e7c8a6f46bdd"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement mode="Transparent" x="0" y="0" width="82" height="30" uuid="58963507-e6ad-4c0f-85fa-2d3fdf2f26ea"/> <text><![CDATA[Policy Loss $ Per Car Sold]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="6677288d-9374-47f9-bfa7-71e582212c3c"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.PolicyLossDollarsPerCarSold}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="96ddb901-ffbc-4f60-81df-8408894d4845"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="82" height="30" backcolor="#FFFF00" uuid="9dd652c2-29e0-4b8b-91d0-d51203a9168c"/> <text> <![CDATA[Arbitrations <= 2 Days]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement mode="Opaque" x="0" y="0" width="80" height="30" backcolor="#FFFF00" uuid="9bf000ba-090b-4d61-8682-ac1588178967"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.ArbsLessThanEqual2Days}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="82" uuid="c15766cd-947a-4f0e-bd63-5f68132f2a81"> <jr:tableHeader style="Table_TH" height="1"/> <jr:tableFooter style="Table_TH" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> </jr:tableFooter> <jr:columnHeader style="Table_CH" height="30"> <staticText> <reportElement x="0" y="0" width="82" height="30" uuid="c8ad09a5-a4bc-4a0d-a870-b16af98e7f40"/> <text> <![CDATA[Total Days to Resolve]]> </text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table_CH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="80" height="30" uuid="c3079e10-bf39-4897-bbd4-18627367856f"/> <textFieldExpression> <![CDATA[$F{STAGING_ARB_STATUS_REPORT_JS.TotalDaystoResolve}]]> </textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </summary></jasperReport>[/code] Link to comment Share on other sites More sharing options...
hozawa Posted July 23, 2015 Share Posted July 23, 2015 If it works on Jaspersoft Studio and not in JasperReports Server, the most common reason if your datasource. Check if data is fetched properly on your JasperReports Server datasource. Try creating a simple report. Link to comment Share on other sites More sharing options...
dennis.board Posted July 23, 2015 Author Share Posted July 23, 2015 Built a report off the domain and everything worked great, including filter out several locations as well as filtering on the time period. Sooo, still at a loss. I am thinking I have done something wrong with passing the parameter, but don't know where to begin. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now