Jump to content
We've recently updated our Privacy Statement, available here ×

chayan

Members
  • Posts

    2
  • Joined

  • Last visited

chayan's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Thanx fro reply me.. i am sending the PDF report as attachment..
  2. i am creating a Balance sheet Report. where i want the assets and liablities must be display side by side i done that. but unfortunately an unwanted box around these two subreport appears. i will be very thank full if any one solve this problem.my reports code are below.. ParentReports (Container) <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="BalanceSheet1" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="842" pageHeight="595" columnWidth="782" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <parameter name="dataSource_assets" isForPrompting="false" class="net.sf.jasperreports.engine.JRDataSource"/> <parameter name="dataSource_liablities" isForPrompting="false" class="net.sf.jasperreports.engine.JRDataSource"/> <parameter name="liablitiesTotalStr" isForPrompting="false" class="java.lang.String"/> <parameter name="assetTotalStr" isForPrompting="false" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="50" isSplitAllowed="true" > <staticText> <reportElement x="0" y="0" width="782" height="50" key="staticText-6"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="18" isUnderline="true"/> </textElement> <text><![CDATA[bALANCE SHEET]]></text> </staticText> </band> </title> <pageHeader> <band height="100" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="30" isSplitAllowed="true" > <staticText> <reportElement x="0" y="0" width="207" height="30" key="staticText-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement verticalAlignment="Middle"> <font pdfFontName="Helvetica-Bold" size="18" isBold="true"/> </textElement> <text><![CDATA[Liablities]]></text> </staticText> <staticText> <reportElement x="400" y="0" width="207" height="30" key="staticText-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font pdfFontName="Helvetica-Bold" size="18" isBold="true"/> </textElement> <text><![CDATA[Assets]]></text> </staticText> </band> </columnHeader> <detail> <band height="100" isSplitAllowed="true" > <subreport isUsingCache="true"> <reportElement x="0" y="0" width="391" height="100" forecolor="#FFFFFF" backcolor="#FFFFFF" key="subreport-1" positionType="Float"/> <dataSourceExpression><![CDATA[$P{dataSource_liablities}]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA["/root/Desktop/Report/liablities.jasper"]]></subreportExpression> </subreport> <subreport isUsingCache="true"> <reportElement x="391" y="0" width="391" height="100" key="subreport-2" positionType="Float"/> <dataSourceExpression><![CDATA[$P{dataSource_assets}]]></dataSourceExpression> <subreportExpression class="java.lang.String"><![CDATA["/root/Desktop/Report/assets.jasper"]]></subreportExpression> </subreport> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <lastPageFooter> <band height="50" isSplitAllowed="true" > <line direction="TopDown"> <reportElement x="82" y="19" width="70" height="0" key="line-1"/> <graphicElement stretchType="NoStretch"/> </line> </band> </lastPageFooter> <summary> <band height="29" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="220" y="0" width="163" height="29" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{liablitiesTotalStr}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="619" y="0" width="163" height="29" key="textField-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{assetTotalStr}]]></textFieldExpression> </textField> <staticText> <reportElement x="57" y="0" width="163" height="29" key="staticText-4"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-BoldOblique" size="12" isBold="true" isItalic="true"/> </textElement> <text><![CDATA[Total]]></text> </staticText> <staticText> <reportElement x="456" y="0" width="163" height="29" key="staticText-5"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font pdfFontName="Helvetica-BoldOblique" size="12" isBold="true" isItalic="true"/> </textElement> <text><![CDATA[Total]]></text> </staticText> </band> </summary> </jasperReport> Subreport 1(Liablities) <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="liablities" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="842" pageHeight="595" columnWidth="375" columnSpacing="0" leftMargin="28" rightMargin="439" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <field name="grup_code" class="java.lang.Integer"/> <field name="accm_group_name" class="java.lang.String"/> <field name="total_Value" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="18" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="60" height="18" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{grup_code}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="0" width="181" height="18" key="textField-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{accm_group_name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="241" y="0" width="116" height="18" key="textField-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{total_Value}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary> </jasperReport> Subreport 2 (Assets) <?xml version="1.0" encoding="UTF-8" ?> <!-- Created with iReport - A designer for JasperReports --> <!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="assets" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="842" pageHeight="595" columnWidth="375" columnSpacing="0" leftMargin="28" rightMargin="439" topMargin="20" bottomMargin="20" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> <property name="ireport.scriptlethandling" value="0" /> <property name="ireport.encoding" value="UTF-8" /> <import value="java.util.*" /> <import value="net.sf.jasperreports.engine.*" /> <import value="net.sf.jasperreports.engine.data.*" /> <field name="grup_code" class="java.lang.Integer"/> <field name="accm_group_name" class="java.lang.String"/> <field name="total_Value" class="java.lang.String"/> <background> <band height="0" isSplitAllowed="true" > </band> </background> <title> <band height="0" isSplitAllowed="true" > </band> </title> <pageHeader> <band height="0" isSplitAllowed="true" > </band> </pageHeader> <columnHeader> <band height="0" isSplitAllowed="true" > </band> </columnHeader> <detail> <band height="18" isSplitAllowed="true" > <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="0" y="0" width="60" height="18" key="textField-1"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Left"> <font/> </textElement> <textFieldExpression class="java.lang.Integer"><![CDATA[$F{grup_code}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="false" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="60" y="0" width="181" height="18" key="textField-2"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{accm_group_name}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" > <reportElement x="241" y="0" width="116" height="18" key="textField-3"/> <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/> <textElement textAlignment="Right" verticalAlignment="Top"> <font/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{total_Value}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="0" isSplitAllowed="true" > </band> </columnFooter> <pageFooter> <band height="0" isSplitAllowed="true" > </band> </pageFooter> <summary> <band height="0" isSplitAllowed="true" > </band> </summary> </jasperReport> i use following java code to feed the data.... /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package test; import agc.fa.logs.LogConfig; import fa.report.model.bo.intrf.IntrfReport; import java.util.HashMap; import java.util.List; import java.util.Map; import net.sf.jasperreports.engine.JRDataSource; import net.sf.jasperreports.engine.JREmptyDataSource; import net.sf.jasperreports.engine.JasperRunManager; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; /** * This class is used for testing perpose. * @author chayan */ public class Test extends LogConfig { public Test() { super("test.Test"); } public static void main(String str[]) { //Test ob=new Test(); try { ApplicationContext appCtx = new ClassPathXmlApplicationContext("fa/report/context/applicationContext.xml"); ApplicationContext lb = new ClassPathXmlApplicationContext("fa/report/context/contextLiablities.xml"); ApplicationContext ass = new ClassPathXmlApplicationContext("fa/report/context/contextAssets.xml"); ApplicationContext util = new ClassPathXmlApplicationContext("fa/report/context/utility.xml"); IntrfReport lb1 = (IntrfReport) lb.getBean("TranImplLiablities"); IntrfReport ass1 = (IntrfReport) ass.getBean("TranImplAsset"); //IntrfReport tb1=(IntrfReport) tbCtx1.getBean("TranImplLiabilitiesBalanceSheet"); /*List ls = tb.prepareReport("01-04-2008", "31-03-2009"); Iterator it = ((List) ls.get(2)).iterator(); while (it.hasNext()) { GroupDAO ob = (GroupDAO) it.next(); System.err.println(ob.getAccm_group_name()); System.err.println(ob.getTotal_Value()); } System.err.println((Map) ls.get(0) + "<--------------------------------" + "----------->" + (JRDataSource) ls.get(1));*/ List tb_lb=lb1.prepareReport("01-04-2008", "31-03-2009"); List tb_ass=ass1.prepareReport("01-04-2008", "31-03-2009"); Map lb_map=(Map)tb_lb.get(0); JRDataSource lb_dataSource=(JRDataSource)tb_lb.get(1); Map ass_map=(Map)tb_ass.get(0); JRDataSource ass_dataSource=(JRDataSource)tb_ass.get(1); Map param=new HashMap(); param.put("dataSource_assets", ass_dataSource); param.put("dataSource_liablities", lb_dataSource); param.put("liablitiesTotalStr",(String)lb_map.get("liablitiesTotalStr") ); param.put("assetTotalStr", (String)ass_map.get("assetTotalStr")); JasperRunManager.runReportToPdfFile("/root/Desktop/Report/BalanceSheet1.jasper", "/root/Desktop/BalanceSheet1.pdf", param, new JREmptyDataSource()); System.err.println("HELOOOOOOOOOOOOOOOOOO"); } catch (Exception ex) { System.err.println("The Error are " + ex); } } }
×
×
  • Create New...