Please help me solve the following error in my code !

Question

1.00/5 (1 vote)

See more:

error in something :net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : size

What I have tried:

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 4.5.0  -->
<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="report name" pageWidth="595" pageHeight="842" whenNoDataType="NoPages" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.7715610000000028"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="221"/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
	<parameter name="Parameter32" class="java.lang.String"/>
	<parameter name="Parameter31" class="java.lang.String"/>
	<parameter name="Parameter29" class="java.lang.String"/>
	<parameter name="Parameter30" class="java.lang.String"/>
	<parameter name="Parameter28" class="java.lang.String"/>
	<parameter name="Parameter26" class="java.lang.String"/>
	<parameter name="Parameter27" class="java.lang.String"/>
	<parameter name="Parameter25" class="java.lang.String"/>
	<parameter name="Parameter21" class="java.lang.String"/>
	<parameter name="Parameter22" class="java.lang.String"/>
	<parameter name="Parameter23" class="java.lang.String"/>
	<parameter name="Parameter24" class="java.lang.String"/>
	<parameter name="Parameter20" class="java.lang.String"/>
	<parameter name="Parameter18" class="java.lang.String"/>
	<parameter name="Parameter19" class="java.lang.String"/>
	<parameter name="Parameter12" class="java.lang.String"/>
	<parameter name="Parameter13" class="java.lang.String"/>
	<parameter name="Parameter14" class="java.lang.String"/>
	<parameter name="Parameter15" class="java.lang.String"/>
	<parameter name="Parameter16" class="java.lang.String"/>
	<parameter name="Parameter17" class="java.lang.String"/>
	<parameter name="Parameter7" class="java.lang.String"/>
	<parameter name="Parameter8" class="java.lang.String"/>
	<parameter name="Parameter9" class="java.lang.String"/>
	<parameter name="Parameter10" class="java.lang.String"/>
	<parameter name="Parameter11" class="java.lang.String"/>
	<parameter name="Parameter6" class="java.lang.String"/>
	<parameter name="Parameter5" class="java.lang.String"/>
	<parameter name="Parameter4" class="java.lang.String"/>
	<parameter name="Parameter3" class="java.lang.String"/>
	<parameter name="Parameter2" class="java.lang.String"/>
	<parameter name="Parameter1" class="java.lang.String"/>
	<parameter name="Parameter34" class="java.lang.String"/>
	<parameter name="Parameter33" class="java.lang.String"/>
	<field name="size" class="java.lang.String"/>
	<field name="ply" class="java.lang.String"/>
	<field name="bndl" class="java.lang.String"/>
	<field name="rate" class="java.lang.String"/>
	<field name="amount" class="java.lang.String"/>
	<field name="hsn" class="java.lang.String"/>
	<field name="desc" class="java.lang.String"/>
	<field name="pcs" class="java.lang.String"/>
	<field name="qty" class="java.lang.String"/>
	<field name="los_pcs" class="java.lang.String"/>
	<title>
		<band height="283" splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="17" splitType="Stretch">
			<rectangle>
				<reportElement x="0" y="0" width="285" height="16"/>
			</rectangle>
			<rectangle>
				<reportElement x="285" y="0" width="270" height="16"/>
			</rectangle>
			<staticText>
				<reportElement x="0" y="0" width="83" height="17"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[INVOICE No. :]]></text>
			</staticText>
			<staticText>
				<reportElement x="441" y="0" width="39" height="16"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[DATE:]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="142" splitType="Stretch">
			<rectangle>
				<reportElement x="0" y="0" width="285" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="285" y="0" width="270" height="142"/>
			</rectangle>
			<staticText>
				<reportElement x="2" y="80" width="54" height="20"/>
				<text><![CDATA[State:]]></text>
			</staticText>
			<staticText>
				<reportElement x="157" y="80" width="40" height="20"/>
				<text><![CDATA[Code:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="0" width="130" height="22"/>
				<text><![CDATA[Buyer's Name & Address]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="100" width="53" height="20"/>
				<text><![CDATA[GSTIN No. :]]></text>
			</staticText>
			<staticText>
				<reportElement x="160" y="100" width="40" height="20"/>
				<text><![CDATA[PAN:]]></text>
			</staticText>
			<staticText>
				<reportElement x="289" y="80" width="41" height="20"/>
				<text><![CDATA[State:]]></text>
			</staticText>
			<staticText>
				<reportElement x="289" y="100" width="54" height="20"/>
				<text><![CDATA[GSTIN No. :]]></text>
			</staticText>
			<staticText>
				<reportElement x="427" y="80" width="38" height="20"/>
				<text><![CDATA[Code:]]></text>
			</staticText>
			<staticText>
				<reportElement x="286" y="2" width="66" height="20"/>
				<text><![CDATA[Delivery at:]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="120" width="49" height="20"/>
				<text><![CDATA[Phone:]]></text>
			</staticText>
			<textField>
				<reportElement x="200" y="77" width="85" height="23"/>
				<textFieldExpression><![CDATA[$P{Parameter5}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="52" y="120" width="76" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter4}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="54" y="100" width="76" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter3}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="52" y="82" width="76" height="17"/>
				<textFieldExpression><![CDATA[$P{Parameter2}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="-1" y="22" width="161" height="18"/>
				<textFieldExpression><![CDATA[$P{Parameter1}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="200" y="100" width="85" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter6}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="340" y="80" width="82" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter7}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="340" y="100" width="81" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter8}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="286" y="22" width="144" height="18"/>
				<textFieldExpression><![CDATA[$P{Parameter9}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="463" y="80" width="90" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter10}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="1" y="40" width="142" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter29}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="-1" y="60" width="142" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter30}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="285" y="60" width="144" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter32}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="286" y="40" width="135" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter31}]]></textFieldExpression>
			</textField>
		</band>
	</columnHeader>
	<detail>
		<band height="162" splitType="Stretch">
			<rectangle>
				<reportElement x="0" y="0" width="83" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="83" y="0" width="117" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="340" y="0" width="39" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="297" y="0" width="43" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="441" y="0" width="38" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="479" y="0" width="76" height="162"/>
			</rectangle>
			<rectangle>
				<reportElement x="200" y="0" width="60" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="260" y="0" width="37" height="142"/>
			</rectangle>
			<rectangle>
				<reportElement x="0" y="0" width="83" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="83" y="0" width="117" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="200" y="0" width="60" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="260" y="0" width="37" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="297" y="0" width="43" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="479" y="0" width="76" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="340" y="0" width="39" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="441" y="0" width="38" height="18"/>
			</rectangle>
			<staticText>
				<reportElement x="5" y="4" width="78" height="18"/>
				<text><![CDATA[DESCRIPTION]]></text>
			</staticText>
			<staticText>
				<reportElement x="114" y="4" width="32" height="14"/>
				<text><![CDATA[SIZE]]></text>
			</staticText>
			<staticText>
				<reportElement x="219" y="4" width="41" height="14"/>
				<text><![CDATA[HSN]]></text>
			</staticText>
			<staticText>
				<reportElement x="272" y="4" width="25" height="14"/>
				<text><![CDATA[PLY]]></text>
			</staticText>
			<staticText>
				<reportElement x="492" y="0" width="57" height="20"/>
				<text><![CDATA[AMOUNT]]></text>
			</staticText>
			<staticText>
				<reportElement x="311" y="4" width="27" height="14"/>
				<text><![CDATA[BDLS]]></text>
			</staticText>
			<staticText>
				<reportElement x="347" y="4" width="32" height="20"/>
				<text><![CDATA[PCS]]></text>
			</staticText>
			<staticText>
				<reportElement x="449" y="2" width="31" height="16"/>
				<text><![CDATA[RATE]]></text>
			</staticText>
			<rectangle>
				<reportElement x="379" y="0" width="62" height="18"/>
			</rectangle>
			<rectangle>
				<reportElement x="379" y="18" width="62" height="124"/>
			</rectangle>
			<staticText>
				<reportElement x="397" y="4" width="32" height="14"/>
				<text><![CDATA[QTY]]></text>
			</staticText>
			<rectangle>
				<reportElement x="379" y="142" width="62" height="20"/>
			</rectangle>
			<rectangle>
				<reportElement x="341" y="142" width="38" height="20"/>
			</rectangle>
			<rectangle>
				<reportElement x="297" y="142" width="44" height="20"/>
			</rectangle>
			<rectangle>
				<reportElement x="0" y="142" width="297" height="20"/>
			</rectangle>
			<textField>
				<reportElement x="83" y="22" width="117" height="18">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b0fa8ace-0e5c-4417-9432-eec851d71dee"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{size}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="260" y="22" width="37" height="18">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="82956727-1b3f-44f5-8a4b-8569d08de109"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{ply}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="298" y="24" width="40" height="16">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a275e482-6d94-4c31-a84c-1b6d87fda603"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{bndl}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="441" y="22" width="39" height="18">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="85c9ffd0-0574-421f-8ee8-ba2ab900e756"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{rate}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="480" y="22" width="75" height="18">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0b07b46b-c295-4481-8890-ed7f2269ce08"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{amount}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="200" y="22" width="60" height="18">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="8acbd901-d703-4f13-a548-5a9488e6f4dc"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{hsn}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="22" width="83" height="18">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="967c40a0-0f96-429e-aabd-569572142fee"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{desc}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="379" y="142" width="62" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter26}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="298" y="141" width="43" height="19"/>
				<textFieldExpression><![CDATA[$P{Parameter27}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="1" y="141" width="127" height="19"/>
				<text><![CDATA[Eeletronic Reference No. :]]></text>
			</staticText>
			<textField>
				<reportElement x="130" y="142" width="167" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter28}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="341" y="24" width="37" height="16">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0e748255-2f68-488a-9126-5c6ace94d6c9"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{los_pcs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="379" y="24" width="42" height="16">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="25da6712-05fa-49ef-8efd-c8ec01e9f915"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{pcs}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="412" y="24" width="29" height="16">
					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="45fbb595-de52-403a-9c81-f580e86bc93f"/>
				</reportElement>
				<textFieldExpression><![CDATA[$F{qty}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<summary>
		<band height="192" splitType="Stretch">
			<rectangle>
				<reportElement x="1" y="117" width="554" height="73"/>
			</rectangle>
			<rectangle>
				<reportElement x="0" y="0" width="428" height="81"/>
			</rectangle>
			<rectangle>
				<reportElement x="428" y="0" width="127" height="81"/>
			</rectangle>
			<rectangle>
				<reportElement x="428" y="81" width="127" height="20"/>
			</rectangle>
			<rectangle>
				<reportElement x="0" y="81" width="428" height="20"/>
			</rectangle>
			<staticText>
				<reportElement x="430" y="85" width="62" height="16"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[GRAND TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement x="430" y="2" width="33" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement x="430" y="22" width="34" height="19"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[SGST]]></text>
			</staticText>
			<staticText>
				<reportElement x="430" y="41" width="33" height="16"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[CGST]]></text>
			</staticText>
			<staticText>
				<reportElement x="1" y="81" width="67" height="20"/>
				<text><![CDATA[Invoice Value :]]></text>
			</staticText>
			<staticText>
				<reportElement x="430" y="61" width="28" height="20"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[IGST]]></text>
			</staticText>
			<rectangle>
				<reportElement x="0" y="101" width="555" height="16"/>
			</rectangle>
			<staticText>
				<reportElement x="14" y="101" width="535" height="16"/>
				<textElement>
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[For RTGS/NEFT: HDFC BANK, MALERKOTLA	           	A/C No. :06498620000084     CODE: HDFC0000649]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="117" width="29" height="9"/>
				<textElement>
					<font size="6"/>
				</textElement>
				<text><![CDATA[TERMS:]]></text>
			</staticText>
			<staticText>
				<reportElement x="30" y="117" width="170" height="9"/>
				<textElement>
					<font size="6"/>
				</textElement>
				<text><![CDATA[1. Our responsibility ceases after the goods leave the godown.]]></text>
			</staticText>
			<staticText>
				<reportElement x="30" y="136" width="295" height="10"/>
				<textElement>
					<font size="6"/>
				</textElement>
				<text><![CDATA[3. The customers are reponsible for all the expenses incurred by the way of refused or dishonouring the bills.]]></text>
			</staticText>
			<staticText>
				<reportElement x="30" y="126" width="255" height="10"/>
				<textElement>
					<font size="6"/>
				</textElement>
				<text><![CDATA[2. All bills standing unpaid after 7 days from presentation interest @18% p.a. will be charged ]]></text>
			</staticText>
			<staticText>
				<reportElement x="449" y="165" width="76" height="12"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<text><![CDATA[Authorised Signatory]]></text>
			</staticText>
			<staticText>
				<reportElement x="27" y="158" width="284" height="19"/>
				<textElement>
					<font size="6"/>
				</textElement>
				<text><![CDATA[Certified that the particulars given above are true & correct and amount indicated represents the price actually charged and that there is no flow of additional considration directly or indirectly from the buyer.]]></text>
			</staticText>
			<staticText>
				<reportElement x="29" y="146" width="288" height="12"/>
				<textElement>
					<font size="6"/>
				</textElement>
				<text><![CDATA[4. Dispute if any shall be subject to Malerkotla Jusdiction only.]]></text>
			</staticText>
			<staticText>
				<reportElement x="416" y="117" width="139" height="19"/>
				<textElement>
					<font size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[For Jai Durga Kraft Paper Pvt. Ltd.,]]></text>
			</staticText>
			<staticText>
				<reportElement x="8" y="22" width="42" height="13"/>
				<text><![CDATA[GR No. :]]></text>
			</staticText>
			<staticText>
				<reportElement x="5" y="68" width="78" height="13"/>
				<text><![CDATA[Documantation :]]></text>
			</staticText>
			<staticText>
				<reportElement x="220" y="6" width="40" height="16"/>
				<text><![CDATA[Date :]]></text>
			</staticText>
			<staticText>
				<reportElement x="220" y="22" width="42" height="18"/>
				<text><![CDATA[Date :]]></text>
			</staticText>
			<staticText>
				<reportElement x="4" y="53" width="74" height="13"/>
				<text><![CDATA[Transport :]]></text>
			</staticText>
			<staticText>
				<reportElement x="8" y="6" width="73" height="16"/>
				<text><![CDATA[Order No.]]></text>
			</staticText>
			<staticText>
				<reportElement x="4" y="35" width="60" height="18"/>
				<text><![CDATA[Vehicle No. :]]></text>
			</staticText>
			<staticText>
				<reportElement x="220" y="40" width="40" height="17"/>
				<text><![CDATA[Fraight :]]></text>
			</staticText>
			<textField>
				<reportElement x="86" y="4" width="86" height="16"/>
				<textFieldExpression><![CDATA[$P{Parameter12}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="87" y="40" width="84" height="17"/>
				<textFieldExpression><![CDATA[$P{Parameter13}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="87" y="53" width="84" height="15"/>
				<textFieldExpression><![CDATA[$P{Parameter14}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="88" y="68" width="82" height="13"/>
				<textFieldExpression><![CDATA[$P{Parameter15}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="260" y="22" width="84" height="18"/>
				<textFieldExpression><![CDATA[$P{Parameter16}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="263" y="41" width="84" height="16"/>
				<textFieldExpression><![CDATA[$P{Parameter17}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="259" y="6" width="85" height="16"/>
				<textFieldExpression><![CDATA[$P{Parameter19}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="86" y="22" width="100" height="13"/>
				<textFieldExpression><![CDATA[$P{Parameter19}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="83" y="82" width="333" height="19"/>
				<textFieldExpression><![CDATA[$P{Parameter20}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="468" y="0" width="87" height="20"/>
				<textFieldExpression><![CDATA[$P{Parameter21}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="492" y="20" width="63" height="15"/>
				<textFieldExpression><![CDATA[$P{Parameter22}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="490" y="38" width="65" height="19"/>
				<textFieldExpression><![CDATA[$P{Parameter23}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="60" width="94" height="21"/>
				<textFieldExpression><![CDATA[$P{Parameter24}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="492" y="80" width="63" height="19"/>
				<textFieldExpression><![CDATA[$P{Parameter25}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="464" y="23" width="28" height="16"/>
				<textFieldExpression><![CDATA[$P{Parameter33}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="461" y="40" width="34" height="17"/>
				<textFieldExpression><![CDATA[$P{Parameter34}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package stock_sample;
import java.sql.*;
import java.lang.Math;
import java.io.*;
import java.text.DecimalFormat;
import java.util.*;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
 *
 * @author HP
 */


import net.sf.jasperreports.engine.JREmptyDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
import net.sf.jasperreports.view.JasperViewer;
public class Field {
        //private static String address1 = "C:\\Users\\HP\\Desktop\\invoice.jrxml";
        private static String address1 = "C:\\Users\\HP\\JaspersoftWorkspace\\MyReports\\invoiceff.jrxml";
	private String gst;
        String address = "C:\\Users\\HP\\Documents\\stocks_project_db\\";
	public  String billno;
	private String invoice_n,invoice_val,or_no,date_1,date_2,gr_no,vehicle,transport,fraight,total,sgst,igst,g_total;
	private String buyer_n1,buyer_n2,buyer_n3,state,gstin,code,pan,phone;
	private String t_bndl = "0";
	private String t_qty = "0";
        private static Connection con2 = null;
        
        public void getBill(String bb){
            billno = bb;
        }
	public Connection con(String add){
		Connection con = null;
		try{
			String connn = "jdbc:ucanaccess://" + address + add + ".accdb";
			con = DriverManager.getConnection(connn);
                        
		}catch(Exception e){
			System.out.println("Error in connection :" + e);
		}
		return con;
                
	}

	
	public ResultSet results(String sql){
		ResultSet resul = null;
		try{
			Statement st = con2.createStatement();
                        resul = st.executeQuery(sql);
		}catch(Exception e){
			System.out.println("Error in ResultSet :" + e);
		}
		return resul;
	}


	public Collection fdata() throws SQLException{
                String desc,size,hsn,ply,bndl,los_pcs,pcs,qty,rate,amount;
                String rate1 = "";
                ArrayList<fields> arr = new ArrayList<fields>();
		String sql1 = "SELECT * FROM product_inbill where bill_number = " + billno + ";";
                ResultSet rss = results(sql1);
		while(rss.next()){
			size = rss.getString("product_name");
			bndl = rss.getString("bundles");
			los_pcs = rss.getString("loose_pcs");
			rate1 = rss.getString("rateperpeice");
                        DecimalFormat df = new DecimalFormat("0.00");
                        rate =df.format(Double.parseDouble(rate1));
			//bndpcs = rss.getString("bunperpcs");
			pcs = rss.getString("net_qty");
			qty = rss.getString("qty");
			amount = String.valueOf(Math.round((Double.parseDouble(pcs))*(Double.parseDouble(rate))));
			t_bndl = String.valueOf((Integer.parseInt(t_bndl)+Integer.parseInt(bndl)));
			t_qty = String.valueOf((Integer.parseInt(t_qty)+Integer.parseInt(pcs)));
			String sql2 = "SELECT * FROM product_descriptions where product_type = '" + size + "';";
                        ResultSet rss1 = results(sql2);
                        while(rss1.next()){
				desc = rss1.getString("product_name");
				hsn = rss1.getString("code");
				ply = rss1.getString("ply");
				fields f = new fields(desc,size,hsn,ply,bndl,los_pcs,pcs,qty,rate,amount);
				arr.add(f);
			}
		}
		return arr;
	}


	public  void something(){
            try {
                
                JasperReport jp = JasperCompileManager.compileReport(address1);
                HashMap para = new HashMap();
                para.put("Parameter1","nabha paper mill");
                JRBeanCollectionDataSource jcd = new JRBeanCollectionDataSource(fdata());
                JasperPrint print  = JasperFillManager.fillReport(jp, para,jcd);
                JasperViewer.viewReport(print,false);
            } catch (Exception ex) {
                System.out.print("error in something :" + ex);
            }
	}
        
        public static void main(String [] args){
            Field fgh = new Field();
            fgh.getBill("33");
            try{
                con2 = fgh.con("BILLS");
            }catch(Exception e){
            System.out.print("Error in 124 : + e");
            }
            
            try {
                    fgh.fdata();
            } catch (SQLException ex) {
                System.out.print("Error in 131 :" + ex);
            }
            
            try{
                fgh.something();
            }catch(Exception ee){
                System.out.print("Error in 134" + ee);
            }
        }

    private static class fields {

        
        public String getDesc() {
            return desc;
        }

        
        public String getSize() {
            return size;
        }

        
        public String getHsn() {
            return hsn;
        }

        
        public String getPly() {
            return ply;
        }

        
        public String getBndls() {
            return bndl;
        }

        
        public String getLos_pcs() {
            return los_pcs;
        }

        
        public String getPcs() {
            return pcs;
        }

        
        public String getQty() {
            return qty;
        }

        
        public String getRate() {
            return rate;
        }

        
        public String getAmount() {
            return amount;
        }
        private String desc,size,hsn,ply,bndl,los_pcs,pcs,qty,rate,amount;
        public fields(String desc,String size,String hsn,String ply,String bndl,String los_pcs,String pcs,String qty,String rate,String amount) {
            this.desc = desc;
            this.ply = ply;
            this.bndl = bndl;
            this.size = size;
            this.los_pcs = los_pcs;
            this.pcs = pcs;
            this.rate = rate;
            this.hsn = hsn;
            this.qty = qty;
            this.amount = amount;
        }
    }

    
}

Posted 21-Apr-18 9:10am

Member 13766488

Updated 22-Apr-18 4:49am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

wseng · Answer 1 · 2018-04-22T04:50:00

Solution 1

Perhaps you miss setSize

public void setSize(String size) {
        this.size= size;
}

Posted 22-Apr-18 4:50am

wseng

Comments

Member 13766488 22-Apr-18 21:20pm

But i already set size in the constructor

wseng 22-Apr-18 21:27pm

can you give it a try ?