oracle_itself

Dear all i am a beginner in jasper report, please help me to answer below questions please i need to know clear steps to 1- how to make a summery to have sum for a column exist in my report ? 2- what is the difference between creating sub dataset & subreport and when i need to use both of them ? 3- Last Question, what is the benefit of Table component exist in the pallet and when i have to use it .. thanks Post Edited by oracle_itself at 04/15/2012 19:40

Dear all i am a beginner in jasper report, please help me to answer below questions please i need to know clear steps to 1- how to make a summery to have sum for a column exist in my report ? 2- what is the difference between creating sub dataset & subreport and when i need to use both of them ? 3- Last Question, what is the benefit of Table component exist in the pallet and when i have to use it .. thanks Post Edited by oracle_itself at 04/15/2012 19:37

Dear all i am getting this error while i am trying running report from my app "XML-20149: (Error) Element 'jasperReport' used but not declared" full script <?xml version="1.0" encoding="UTF-8"?> <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="report1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <queryString language="SQL"> <![CDATA[select * from books]]> </queryString> <field name="BOOK_ID" class="java.math.BigDecimal"/> <field name="TITLE" class="java.lang.String"/> <group name="BOOK_ID"> <groupExpression><![CDATA[$F{BOOK_ID}]]></groupExpression> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"/> </columnHeader> <detail> <band height="125" splitType="Stretch"/> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>

Dear all i am using Oracle JDeveloper, IReport 3.7.4 & JasperReports-3.7.4.jar and i tried to change to old releases and i did every thing to call Jasper Report and i am getting this error net.sf.jasperreports.engine.JRException: Error at line 8 char 8: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox and my report xml script is <?xml version="1.0" encoding="UTF-8"?> <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="test2" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Table Dataset 1"/> <queryString> <![CDATA[sELECT books."BOOK_ID" AS books_BOOK_ID, books."TITLE" AS books_TITLE, books."PUB_DTG" AS books_PUB_DTG FROM books]]> </queryString> <field name="BOOKS_BOOK_ID" class="java.math.BigDecimal"/> <field name="BOOKS_TITLE" class="java.lang.String"/> <field name="BOOKS_PUB_DTG" class="java.sql.Timestamp"/> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"> <frame> <reportElement x="0" y="0" width="555" height="79"/> <staticText> <reportElement x="220" y="25" width="100" height="20"/> <textElement/> <text><![CDATA[Welcome]]></text> </staticText> </frame> </band> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="100" height="20"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{BOOKS_BOOK_ID}]]></textFieldExpression> </textField> </band> </columnHeader> <detail> <band height="125" splitType="Stretch"/> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport> can any one help me ?