joksy82

Is nice to know that none are able to help me. So exist a payement forum??

Dear All, I'm new to jasper and it own related technologies. I loose a day to try to build a time series which match some requirement but without luck!! The goal is to build a report sales chart depending of the payementtype Es VISA MasterCard and so on. I group all the payement type for having a chart for each one, but i have no idea how to specified different series for different chart. I post the code and the pdf produced. and i hope which someone are able to help me!! Many many thanks Kindly regards! Joksy Code:<?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="sales" language="java" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" 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"/> <queryString> <![CDATA[sELECT o.creationdate, count(mo.quantita) as quantita ,sum(o.totalepagamento) as soldi,met.nome as pagamento FROM modello_ordine mo inner join ordine o on o.idordine=mo.idordine inner join payementtype met on o.idmetodopagamento=met.payementtype group by o.creationdate order by pagamento]]> </queryString> <field name="creationdate" class="java.sql.Timestamp"/> <field name="quantita" class="java.lang.Long"/> <field name="soldi" class="java.lang.Double"/> <field name="pagamento" class="java.lang.String"/> <group name="pagamenti"> <groupExpression><![CDATA[$F{pagamento}]]></groupExpression> <groupHeader> <band height="521"> <textField> <reportElement x="0" y="0" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{pagamento}]]></textFieldExpression> </textField> <timeSeriesChart> <chart> <reportElement x="0" y="20" width="802" height="487"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <timeSeriesDataset> <timeSeries> <seriesExpression><![CDATA[$F{pagamento}]]></seriesExpression> <timePeriodExpression><![CDATA[$F{creationdate}]]></timePeriodExpression> <valueExpression><![CDATA[$F{quantita}]]></valueExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot isShowLines="true" isShowShapes="false"> <plot/> <timeAxisFormat> <axisFormat verticalTickLabels="true"> <labelFont/> <tickLabelFont/> </axisFormat> </timeAxisFormat> <valueAxisFormat> <axisFormat verticalTickLabels="false"> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> </timeSeriesPlot> </timeSeriesChart> </band> </groupHeader> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="14" splitType="Stretch"/> </title> <summary> <band height="162" splitType="Stretch"/> </summary></jasperReport>

Hi guys, I need to bulild a time series chart and i look for a documentation?? The question is exist a good one?? Since the book is pretty much useless for this task.

Dear All, I'm new to ireport and jasper but i'm really frustating becuase for doing simple thing i have spend many time for nothing. Each modification produce complete different results and really i have no IDEA. If a build only word report the thinngs are almost ok. But Chart are really human demotivational. In fact i start to learn jfreechart for makining and importing as image...... But anyway before leaving forever my problem and use another way to achieve what the customer want i have a question for all of you and please try to help me becuase probably it is my error and i didn t see it. The goal is to build a report which report sales chart depending of the payementtype Es VISA MasterCard and so on. I post the code and the pdf produced. Many many thanks Kindly regards! Joksy Code:<?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="sales" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" 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"/> <queryString> <![CDATA[sELECT o.creationdate, count(mo.quantita) as quantita ,sum(o.totalepagamento) as soldi,met.nome as pagamento FROM modello_ordine mo inner join ordine o on o.idordine=mo.idordine inner join payementtype met on o.idmetodopagamento=met.payementtype group by o.creationdate order by pagamento]]> </queryString> <field name="creationdate" class="java.sql.Timestamp"/> <field name="quantita" class="java.lang.Long"/> <field name="soldi" class="java.lang.Double"/> <field name="pagamento" class="java.lang.String"/> <group name="pagamenti"> <groupExpression><![CDATA[$F{pagamento}]]></groupExpression> <groupHeader> <band height="521"> <textField> <reportElement x="0" y="0" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{pagamento}]]></textFieldExpression> </textField> <timeSeriesChart> <chart> <reportElement x="0" y="20" width="802" height="487"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <timeSeriesDataset> <timeSeries> <seriesExpression><![CDATA[$F{pagamento}]]></seriesExpression> <timePeriodExpression><![CDATA[$F{creationdate}]]></timePeriodExpression> <valueExpression><![CDATA[$F{quantita}]]></valueExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot isShowLines="true" isShowShapes="false"> <plot/> <timeAxisFormat> <axisFormat verticalTickLabels="true"> <labelFont/> <tickLabelFont/> </axisFormat> </timeAxisFormat> <valueAxisFormat> <axisFormat verticalTickLabels="false"> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> </timeSeriesPlot> </timeSeriesChart> </band> </groupHeader> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="14" splitType="Stretch"/> </title> <summary> <band height="162" splitType="Stretch"/> </summary></jasperReport>

Ok the problem related to the repetition it was disappear moving to the summary the rendering of the chart

Dear All, Im new to the world of Ireport jasper and so on. I want to creare a very simple chart from a query which return three column. 1) a date 2) a name of a product 3) the selling amount for the product in the date. Ok the problem are. 1) If i do not set resetType and incrementType to report in the x axis the time is from 00:01 to 23:59 and so the chart show a point. :( 2) if i set resetType and incrementType to report the chart would be more interesting but is repeated througth the pdf for 103 times. (which are the total number of line retrived from the db used the query .... ) Exist an example of how to build a chart like this ?? And it is documented why it produce so many chart???? THANKS A LOT FOR ANY KIND OF HELP!!! Below i will provide to you the xml and what is produced?? Code:<?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="report3" 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"/> <queryString> <![CDATA[sELECT o.orderdate, mo.name ,sum(mo.tot)as total FROM order_item mo inner join order o on o.idorder=mo.idorder where o.orderdate > '2010-01-01' and o.orderdate < '2010-02-10' group by o.orderdate, mo.name order by o.orderdate]]> </queryString> <field name="orderdate" class="java.util.Date"/> <field name="name" class="java.lang.String"/> <field name="total" class="java.math.BigDecimal"/> <background> <band splitType="Stretch"/> </background> <title> <band height="27" splitType="Stretch"/> </title> <pageHeader> <band height="18" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="15" splitType="Stretch"/> </columnHeader> <detail> <band height="301" splitType="Stretch"> <timeSeriesChart> <chart> <reportElement x="24" y="25" width="503" height="244"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <timeSeriesDataset> <dataset resetType="Report" incrementType="Report"> <incrementWhenExpression><![CDATA[$F{name}.equals( "DVD" )]]></incrementWhenExpression> </dataset> <timeSeries> <seriesExpression><![CDATA[$F{name}.toString()]]></seriesExpression> <timePeriodExpression><![CDATA[$F{orderdate})]]></timePeriodExpression> <valueExpression><![CDATA[$F{total}]]></valueExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot/> <timeAxisFormat> <axisFormat> <labelFont/> <tickLabelFont/> </axisFormat> </timeAxisFormat> <valueAxisFormat> <axisFormat> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> </timeSeriesPlot> </timeSeriesChart> </band> </detail> <columnFooter> <band height="94" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="75" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary></jasperReport>