Sad H

jasper server 9 is using different URL String it is adding Organization name in it now.

Try This

Try adding PostgreSql drivers in Data source.

Try to use them in sub report one Data set in main report and other in sub report, now pass main reports field like: Open Accounts from main to sub report then you can access both DB fields in one environment.

This Might help https://community.jaspersoft.com/forums/topic/67916-javalangnoclassdeffounderror-jrxxxxxxxx-_1811b31b27d13da1f8bc9955038dc0646b5de2a76581526d5a0228d015ebfd49-wrong-name-jrxxxxxxxx/

Check field's properties and mark StrechwithOverFlow = true

Try this it is working.

great.

Actuly i dont have your DB thats why i did that, you just change the field type to number.

$P!{REPORT_START_DATE} now it is handled at report side, do this for all the optional parameters.

<?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 7.3.1.final using JasperReports Library version 6.8.1-3d4b87119c827be13776e451fb3738062f84a87d --> <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="TextAlignment_v2" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="7d90a2c8-d4df-4962-b6e8-28b008fdcddf"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="393"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="601"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="ESIGBAR2"/> <style name="Custos00"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{00H_Custo} > ($F{TRF_INV_TRI_VAZIO} * $F{POTENCIA}))]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{00H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{00H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{00H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{00H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{00H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{00H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos01"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{01H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{01H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{01H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{01H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{01H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{01H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{01H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos02"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{02H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{02H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{02H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{02H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{02H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{02H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{02H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos03"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{03H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{03H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{03H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{03H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{03H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{03H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{03H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos04"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{04H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{04H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{04H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{04H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{04H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{04H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{04H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos05"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{05H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{05H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{05H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{05H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{05H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{05H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{05H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos06"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{06H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{06H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{06H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{06H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{06H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{06H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{06H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos07"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{07H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{07H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{07H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{07H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{07H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{07H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{07H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos08"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{08H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{08H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{08H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{08H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{08H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{08H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{08H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos09"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{09H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{09H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{09H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{09H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{09H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{09H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{09H_Custo} < ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos10"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{10H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{10H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{10H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{10H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{10H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{10H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{10H_Custo} < ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos11"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{11H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{11H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{11H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{11H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{11H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{11H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{11H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos12"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{12H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{12H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{12H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{12H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{12H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{12H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{12H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos13"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{13H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{13H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{13H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{13H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{13H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{13H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{13H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos14"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{14H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{14H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{14H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{14H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{14H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{14H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{14H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos15"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{15H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{15H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{15H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{15H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{15H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{15H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{15H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos16"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{16H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{16H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{16H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{16H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{16H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{16H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{16H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos17"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{17H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{17H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{17H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{17H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{17H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{17H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{17H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos18"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{18H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{18H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{18H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{18H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{18H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{18H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{18H_Custo} < ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos19"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{19H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{19H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{19H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{19H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{19H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{19H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{19H_Custo} < ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos20"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{20H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{20H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{20H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{20H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{20H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{20H_Custo} > ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{20H_Custo} < ($F{TRF_INV_TRI_PONTA}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos21"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{21H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{21H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{21H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{21H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{21H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{21H_Custo} > ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{21H_Custo} < ($F{TRF_INV_TRI_CHEIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos22"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{22H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{22H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{22H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{22H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{22H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{22H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{22H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <style name="Custos23"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{23H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*1)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000" isBold="true"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{23H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.95)]]></conditionExpression> <style mode="Opaque" backcolor="#C00000"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{23H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.75)]]></conditionExpression> <style mode="Opaque" backcolor="#F4B084"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{23H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.5)]]></conditionExpression> <style mode="Opaque" backcolor="#FFE699"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{23H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.25)]]></conditionExpression> <style mode="Opaque" backcolor="#E2EFDA"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{23H_Custo} > ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#C6E0B4"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{23H_Custo} < ($F{TRF_INV_TRI_VAZIO}*$F{POTENCIA})*0.15)]]></conditionExpression> <style mode="Opaque" backcolor="#548235"/> </conditionalStyle> </style> <parameter name="PCODLOCAL" class="java.lang.String" isForPrompting="false"> <parameterDescription><![CDATA[codigolocal]]></parameterDescription> </parameter> <parameter name="PDATAINI" class="java.sql.Date"> <parameterDescription><![CDATA[Data Inicio]]></parameterDescription> </parameter> <parameter name="PDATAFIM" class="java.sql.Date"> <parameterDescription><![CDATA[Data Final]]></parameterDescription> </parameter> <queryString language="SQL"> <![CDATA[sELECT `ESIGBAR2`.`SMP_CUSTOS`.`LOCAL_FK`, `ESIGBAR2`.`SMP_CUSTOS`.`COD_LOCAL`, `ESIGBAR2`.`SMP_CUSTOS`.`LOCAL`, `ESIGBAR2`.`SMP_CUSTOS`.`PERIODICIDADE`, `ESIGBAR2`.`SMP_CUSTOS`.`CICLO`, `ESIGBAR2`.`SMP_CUSTOS`.`TIPOCLIENTE`, `ESIGBAR2`.`SMP_CUSTOS`.`MODOPAGAMENTO`, `ESIGBAR2`.`SMP_CUSTOS`.`REGIME`, `ESIGBAR2`.`SMP_CUSTOS`.`POTENCIA`, `ESIGBAR2`.`SMP_CUSTOS`.`23H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`23H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`22H_Custo`, `ESIGBAR2`.`SMP_TARIFA_LOCAL`.`TRF_SIMPLES`, `ESIGBAR2`.`SMP_TARIFA_LOCAL`.`TRF_INV_TRI_PONTA`, `ESIGBAR2`.`SMP_TARIFA_LOCAL`.`TRF_INV_TRI_CHEIO`, `ESIGBAR2`.`SMP_TARIFA_LOCAL`.`TRF_INV_TRI_VAZIO`, `ESIGBAR2`.`SMP_CUSTOS`.`22H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`21H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`00H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`00H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`01H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`01H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`02H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`02H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`03H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`07H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`07H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`11H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`10H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`08H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`06H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`08H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`21H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`LOCATARIO_FK`, `ESIGBAR2`.`SMP_CUSTOS`.`20H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`20H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`19H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`19H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`18H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`18H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`17H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`10H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`09H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`09H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`17H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`16H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`16H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`15H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`15H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`14H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`14H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`13H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`13H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`12H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`06H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`11H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`12H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`05H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`05H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`03H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`04H_kW`, `ESIGBAR2`.`SMP_CUSTOS`.`04H_Custo`, `ESIGBAR2`.`SMP_CUSTOS`.`DATA`, `ESIGBAR2`.`SMP_CUSTOS`.`ACTIVO` FROM `ESIGBAR2`.`SMP_CUSTOS` INNER JOIN `ESIGBAR2`.`SMP_TARIFA_LOCAL` ON `ESIGBAR2`.`SMP_TARIFA_LOCAL`.`LOCAL_FK` = `ESIGBAR2`.`SMP_CUSTOS`.`LOCAL_FK` WHERE `ESIGBAR2`.`SMP_CUSTOS`.`DATA` >=$P{PDATAINI} AND `ESIGBAR2`.`SMP_CUSTOS`.`DATA` <=$P{PDATAFIM}]]> </queryString> <field name="LOCAL_FK" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="LOCAL_FK"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="COD_LOCAL" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="COD_LOCAL"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="LOCAL" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="LOCAL"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="PERIODICIDADE" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="PERIODICIDADE"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="CICLO" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="CICLO"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="TIPOCLIENTE" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="TIPOCLIENTE"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="MODOPAGAMENTO" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="MODOPAGAMENTO"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="REGIME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="REGIME"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="POTENCIA" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="POTENCIA"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="23H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="23H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="23H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="23H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="22H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="22H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="TRF_SIMPLES" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="TRF_SIMPLES"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_TARIFA_LOCAL"/> </field> <field name="TRF_INV_TRI_PONTA" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="TRF_INV_TRI_PONTA"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_TARIFA_LOCAL"/> </field> <field name="TRF_INV_TRI_CHEIO" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="TRF_INV_TRI_CHEIO"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_TARIFA_LOCAL"/> </field> <field name="TRF_INV_TRI_VAZIO" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="TRF_INV_TRI_VAZIO"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_TARIFA_LOCAL"/> </field> <field name="22H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="22H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="21H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="21H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="00H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="00H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="00H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="00H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="01H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="01H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="01H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="01H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="02H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="02H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="02H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="02H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="03H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="03H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="07H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="07H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="07H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="07H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="11H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="11H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="10H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="10H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="08H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="08H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="06H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="06H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="08H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="08H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="21H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="21H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="LOCATARIO_FK" class="java.math.BigDecimal"> <property name="com.jaspersoft.studio.field.label" value="LOCATARIO_FK"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="20H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="20H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="20H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="20H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="19H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="19H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="19H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="19H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="18H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="18H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="18H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="18H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="17H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="17H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="10H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="10H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="09H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="09H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="09H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="09H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="17H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="17H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="16H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="16H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="16H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="16H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="15H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="15H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="15H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="15H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="14H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="14H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="14H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="14H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="13H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="13H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="13H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="13H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="12H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="12H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="06H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="06H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="11H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="11H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="12H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="12H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="05H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="05H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="05H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="05H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="03H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="03H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="04H_kW" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="04H_kW"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="04H_Custo" class="java.lang.Double"> <property name="com.jaspersoft.studio.field.label" value="04H_Custo"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="DATA" class="java.sql.Date"> <property name="com.jaspersoft.studio.field.label" value="DATA"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <field name="ACTIVO" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="ACTIVO"/> <property name="com.jaspersoft.studio.field.tree.path" value="SMP_CUSTOS"/> </field> <variable name="Sum00" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum01" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum02" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum03" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum04" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum05" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> </variable> <variable name="Sum06" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum07" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum08" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum09" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum10" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum11" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum12" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum13" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum14" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum15" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum16" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum17" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum18" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum19" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum20" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum21" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum22" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="Sum23" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="SumTotal" class="java.lang.Integer"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="TotalDiario" class="java.lang.Integer"> <variableExpression><![CDATA[""]]></variableExpression> <initialValueExpression><![CDATA[0]]></initialValueExpression> </variable> <variable name="PercDia" class="java.lang.Integer"> <variableExpression><![CDATA[""]]></variableExpression> </variable> <variable name="SUm_TotDiario" class="java.lang.Integer" calculation="Sum"> <variableExpression><![CDATA[""]]></variableExpression> </variable> <group name="DATA"> <groupExpression><![CDATA[$F{DATA}]]></groupExpression> <groupHeader> <band> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> </band> </groupHeader> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="14" splitType="Stretch"/> </title> <pageHeader> <band height="33" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="130" height="14" uuid="c3565bdf-cf60-4f72-a97f-9e409d6f71cf"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> <font isBold="true"/> </textElement> <text><![CDATA[Local:]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="false"> <reportElement stretchType="RelativeToTallestObject" x="0" y="14" width="130" height="14" uuid="0f243dbd-132d-4cd3-91d3-d13247485b44"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA["Casa The Winner in Town Of Braclona"]]></textFieldExpression> </textField> <staticText> <reportElement x="130" y="0" width="80" height="14" uuid="7294df0a-a080-45ca-aa1c-1a012064606f"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> <font isBold="true"/> </textElement> <text><![CDATA[Potência (kWh):]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="false"> <reportElement stretchType="RelativeToTallestObject" x="130" y="14" width="80" height="14" uuid="e184823c-2465-4441-9fae-2d16372b1f76"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{POTENCIA}]]></textFieldExpression> </textField> <staticText> <reportElement x="230" y="0" width="90" height="14" uuid="24c47ba6-493c-4b1c-8ef6-6884c7f2f214"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> <font isBold="true"/> </textElement> <text><![CDATA[Regime:]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="false"> <reportElement stretchType="RelativeToTallestObject" x="230" y="14" width="90" height="14" uuid="ffc6b390-1a08-4cf4-a596-46074d2bbb10"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{REGIME}]]></textFieldExpression> </textField> <staticText> <reportElement x="340" y="0" width="100" height="14" uuid="64d5933c-8345-4e03-b684-45b0904dbff8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> <font isBold="true"/> </textElement> <text><![CDATA[Ciclo:]]></text> </staticText> <staticText> <reportElement x="470" y="0" width="100" height="14" uuid="44090133-1fee-477a-96d0-e162633cf000"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> <font isBold="true"/> </textElement> <text><![CDATA[Tipo de Cliente:]]></text> </staticText> <textField isStretchWithOverflow="true" isBlankWhenNull="false"> <reportElement stretchType="RelativeToTallestObject" x="340" y="14" width="100" height="14" uuid="25648c05-7537-45e5-a66a-e51096cdc0fa"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{CICLO}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="false"> <reportElement stretchType="RelativeToTallestObject" x="470" y="14" width="100" height="14" uuid="db06ec37-14d2-44e6-be7b-45aacf865e3e"/> <textElement textAlignment="Left" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{TIPOCLIENTE}]]></textFieldExpression> </textField> <staticText> <reportElement x="680" y="0" width="100" height="14" uuid="3c6aa88a-031e-4833-9ce8-f53ffcb5b29d"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> <font isBold="true"/> </textElement> <text><![CDATA[Mês:]]></text> </staticText> <textField isStretchWithOverflow="true" pattern="MMMM, yyyy" isBlankWhenNull="false"> <reportElement stretchType="RelativeToTallestObject" x="680" y="14" width="100" height="14" uuid="cfaa41b5-8838-4bdd-a183-a2f354bc4120"/> <textFieldExpression><![CDATA[$F{DATA}]]></textFieldExpression> </textField> </band> </pageHeader> <columnHeader> <band height="20" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="20" height="20" uuid="0256a4ce-1c80-4e74-82d8-3480e4cd1d81"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textElement verticalAlignment="Middle"/> <text><![CDATA[Dia]]></text> </staticText> <staticText> <reportElement x="20" y="0" width="30" height="20" uuid="02aac677-648c-4de1-b03c-21b31741d966"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[00]]></text> </staticText> <staticText> <reportElement x="50" y="0" width="30" height="20" uuid="4c3d8f99-0516-44e6-92f2-63e8e8a57943"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[01]]></text> </staticText> <staticText> <reportElement x="80" y="0" width="30" height="20" uuid="c335e37b-dff4-477d-b753-f1590d5b5d76"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[02]]></text> </staticText> <staticText> <reportElement x="110" y="0" width="30" height="20" uuid="a4f016db-70af-4779-ab7c-ced3e83f531f"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[03]]></text> </staticText> <staticText> <reportElement x="140" y="0" width="30" height="20" uuid="cd4de94c-7c53-4c36-833f-65c6aeef618b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[04]]></text> </staticText> <staticText> <reportElement x="170" y="0" width="30" height="20" uuid="6ed404a2-2ee0-46f6-b451-35a94a153594"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[05]]></text> </staticText> <staticText> <reportElement x="200" y="0" width="30" height="20" uuid="589f60c9-6c0d-49a5-8ddf-e3b0ee0900ee"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[06]]></text> </staticText> <staticText> <reportElement x="230" y="0" width="30" height="20" uuid="8c7b43fd-537e-4547-a9c9-93e9381f9258"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[07]]></text> </staticText> <staticText> <reportElement x="260" y="0" width="30" height="20" uuid="b0def6b1-db33-44ba-a810-8e0f4d074eea"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[08]]></text> </staticText> <staticText> <reportElement x="290" y="0" width="30" height="20" uuid="aad667d4-fb93-4783-ac72-f4e0cee79278"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[09]]></text> </staticText> <staticText> <reportElement x="320" y="0" width="30" height="20" uuid="42c42603-887b-41da-a95d-53720d712adc"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[10]]></text> </staticText> <staticText> <reportElement x="350" y="0" width="30" height="20" uuid="e2218a77-f3d6-42cb-aadf-9e925d98f5d8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[11]]></text> </staticText> <staticText> <reportElement x="380" y="0" width="30" height="20" uuid="65c8ad11-8c50-4fc6-a8a7-d6e1e124e3c0"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[12]]></text> </staticText> <staticText> <reportElement x="410" y="0" width="30" height="20" uuid="9e26664c-7c90-4619-89c0-90b65328dbe6"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[13]]></text> </staticText> <staticText> <reportElement x="440" y="0" width="30" height="20" uuid="03bcf2a6-4771-4743-aa3e-bf8d6fce5025"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[14]]></text> </staticText> <staticText> <reportElement x="470" y="0" width="30" height="20" uuid="dd3e16f6-de63-4530-86a7-5c01799e8bbd"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[15]]></text> </staticText> <staticText> <reportElement x="500" y="0" width="30" height="20" uuid="f083bdaa-ad54-40a1-95d4-9c6495e55886"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[16]]></text> </staticText> <staticText> <reportElement x="530" y="0" width="30" height="20" uuid="38e9f922-8be2-4601-b708-a6649b60c1f5"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[17]]></text> </staticText> <staticText> <reportElement x="560" y="0" width="30" height="20" uuid="988c082a-25fb-4aba-99a4-5ce30ff7dacf"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[18]]></text> </staticText> <staticText> <reportElement x="590" y="0" width="30" height="20" uuid="99b5bfa2-14d9-4c98-9745-5fb229d3ecea"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[19]]></text> </staticText> <staticText> <reportElement x="620" y="0" width="30" height="20" uuid="241b50ab-7b23-4b92-8f41-6e85d0a4f93f"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[20]]></text> </staticText> <staticText> <reportElement x="650" y="0" width="30" height="20" uuid="5552c308-060e-4950-80ca-f179755a5f7b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[21]]></text> </staticText> <staticText> <reportElement x="680" y="0" width="30" height="20" uuid="a3aa78dc-0fe9-419a-9c1f-90493855eb72"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[22]]></text> </staticText> <staticText> <reportElement x="710" y="0" width="30" height="20" uuid="f64cb038-d7f9-40bd-bf07-4c0e5532f4cb"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="52222dc0-dfc6-45b4-929b-93fe46943677"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[23]]></text> </staticText> </band> </columnHeader> <detail> <band height="14" splitType="Stretch"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <textField pattern="dd"> <reportElement x="0" y="0" width="20" height="14" uuid="d318f686-5b77-46ad-9e0f-854f7e40d0c1"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="41ef43a7-23bd-4c8d-a0da-57d39e708cd2"/> </reportElement> <textFieldExpression><![CDATA[$F{DATA}]]></textFieldExpression> </textField> <textField pattern="#,##0.0#"> <reportElement style="Custos00" x="20" y="0" width="30" height="14" isPrintInFirstWholeBand="true" uuid="84621f7f-b9ff-424c-b5cb-920927e437d5"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="db8a9906-bd2a-439f-883a-05c339fd6016"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{00H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos01" x="50" y="0" width="30" height="14" uuid="810f56f7-e0b0-47ca-9339-a7db0e43185a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="94765527-9a40-4399-8917-e61756e39c34"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{01H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos02" x="80" y="0" width="30" height="14" uuid="2b452044-1235-4eeb-a22a-d36989971701"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7b0616d8-fc58-4767-8378-c3aea66191cd"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{02H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos03" x="110" y="0" width="30" height="14" uuid="8b5cd79e-4c1d-4da5-b429-720d0c5afc20"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1bda7540-8958-4038-8e0d-836108992194"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{03H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos04" x="140" y="0" width="30" height="14" uuid="92d86f64-bdd4-4e1d-b538-ade501231904"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a217f0e-ded6-416a-894f-4f1dd0901248"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{04H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos05" x="170" y="0" width="30" height="14" uuid="36b63b2d-0e1d-4168-9860-95b84ed79656"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="80985c54-71f5-40bb-b4b5-a3e578956830"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{05H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos06" x="200" y="0" width="30" height="14" uuid="95c0d807-41cd-4365-9c7c-f735601221b4"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="55b288e8-74d0-4ff4-872e-3af8db13598a"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{06H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos07" x="230" y="0" width="30" height="14" uuid="aba3374a-389c-4efc-ac1d-17b8e85c3ea5"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fd1ca58d-24f0-4822-ae0f-cc369b093634"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{07H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos08" x="260" y="0" width="30" height="14" uuid="5c72686b-4fcb-44f4-9a6e-0be4cad5e2a7"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d9816fc8-8797-4873-b19d-c4faca5ea1e2"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{08H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos09" x="290" y="0" width="30" height="14" uuid="2b219131-32a3-46a2-a04a-0aa1cdd8f5e8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="788a1020-aa48-4214-9a9b-0bb1074d6bb8"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{09H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos10" x="320" y="0" width="30" height="14" uuid="3db53c34-f104-4e58-b4a8-10af3a159d74"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="24867831-bae8-4aa5-9776-8ee1e0261f6e"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{10H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos11" x="350" y="0" width="30" height="14" uuid="e810699c-1188-449d-983c-af4458ef590c"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c8926897-471b-4427-8ff8-f757d408d7bb"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{11H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos12" x="380" y="0" width="30" height="14" uuid="ab40fefe-4116-444c-b4b3-101617556a19"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d7390e22-e40e-47a3-a489-20cd83d1c7f4"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{12H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos13" x="410" y="0" width="30" height="14" uuid="319c72b9-d75c-40a1-a6fb-fcaeabf28a31"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="604c80db-8465-4d77-bf69-162fcd94663e"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{13H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos14" x="440" y="0" width="30" height="14" uuid="fbc5abfb-4374-45bb-9a31-1aabc8db0455"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3e730677-9986-4e2f-980d-bfcc7cb23d7b"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{14H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos15" x="470" y="0" width="30" height="14" uuid="92c00a32-4d0b-41a1-b4dc-68aa42b9e5c8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="75aee0ea-f8fa-451e-8aea-66f4b1272b5b"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{15H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos16" x="500" y="0" width="30" height="14" uuid="d93aba62-eff7-4c4c-8388-d3e825aa57f1"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9332c1c0-e17f-4704-802d-d8534861552a"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{16H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos17" x="530" y="0" width="30" height="14" uuid="5992ea79-7f20-4830-b14b-6670e392e35e"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f101e708-d25f-4678-aac5-625f4c021308"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{17H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos18" x="560" y="0" width="30" height="14" uuid="4dff8703-55bf-4b65-9c37-7318c457e768"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="88e50703-ab90-4780-ba73-d67dd84537b4"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{18H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos19" x="590" y="0" width="30" height="14" uuid="18a88221-1cee-49df-8e46-9b40aef653f9"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b624cecd-161b-4d42-ae76-a9fe4f50da77"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{19H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos20" x="620" y="0" width="30" height="14" uuid="e81cec93-9ee8-4aee-acfa-71595161e59d"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1c27895a-f369-49d1-a8c7-ca4d7eabd174"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{20H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos21" x="650" y="0" width="30" height="14" uuid="9de75304-3ad2-4589-820c-87fb52eec342"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="900f5c57-68d7-43af-9c32-3d2479de5536"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{21H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos22" x="680" y="0" width="30" height="14" uuid="69dc5a06-9584-4a26-8447-e564e40bf7e8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="72e6b463-8980-40b8-ae07-0c345f440732"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{22H_Custo}]]></textFieldExpression> </textField> <textField> <reportElement style="Custos23" x="710" y="0" width="30" height="14" uuid="640bc497-2c64-4180-b53f-e0bd4734f737"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ad42be42-d2dc-4411-8f15-4436266d20b7"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$F{23H_Custo}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="740" y="0" width="30" height="14" uuid="419446a2-1e4c-420e-a14e-a3a56c81ad49"/> <textFieldExpression><![CDATA[$V{TotalDiario}]]></textFieldExpression> </textField> <textField> <reportElement x="770" y="0" width="30" height="14" printWhenGroupChanges="DATA" uuid="389f9106-49e1-41f8-be26-9b351d68fa62"/> <textFieldExpression><![CDATA[$V{PercDia}]]></textFieldExpression> </textField> </band> </detail> <pageFooter> <band splitType="Stretch"/> </pageFooter> <summary> <band height="14" splitType="Stretch"> <textField evaluationTime="Column" pattern="#,##0.00"> <reportElement x="20" y="0" width="30" height="14" uuid="e78bac4d-4ac6-40a0-9898-3055f3e5a29d"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum00}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="50" y="0" width="30" height="14" uuid="6884bb8b-0a75-4523-913b-26945d1182ab"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum01}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="80" y="0" width="30" height="14" uuid="48ae0962-3425-4905-a0c7-3e1fb83e00d7"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum02}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="110" y="0" width="30" height="14" uuid="aec53029-34d6-4b31-82a3-0de5f86c5151"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum03}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="140" y="0" width="30" height="14" uuid="d9f97372-cb61-4c56-94f7-51b8a6c97e4d"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum04}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="170" y="0" width="30" height="14" uuid="f03ebba8-7db4-4261-b80a-4556fb29536e"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum05}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="200" y="0" width="30" height="14" uuid="094b789b-8ff7-4b6e-9f4d-28a1b30154bc"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum06}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="230" y="0" width="30" height="14" uuid="c33e8add-73e8-45a0-a915-eaa66135c576"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum07}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="260" y="0" width="30" height="14" uuid="ba07f080-b90b-4d35-91f7-5ac8788a63e5"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum08}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="290" y="0" width="30" height="14" uuid="1a98f14e-e06e-4832-a44b-65245ffeabc4"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum09}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="320" y="0" width="30" height="14" uuid="456ead2e-9446-48f2-b5d9-398cbbed777b"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum10}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="350" y="0" width="30" height="14" uuid="63fa38c1-466d-454f-808f-feec4b3d9529"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum11}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="380" y="0" width="30" height="14" uuid="8d7bb4a9-e177-4841-ab97-ada066c2dfbd"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum12}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="410" y="0" width="30" height="14" uuid="0708ce41-cefc-48f2-b6d0-ef016a2056e6"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum13}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="440" y="0" width="30" height="14" uuid="54ee826c-63f7-4e6e-ad53-f6d1d8676767"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum14}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="470" y="0" width="30" height="14" uuid="a597145e-944e-4424-9c76-8e76b8b417c5"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum15}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="500" y="0" width="30" height="14" uuid="acd4992a-4901-4012-9182-39e09152850d"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum16}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="530" y="0" width="30" height="14" uuid="7a8d3243-ce2c-4d18-abaa-71c8d6fe26d5"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum17}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="560" y="0" width="30" height="14" uuid="13f42628-f4b9-4d04-9fcd-e568907a4b0f"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum18}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="590" y="0" width="30" height="14" uuid="3a91b8bc-3ce6-423b-8239-16b007c9f806"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum19}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="620" y="0" width="30" height="14" uuid="318b293e-99fe-4ab0-9321-16469cb4e5e8"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum20}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="650" y="0" width="30" height="14" uuid="471daa8d-9488-484c-8e0e-5b8d678446bf"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum21}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="680" y="0" width="30" height="14" uuid="45a63439-1e93-4d6f-9d8b-f1c86aa56b81"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum22}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="710" y="0" width="30" height="14" uuid="f7849578-97fa-4a66-aa7c-1012fcfcd9e4"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Sum23}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement x="740" y="0" width="30" height="14" uuid="519e6d9d-a0f6-4680-855e-e76110a881bd"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{SumTotal}]]></textFieldExpression> </textField> </band> </summary> </jasperReport>

Is this fine ? can you verify?

put heading in pageHeader Section and Fields in Detail Band, nono of the issue i found your report, try to optimize your Query. use COALESCE.

---

yes in jasper server did you try the parameter pop up in report configuration?

Go to in Outline --> style --> right click on Style and Create Style --> right click on Style (you created) and click on create conditional Style. Put the conational whatever you want and style for that specific condition.

I want to use two Databases for single report (Oracle and Postgres) in oracle i have procedure to call a report and in postgres i have a function, how can i call single report from both databases , when i select Oracle from application it fetches data from Oracle and when i select Postgres it fetches from Postgres. any Help!

Are you using CrossTab Element?

you might share your jrxml file so i can take a look.

Maybe space before text in data try using space escape in DB fields.

its path issue try to put report in project directory. Your report is fine./sites/all/libraries/ckeditor/plugins/smiley/images/thumbs_up.png

Try this solution https://stackoverflow.com/questions/52097569/jasper-reports-add-static-text-row-in-table

What Element you are using in jasper report?

if you are using DB make query and put it in paramtere.

Yes, you have to resize/postion the components by your self.