This with this error, What can be?

guilherme_5 · May 11, 2015

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"?>


<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">
 
 </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>
 
 </textElement>
 <text><![CDATA[COMPETÊNCIA:]]></text>
 </staticText>
 <staticText>
 <reportElement x="280" y="80" width="100" height="20" uuid="9506fbc3-6d75-49f0-851c-f485d8d74f25"/>
 <textElement>
 
 </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>
 
 </textElement>
 <text><![CDATA[GESTOR COMERCIAL:]]></text>
 </staticText>
 <staticText>
 <reportElement x="1260" y="80" width="170" height="20" uuid="8f7a711a-a907-4c1e-9776-430a2b6e6c08"/>
 <textElement>
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 </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">
 
 <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>

hozawa · May 12, 2015

You've tagged this as an iReport problem.

From your question, you've created the jrxml file using Jaspersoft Studio version 5.6.2.final. Since the last iReport is 5.6.0, you'll need to be using Jaspersoft Studio 5.6.2.

marianol · May 12, 2015

I think that the problem may be that yout field "frete_bruto" in your database is not a double, is probably a string and that is where you problem lays.

I say this because looking at your report I see this:

So all your fields that have information about the "frete" are declared as Strings that leads me to belive that "frete_bruto" is also stored as a String and you changed the type in JSS, that will not work.

If the value is stored as a String and there is nothing you can do about it you will have to declare the field as a String (<field name="frete_bruto" class="java.lang.String"/>) and then Cast that String to Double in a Variable or Textbox in JasperSoft Studio if you need to use it as a number. You will do that with something like this: "Double.valueOf($F{frete_bruto});"

Sign In

This with this error, What can be?

Recommended Posts

guilherme_5

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

hozawa

Link to comment

Share on other sites

marianol

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore