dennis.board

I've been invovled in business intelligence for a number of years, but recently my company has purchased Jasperserver/jasper reports and we're to start using it. I've gotten through quite a bit and am enjoying new ways of doing things and many of the JS concepts, but I've run into a bit of a hitch. Our first production report is supposed to be ftp'd to the client using sftp. While scheduling and setting up the output options, I noticed that JS doesn't look like it supports sftp, only ftp and ftps. Am I incorrect here, is there something that needs to be turned on to support sftp? So, if it doesn't support sftp and the data is somewhat sensitive I am required to at least use ftps, now for my question.... Where, how and what do I do with the certificate the person managing the receiving ftp sent me? I done some searches through here and can't find an answer. If it helps we are running our setup on Windows server 2012 (VM). Our JS Help looks like this... Product Edition: Enterprise Features: Fusion AHD EXP DB AUD MT Product Version: 6.1 Thank you in advance for any help or direction.

Is this still an open issue? Was a resolution to send to sftp ever figured out?

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.

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]

I am trying to figure out how to supress/omit a row in a table based dataset and nothing seems to work so far. Example, I have a field market and it is empty with either "" or truly null. I would like to then suppress that entire row in the results. I am pulling the data from a domain and do have access to the domain, but not the underlying database, which is where the problem starts. Thanks for any help you might provide. This is something I have to do alot and have no issues doing it in Crystla or Webi. We are evaluating this software for our company and this could be a major impediment for us, if we can't do this.

I am very new to Jaspersoft studio and have worked through the process of creating a new report and connecting to our server to load a domain. My question should be a fairly simple one. Is there a way to add all the columns of my report to the detail section at once and have them be the appropriate width instead of having them all added and be only 3px wide? If not, how do I expand them out so they are all readable? I am doing a financial type status report which will have 37 fields based off of a fact table we have.