usstar99

Compiling to file... .crosstabtest.jasper -> C:Program FilesJasperSoftiReport-2.0.5classic.java Errors compiling .crosstabtest.jasper. net.sf.jasperreports.engine.JRException:ÂErrorsÂwereÂencounteredÂwhenÂcompilingÂreportÂexpressionsÂclassÂfile: 1.ÂCannotÂcastÂfromÂShortÂtoÂString ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.String)(((java.lang.Short)variable_yr_recd.getValue()));//$JR_EXPR_ID=0$ ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<----------------------------------------------------------------> 1Âerrors ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:591) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) Compilation running time: 218. [file name=crosstabtest.jrxml size=9670]

Any clue how to resolve below error ????? ErrorÂfillingÂprint...ÂErrorÂincrementingÂcrosstabÂdataset net.sf.jasperreports.engine.JRRuntimeException:ÂErrorÂincrementingÂcrosstabÂdataset ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:665) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:682) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:895) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:798) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:947) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) CausedÂby:Ânet.sf.jasperreports.engine.JRException:ÂCrosstabÂdataÂhasÂalreadyÂbeenÂprocessed. ÂÂÂÂatÂnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:296) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:661) ÂÂÂÂ...Â12Âmore Print was not filled. Try using an EmptyDataSource...

Hi today is my fisrt day with Jasper Report, can you help me to create CrossTab report ?

Any one has any experience with JasperReports 2.0.4 / iReport 0.9.1 with Sybase EAServer 4.2.2 I am developing crosstab reports in iReport 0.9.1 (JasperReports 2.0.4) and I want to deploy them on EAServer 4.2.2. Any clue? Any know issue? JasperReports Details: JasperReports 2.0.4 Product Version: iReport 0.9.1 Java: 1.5.0_06; Java HotSpot Client VM 1.5.0_06-b05 System: Windows XP version 5.1 running on x86; Cp1252; en_US (ireport)

I am using iReport 0.9.1 1. What minimum version of Jboss is required 2. What minimum version of JDK is required? 3. Can I deploy iReport 0.9.1 on Sybase EAServer 4.2.2 ? JasperReports 2.0.4 Product Version: iReport 0.9.1 Java: 1.5.0_06; Java HotSpot Client VM 1.5.0_06-b05 System: Windows XP version 5.1 running on x86; Cp1252; en_US (ireport)

Please see my XML code is <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD JasperReport//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <style name="Crosstab Data Text" isDefault="false" hAlign="Center"/> <queryString> <![CDATA[ SELECT "sales_order"."cust_id", "sales_order"."region", "sales_order_items"."quantity" FROM "sales_order", "sales_order_items" WHERE ( "sales_order_items"."id" = "sales_order"."id" ) ]]> </queryString> <field name="cust_id" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="region" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="quantity" class="java.lang.Integer"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band/> </background> <title> <band> <crosstab> <reportElement x="0" y="15" width="555" height="400"/> <rowGroup name="cust_id" width="70" totalPosition="End"> <bucket> <bucketExpression class="java.lang.Integer"><![CDATA[$F{cust_id}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents backcolor="#F0F8FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="70" height="25"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{cust_id}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement x="0" y="0" width="70" height="25"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Total cust_id]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="region" height="30" totalPosition="End"> <bucket> <bucketExpression class="java.lang.String"><![CDATA[$F{region}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents backcolor="#F0F8FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="30"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$V{region}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement x="0" y="0" width="50" height="30"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[Total region]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="quantityMeasure" class="java.lang.Integer" calculation="Count"> <measureExpression><![CDATA[$F{quantity}]]></measureExpression> </measure> <crosstabCell width="50" height="25"> <cellContents> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{quantityMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell height="25" rowTotalGroup="cust_id"> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{quantityMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="50" columnTotalGroup="region"> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{quantityMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell rowTotalGroup="cust_id" columnTotalGroup="region"> <cellContents backcolor="#BFE1FF" mode="Opaque"> <box> <pen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/> <textElement/> <textFieldExpression class="java.lang.Integer"><![CDATA[$V{quantityMeasure}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> </crosstab> </band> </title> <pageHeader> <band/> </pageHeader> <columnHeader> <band/> </columnHeader> <detail> <band height="400"/> </detail> <columnFooter> <band height="15"/> </columnFooter> <pageFooter> <band/> </pageFooter> <summary> <band/> </summary> </jasperReport>

I know it’s only warning only but I am not able to see preview. So I want to see it’s preview Any help …

I am using Jasperreport 2.0.4 Product Version: iReport 0.9.1 Java: 1.5.0_06; Java HotSpot Client VM 1.5.0_06-b05 System: Windows XP version 5.1 running on x86; Cp1252; en_US (ireport)

i am getting below error , please tell me what to do ? ÂCompiling to file... C:NYSItest reportreport1.jasper net.sf.jasperreports.engine.design.JRValidationFault@4983d8ÂWarningÂ:ÂElementÂbottomÂreachesÂoutsideÂbandÂareaÂ:Ây=4Âheight=80Âband-height=79 Line:Â28,ÂColumn:Â14ÂJRXMLÂElement:Â/jasperReport/title[1]/band[1]/crosstab[1] net.sf.jasperreports.engine.design.JRValidationException:ÂReportÂdesignÂnotÂvalidÂ:Â ÂÂÂÂÂ1.ÂWarningÂ:ÂElementÂbottomÂreachesÂoutsideÂbandÂareaÂ:Ây=4Âheight=80Âband-height=79 ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:260) ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144) ÂÂÂÂatÂcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:510) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Compilation running time: 109

Hi all, New to jasper report, planning to create cross tab report, can any one tell me how I can do that ? Do we have any tutorial by which I can learn it step by step? I already checked in documentation but there no much detail available. Thanks, Jenny