Sad H
Members-
Posts
43 -
Joined
-
Last visited
Sad H's Achievements
-
Sad H started following Custom Font not applying in pdf report , Connection issue with Jasper server 9. , Getting different design on local and server of same jasper report. and 4 others
-
jasper server 9 is using different URL String it is adding Organization name in it now.
-
Jaspersoft Studio - Multiple Datasets - Sharing Data
Sad H replied to mike.atkinson's topic in Products
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. -
Exception "wrong name" with report's name
Sad H replied to emilio.cuberos's topic in Developers and API
This Might help https://community.jaspersoft.com/forums/topic/67916-javalangnoclassdeffounderror-jrxxxxxxxx-_1811b31b27d13da1f8bc9955038dc0646b5de2a76581526d5a0228d015ebfd49-wrong-name-jrxxxxxxxx/ -
Try this it is working.
-
Text fields from a database are not aligning correctly
Sad H replied to lmbaptista's topic in Products
great. -
Text fields from a database are not aligning correctly
Sad H replied to lmbaptista's topic in Products
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.
-
Text fields from a database are not aligning correctly
Sad H replied to lmbaptista's topic in Products
<?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> -
Text fields from a database are not aligning correctly
Sad H replied to lmbaptista's topic in Products
Is this fine ? can you verify? -
Text fields from a database are not aligning correctly
Sad H replied to lmbaptista's topic in Products
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. -
Text fields from a database are not aligning correctly
Sad H replied to lmbaptista's topic in Products
--- -
yes in jasper server did you try the parameter pop up in report configuration?