Ir para conteúdo

POWERED BY:

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

Guilherme Costa Lopes

ireport

Por , em Java

Recommended Posts

Guilherme Costa Lopes    0

Guilherme Costa Lopes
Postado

Esta com este erro: net.sf.jasperreports.engine.JRException: Unable to get value for field 'frete_bruto' of class 'java.lang.Double'

 

O que pode ser ?

 

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

Compartilhar este post

Link para o post
Compartilhar em outros sites

Vergil    15

Vergil
Postado

Seria melhor se tu postasses toda a pilha do erro. A princípio eu arriscaria dizer que pode ser um problema de conversão. Tens certeza de que o campo frete_bruto é do tipo Double?

Compartilhar este post

Link para o post
Compartilhar em outros sites
Ir para a lista de tópicos Java
×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.

  Aceito