guilherme_5

net.sf.jasperreports.engine.JRException: Unable to get value for field 'frete_bruto' of class 'java.lang.Double' <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 5.6.2.final using JasperReports Library version 5.6.1 --> <!-- 2015-05-08T19:28:30 --> <jasperReport xmlns="http://jasperreports.../jasperreports"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports...sperreport.xsd" name="Blank_A4" pageWidth="1684" pageHeight="2380" columnWidth="1644" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d2fd1dfc-f0a2-498f-baf8-c32a0c69ac05"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="cpi"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <queryString language="SQL"> <![CDATA[sELECT comercial, cmp_digitado, cmp_pago, recebeu, status, data, processo_pe, cliente, valor_carga, seguro, cte, frete_bruto, acumulado, st, imposto, v_icms, c_cliente, despesa_extra, sub_total, frete_cotado, frete_pago, frete_liquido, icms, rentabilidade, p_comissao, v_comissao, prazo, vencimento, recebimento, dias_atraso, juros, real_comissao, id, emp_id, est_des, est_origem FROM processos.view_p_comissoes]]> </queryString> <field name="comercial" class="java.lang.String"/> <field name="cmp_digitado" class="java.lang.String"/> <field name="cmp_pago" class="java.lang.String"/> <field name="recebeu" class="java.lang.String"/> <field name="status" class="java.lang.String"/> <field name="data" class="java.lang.String"/> <field name="processo_pe" class="java.lang.String"/> <field name="cliente" class="java.lang.String"/> <field name="valor_carga" class="java.lang.String"/> <field name="seguro" class="java.lang.String"/> <field name="cte" class="java.lang.String"/> <field name="frete_bruto" class="java.lang.Double"/> <field name="acumulado" class="java.lang.String"/> <field name="st" class="java.lang.String"/> <field name="imposto" class="java.lang.String"/> <field name="v_icms" class="java.lang.String"/> <field name="c_cliente" class="java.lang.String"/> <field name="despesa_extra" class="java.lang.String"/> <field name="sub_total" class="java.lang.String"/> <field name="frete_cotado" class="java.lang.String"/> <field name="frete_pago" class="java.lang.String"/> <field name="frete_liquido" class="java.lang.String"/> <field name="icms" class="java.lang.String"/> <field name="rentabilidade" class="java.lang.String"/> <field name="p_comissao" class="java.lang.String"/> <field name="v_comissao" class="java.lang.String"/> <field name="prazo" class="java.lang.Integer"/> <field name="vencimento" class="java.lang.String"/> <field name="recebimento" class="java.lang.String"/> <field name="dias_atraso" class="java.lang.Integer"/> <field name="juros" class="java.lang.String"/> <field name="real_comissao" class="java.lang.String"/> <field name="id" class="java.lang.Long"/> <field name="emp_id" class="java.lang.Long"/> <field name="est_des" class="java.lang.String"/> <field name="est_origem" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <title> <band height="138" splitType="Stretch"> <image> <reportElement x="-1" y="0" width="108" height="60" uuid="34c7655e-0152-42ac-a1d0-25a36b555729"/> <imageExpression><![CDATA["http://cpi.frontlog.com.br/webrun/images/image001.jpg"]]></imageExpression> </image> <image> <reportElement x="1488" y="0" width="68" height="25" uuid="31e60c18-94fa-455d-8c21-5edddda6b658"/> <imageExpression><![CDATA["http://cpi.frontlog.com.br/webrun/images/image002.jpg"]]></imageExpression> </image> <staticText> <reportElement x="0" y="10" width="1560" height="30" uuid="eac6bded-9cf3-441b-af1d-dbc067b0bf72"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial Black" size="20"/> </textElement> <text><![CDATA[PLANILHA DE META E FATURAMENTO MENSAL]]></text> </staticText> <staticText> <reportElement x="-1" y="80" width="100" height="20" uuid="0c2757f9-d05b-435a-b182-d7d429b4515a"/> <textElement> <font fontName="Arial Black" size="11"/> </textElement> <text><![CDATA[COMPETÊNCIA:]]></text> </staticText> <staticText> <reportElement x="280" y="80" width="100" height="20" uuid="9506fbc3-6d75-49f0-851c-f485d8d74f25"/> <textElement> <font fontName="Arial Black" size="11"/> </textElement> <text><![CDATA[FUNCIONÁRIO(A):]]></text> </staticText> <staticText> <reportElement x="830" y="80" width="140" height="20" uuid="d0db3522-7891-41ef-a8fd-9aaffccc024e"/> <textElement> <font fontName="Arial Black" size="11"/> </textElement> <text><![CDATA[GESTOR COMERCIAL:]]></text> </staticText> <staticText> <reportElement x="1260" y="80" width="170" height="20" uuid="8f7a711a-a907-4c1e-9776-430a2b6e6c08"/> <textElement> <font fontName="Arial Black" size="11"/> </textElement> <text><![CDATA[VALOR TOTAL COMISSÃO:]]></text> </staticText> <staticText> <reportElement x="0" y="107" width="51" height="31" uuid="dbe80cb8-9166-41f0-b209-b0ff2ca0cd6a"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[DATA]]></text> </staticText> <staticText> <reportElement x="51" y="107" width="100" height="31" uuid="136ffda1-a42a-4e7e-b058-55d21356dd49"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[CLIENTE]]></text> </staticText> <staticText> <reportElement x="251" y="107" width="50" height="31" uuid="23927857-c8ef-4b82-9c9b-6fdb8ca03f6a"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[DESTINO UF]]></text> </staticText> <staticText> <reportElement x="201" y="107" width="50" height="31" uuid="b0458c11-6a86-466c-817a-7c04f9fbd4ee"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[ORIGEM UF]]></text> </staticText> <staticText> <reportElement x="151" y="107" width="50" height="31" uuid="e3ce52b8-ef82-450b-91cb-738183232198"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[VALOR DA CARGA]]></text> </staticText> <staticText> <reportElement x="390" y="107" width="49" height="31" uuid="bd3bd426-163e-41fe-846b-62e698b62689"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[FRETE BRUTO ]]></text> </staticText> <staticText> <reportElement x="301" y="107" width="50" height="31" uuid="ec3a54b7-20c7-437e-9893-2483a2be37fe"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[sEGURO PAGO]]></text> </staticText> <staticText> <reportElement x="351" y="107" width="39" height="31" uuid="01bea640-4b20-43dc-a502-07b7cc6c90e4"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[CT-e]]></text> </staticText> <staticText> <reportElement x="439" y="107" width="51" height="31" uuid="1cb47452-2fd1-44b7-9883-4918793fc80a"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[Frete acumulado para Meta]]></text> </staticText> <staticText> <reportElement x="693" y="107" width="51" height="31" uuid="b7b121ef-85c2-4699-962c-2780b37e9ae4"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[DESPESAS EXTRAS]]></text> </staticText> <staticText> <reportElement x="1410" y="107" width="30" height="31" uuid="472081c3-26fc-4c5a-8ed2-646799220507"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[JUROS ]]></text> </staticText> <staticText> <reportElement x="744" y="107" width="81" height="31" uuid="e2acdb49-eb57-4ae4-abf2-13cc580ef696"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[sUBTOTAL FRETE PARA CALCULO DE COMISSÃO]]></text> </staticText> <staticText> <reportElement x="825" y="107" width="61" height="31" uuid="effdeb25-a752-4e0b-b8ef-63d3e5435c51"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[FRETE COTADO CARRETEIRO]]></text> </staticText> <staticText> <reportElement x="947" y="107" width="51" height="31" uuid="76cf5d3c-684a-4bc2-9dd7-cea13b4d924a"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[FRETE LIQUIDO]]></text> </staticText> <staticText> <reportElement x="998" y="107" width="51" height="31" uuid="91cb8a60-e7fe-4d5a-894d-b92f9cc483f3"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[ALIQUOTA ICMS]]></text> </staticText> <staticText> <reportElement x="1250" y="107" width="60" height="31" uuid="ad0ab3f5-8d18-4039-b4e2-72a1d193f071"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[VENCIMENTO FATURA]]></text> </staticText> <staticText> <reportElement x="1141" y="107" width="49" height="31" uuid="5ee24f58-cadc-41b8-990c-b57804c5dff2"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[VALOR COMISSÃO]]></text> </staticText> <staticText> <reportElement x="1440" y="107" width="49" height="31" uuid="b2a45752-ad5f-4a78-a405-7060e7781145"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[JUROS RECEBIDO?]]></text> </staticText> <staticText> <reportElement x="1190" y="107" width="60" height="31" uuid="da477add-cc1e-4055-9dec-b2c6defbf07a"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[PRAZO PAGAMENTO ]]></text> </staticText> <staticText> <reportElement x="1489" y="107" width="60" height="31" uuid="8f301915-4405-46b1-aea8-44eab3ef4904"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[VALOR REAL DA COMISSÃO ]]></text> </staticText> <staticText> <reportElement x="1049" y="107" width="71" height="31" uuid="1d267856-e75a-4d27-9409-d69dd59f3e7c"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[RENTABILIDADE MEMORIA DE CALCULO ]]></text> </staticText> <staticText> <reportElement x="1310" y="107" width="60" height="31" uuid="686661dc-d231-4a6b-8998-eff7cef0da33"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[DATA DO RECEBIMENTO]]></text> </staticText> <staticText> <reportElement x="886" y="107" width="61" height="31" uuid="aa047404-8b91-412a-8779-bbc9e8b37621"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[FRETE PAGO CARRETEIRO]]></text> </staticText> <staticText> <reportElement x="1370" y="107" width="40" height="31" uuid="c61ed825-1775-4abb-b05f-c4b0a1a11ce8"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[DIAS DE ATRASO]]></text> </staticText> <staticText> <reportElement x="490" y="107" width="61" height="31" uuid="2d144d7d-0954-4919-8ef3-e807c2b49a65"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[CALCULO SUBSTITUIÇÃO TRIBUTARIA]]></text> </staticText> <staticText> <reportElement x="601" y="107" width="41" height="31" uuid="0f24521c-12f7-46fd-9ca4-a4490b10643e"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[VALOR ICMS]]></text> </staticText> <staticText> <reportElement x="642" y="107" width="51" height="31" uuid="f6b03415-8890-48d4-9541-81165bfc36cd"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[COMISSÃO CLIENTE]]></text> </staticText> <staticText> <reportElement x="551" y="107" width="50" height="31" uuid="2e4b833d-f88d-44f2-8f1a-1d5440739b59"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[iMPOSTOS]]></text> </staticText> <staticText> <reportElement x="1120" y="107" width="21" height="31" uuid="c64de1a2-ef4e-49aa-bd78-178359b876ea"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <text><![CDATA[%]]></text> </staticText> <textField> <reportElement x="107" y="80" width="100" height="20" uuid="aecb2eff-dc60-4526-8320-33f58e42eff5"/> <textFieldExpression><![CDATA[$F{cmp_pago}]]></textFieldExpression> </textField> <textField> <reportElement x="380" y="80" width="221" height="20" uuid="4a44422e-683c-4d71-9db5-563938fed5ea"/> <textFieldExpression><![CDATA[$F{comercial}]]></textFieldExpression> </textField> </band> </title> <detail> <band height="40" splitType="Stretch"> <textField pattern="#,##0.00#"> <reportElement x="601" y="0" width="41" height="40" uuid="fbac5155-f0f6-4937-bc42-5b7fc0d38b6f"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{icms}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="551" y="0" width="50" height="40" uuid="b30150b7-282a-4788-85f7-b6124b466f90"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{imposto}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="0" y="0" width="51" height="40" uuid="19012e66-5184-4793-9698-e01c43662204"> <property name="local_mesure_unitwidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="local_mesure_unitx" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="px"/> </reportElement> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{data}]]></textFieldExpression> </textField> <textField> <reportElement x="351" y="0" width="39" height="40" uuid="f040f669-a0c5-48c4-9a3a-c632c69d285b"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{cte}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="642" y="0" width="51" height="40" uuid="4bbd6304-5218-4a50-8154-ce9540d4db36"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{c_cliente}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="693" y="0" width="51" height="40" uuid="f6b57278-d0c0-4d2c-88d1-490feab11fc0"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{despesa_extra}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="390" y="0" width="49" height="40" uuid="8c402fe3-4d73-48b8-a928-808efe3d17f7"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{frete_bruto}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="744" y="0" width="81" height="40" uuid="bd76f6bc-d992-4139-9977-5d28133e6236"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{sub_total}]]></textFieldExpression> </textField> <textField> <reportElement x="886" y="0" width="61" height="40" uuid="e93eb667-0a5f-400c-865c-4b40d873736e"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{frete_pago}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="1410" y="0" width="30" height="40" uuid="5e0c0a03-d07a-4e4f-9535-76b408ff48cc"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{juros}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="1440" y="0" width="49" height="40" uuid="662d13be-aad9-4d3d-8cd2-52e1894d9c90"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{recebeu}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="1489" y="0" width="60" height="40" uuid="061abe2b-fef2-457d-8073-966ea9b8539d"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{real_comissao}]]></textFieldExpression> </textField> <textField> <reportElement x="1370" y="0" width="40" height="40" uuid="1cd327d4-5d9e-4b8f-a09b-64763bf858c0"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{dias_atraso}]]></textFieldExpression> </textField> <textField pattern="dd/MM/yyyy"> <reportElement x="1310" y="0" width="60" height="40" uuid="3db41713-2bfc-4119-b64e-8c76c6301216"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{recebimento}]]></textFieldExpression> </textField> <textField pattern="" isBlankWhenNull="true"> <reportElement x="1250" y="0" width="60" height="40" uuid="54aba0fb-8426-4973-8a0f-747b5b4c370f"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{vencimento}]]></textFieldExpression> </textField> <textField> <reportElement x="1190" y="0" width="60" height="40" uuid="82082019-74d0-4399-8491-9717b6abe74c"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{prazo}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="1141" y="0" width="49" height="40" uuid="479bfa71-3e15-43e0-8422-6124d92b7cd0"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{v_comissao}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="1120" y="0" width="21" height="40" uuid="bb34fa57-ef9f-498c-a6f2-bc12d48c6c6b"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{p_comissao}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="1049" y="0" width="71" height="40" uuid="c6b6df33-c054-4a3c-bc92-2470beeb9479"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{rentabilidade}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="947" y="0" width="51" height="40" uuid="badd4a14-7903-4efc-adba-8c65b884978a"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{frete_liquido}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="151" y="0" width="50" height="40" uuid="99dfe6d7-66ae-47c9-97a3-1fe5c695dd48"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{valor_carga}]]></textFieldExpression> </textField> <textField> <reportElement x="251" y="0" width="50" height="40" uuid="83f12470-ae89-4327-a336-159b08248578"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{est_des}]]></textFieldExpression> </textField> <textField> <reportElement x="201" y="0" width="50" height="40" uuid="db219b58-efbb-4f29-8074-b081fd51fd83"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{est_origem}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="301" y="0" width="50" height="40" uuid="db180637-7076-4ecd-be15-f988f305ed27"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{seguro}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="439" y="0" width="51" height="40" uuid="84930196-1dba-4285-aa8e-e3fcd8a8e1e5"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{acumulado}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="490" y="0" width="61" height="40" uuid="d2650d00-7cfd-440c-8512-8ea58b8ac839"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{st}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="825" y="0" width="61" height="40" uuid="c0adc1ae-416a-437b-a137-5f88d5fba6b6"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{frete_cotado}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="998" y="0" width="51" height="40" uuid="8d553dc2-76a4-4fd9-9b3f-4c648ee0d10e"/> <box> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[$F{icms}]]></textFieldExpression> </textField> <textField> <reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="51" y="0" width="100" height="40" forecolor="#000000" backcolor="#FFFFFF" uuid="90579666-3279-4b3f-a013-a6ad8c835253"/> <box padding="0" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> <topPen lineWidth="1.0"/> <leftPen lineWidth="1.0"/> <bottomPen lineWidth="1.0"/> <rightPen lineWidth="1.0"/> </box> <textElement textAlignment="Left" verticalAlignment="Top" rotation="None" markup="html"> <font fontName="Arial" size="8" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/> <paragraph lineSpacing="Double" lineSpacingSize="1.0" firstLineIndent="0" leftIndent="0" rightIndent="0" spacingBefore="0" spacingAfter="0" tabStopWidth="40"/> </textElement> <textFieldExpression><![CDATA[$F{cliente}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="15" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="20" splitType="Stretch"> <textField> <reportElement x="1358" y="0" width="100" height="20" uuid="482cd871-b7f5-4a48-a9b9-0f08a2560d82"/> <textElement textAlignment="Right"/> <textFieldExpression><![CDATA["Página " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="1458" y="0" width="100" height="20" uuid="2ac20bdb-b12a-42af-b4c9-26261310d0e7"/> <textElement textAlignment="Left"/> <textFieldExpression><![CDATA[" de " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="46" splitType="Stretch"/> </summary> </jasperReport>