lmbaptista Posted September 16, 2020 Share Posted September 16, 2020 Hello.I'm using Jasper Studio 6.12.2 and all libraries are 6.12.2 as you can see in the image attached.However, in the preview I can't align the texts, in this case at left.What can be wrong?This happens with fields that are being retrieved from a field in the database and the datatype is text.If the datatype is somehow numeric (integer, double, float), it align.If the datatype is date and a pattern is defined, it align.However, if it's a text field it aplies some kind of identation that I can't remove. Anyone with teh same problem who can help me, please?Thanks in advanceLuís Link to comment Share on other sites More sharing options...
Sad H Posted September 16, 2020 Share Posted September 16, 2020 Maybe space before text in data try using space escape in DB fields. Link to comment Share on other sites More sharing options...
lmbaptista Posted September 16, 2020 Author Share Posted September 16, 2020 Thank you for the suggestion , Sad H, but it's not useful.I can't change the database fields because they are populated by dropdownlists in an aplication.Then, adding spaces doesn't solve the problem because the left alignment does not fix with spaces (at left or right).This is some kind of problem with Studio and I can't find it or solve it. Link to comment Share on other sites More sharing options...
Sad H Posted September 17, 2020 Share Posted September 17, 2020 you might share your jrxml file so i can take a look. Link to comment Share on other sites More sharing options...
Sad H Posted September 17, 2020 Share Posted September 17, 2020 Are you using CrossTab Element? Link to comment Share on other sites More sharing options...
lmbaptista Posted September 17, 2020 Author Share Posted September 17, 2020 No. I'm not using any special element. Link to comment Share on other sites More sharing options...
lmbaptista Posted September 17, 2020 Author Share Posted September 17, 2020 ok. here you have it. Link to comment Share on other sites More sharing options...
djohnson53 Posted September 17, 2020 Share Posted September 17, 2020 lmbaptista , I lost your attachment. Could you re-attach it to the question? Edit the question and then attach the file to it.Sorry. Link to comment Share on other sites More sharing options...
lmbaptista Posted September 17, 2020 Author Share Posted September 17, 2020 The jrxml file is attached to the main question Link to comment Share on other sites More sharing options...
Sad H Posted September 18, 2020 Share Posted September 18, 2020 --- Link to comment Share on other sites More sharing options...
Sad H Posted September 18, 2020 Share Posted September 18, 2020 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. Link to comment Share on other sites More sharing options...
lmbaptista Posted September 18, 2020 Author Share Posted September 18, 2020 Well... this file I shared is truncated from the original report to keep only the headers (where the problem is).I now realize that when I run it, it looks correctly aligned. However, if I keep the report with all information (variables, parameters,conditional styles) it lose the alignment and the result is like the image I attached initially.How can the code in the details band influence the code in the page header causing the loss of alignment?I share the full report with all information, maybe you can discover something I'm missing.Thanks in advance Link to comment Share on other sites More sharing options...
Sad H Posted September 21, 2020 Share Posted September 21, 2020 Is this fine ? can you verify? Link to comment Share on other sites More sharing options...
lmbaptista Posted September 21, 2020 Author Share Posted September 21, 2020 Yes, apparently looks fine. Correctly aligned at left. Link to comment Share on other sites More sharing options...
Sad H Posted September 22, 2020 Share Posted September 22, 2020 <?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> Link to comment Share on other sites More sharing options...
lmbaptista Posted September 22, 2020 Author Share Posted September 22, 2020 Thanks for the effort. It was easier to upload the file than copy the code. However...I don't know what have you done but apparently you changed the field that was a database field to a text field and text fields I can aligne them. The problem only happens with database fields.And more, now i get an error exception: "java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Number" that I don't know where it is. Link to comment Share on other sites More sharing options...
Sad H Posted September 22, 2020 Share Posted September 22, 2020 Actuly i dont have your DB thats why i did that, you just change the field type to number. Link to comment Share on other sites More sharing options...
lmbaptista Posted September 22, 2020 Author Share Posted September 22, 2020 Solved it.In the Text Filed Properties, I defined Tab Stop Width to 1px (it was 40, by default) and it worked. It is strange why that happen only with database fields with type "string" and does not happen with numbers or dates. Some JS buggy configuration.Anyway, it is fixed. Thanks. Link to comment Share on other sites More sharing options...
Sad H Posted September 23, 2020 Share Posted September 23, 2020 great. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now