mkeym

Hey, first of all, i would thank you, that i can create dynamical chart in TimeSeries. But now, i have other problems within TimeSeriesChart. I want to explain my problem. The Description field has several Descriptions. For example: A, B, C, D ... If the chart is generated, i got only A or B, sometimes all and sometimes only one. In database all description have values. And how can i compare ValueA and ValueB in valueExpression. I try ValueA+" "+ValueB but i think this is not correct. Thank you for help. Regards Code:<field name="DESCRIPTION" class="java.lang.String" /><field name="HALFHOUR" class="java.lang.String" /><field name="VALUEA" class="java.lang.Double" /><field name="VALUEB" class="java.lang.Double" />-------------------------<timeSeriesDataset timePeriod="Minute"> <timeSeries> <seriesExpression><![CDATA[$F{DESCRIPTION}]]></seriesExpression> <timePeriodExpression><![CDATA[(new java.text.SimpleDateFormat("dd.MM.yyyy HH:mm")).parse($F{HALFHOUR})]]></timePeriodExpression> <valueExpression><![CDATA[$F{VALUE_A}]]></valueExpression> </timeSeries> </timeSeriesDataset>

Thank you, thats it. I would never been on it.

Hello, ich try for a long time to generate a TimeSeriesChart in JasperReports. In iReport it works fine. But when i use the jrxml from iReport in JasperReports Environment i get tis error: java.lang.NoSuchMethodError: org.jfree.chart.ChartFactory.setChartTheme I found out on this page (http://blog.altosresearch.com/howto-integrate-jasperreports-chart-themes/) how to integrate the chart engine from iReport to JasperReports. But i have some problems do understand the invisible steps. Can somebody help me how to integrate chart theme to jasperreports. I have created a report file (*.jrxml) but how can i add the chart theme (*.jrctx) to the report file. Is this jrctx correct? Greats Code:My report file *.jrxml<?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="mycustomtheme" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <summary> <band height="305" splitType="Stretch"> <timeSeriesChart> <chart> <reportElement x="187" y="44" width="200" height="180"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <timeSeriesDataset/> <timeSeriesPlot> <plot/> <timeAxisFormat> <axisFormat> <labelFont/> <tickLabelFont/> </axisFormat> </timeAxisFormat> <valueAxisFormat> <axisFormat> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> </timeSeriesPlot> </timeSeriesChart> </band> </summary></jasperReport>My *.jrctx:<?xml version="1.0" encoding="UTF-8"?><chart-theme/>

When i use the same code in ireport the chart will create. Can somebody give me an example how to create an TimeSeriesChart in JasperReports Eclipse-Plugin? I think my java code is correct because with the same code but another jrxml file i can generate dynamical text reports. I hope somebody can help me. I need it urgently /tools/fckeditor/editor/images/smiley/msn/sad_smile.gif Post Edited by mkeym at 07/01/2010 12:18

Hey, i dont know where does the chart theme come from. I have never assigned it. The Classpath references to the jfreechart jar file. But i have no idea from where i get the chart theme. Can somebody help me?

Hey together, I have tried to generate TimeSeriesChart in JasperReports but i get this error: java.lang.NoSuchMethodError: org.jfree.chart.ChartFactory.setChartTheme(Lorg/jfree/chart/ChartTheme;)V Does somebody have a solution for my problem? Greats Code:<field name="DESCRIPTION" class="java.lang.String" /><field name="HALFHOUR" class="java.lang.String" /><field name="VALUEA" class="java.lang.Double" /><variable name="TIME" class="java.util.Date"><variableExpression><![CDATA[new Date()]]></variableExpression><initialValueExpression><![CDATA[new SimpleDateFormat("hh:mm").parse("06:00")]]></initialValueExpression></variable>----<timeSeriesChart> <chart evaluationTime="Report"> <reportElement x="0" y="0" width="555" height="350" /> </chart> <timeSeriesDataset timePeriod="Hour"> <timeSeries> <seriesExpression><![CDATA[$F{DESCRIPTION}]]></seriesExpression> <timePeriodExpression><![CDATA[$V{TIME}]]></timePeriodExpression> <valueExpression><![CDATA[$F{VALUEA}]]></valueExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot> <plot backcolor="#FFFFFF"/> </timeSeriesPlot></timeSeriesChart>

... Post Edited by mkeym at 06/26/2010 16:03

Code: Post Edited by mkeym at 06/26/2010 12:50

Thank you for help, but when i try this i get this message: Exception in thread "AWT-EventQueue-0" java.lang.NoSuchMethodError: org.jfree.chart.ChartFactory.setChartTheme(Lorg/jfree/chart/ChartTheme;)

Hey all, i get some problems when i try to create a xylinechart in jasperreports. Is it better if i create timeseries charts or xylinecharts. I want to explain my behaviour: I connect to a database from i build reports. at last i need to create charts for this dynamic reports. All reports depend on time, so i try to use x-axis as time axis and y-axis should be the value axis. The problem is that my time in database is as string so i cannot create these charts. can anybody help me how to realise these reports? Thanks Code:<field name="DESCRIPTION" class="java.lang.String" /><field name="HALFHOUR" class="java.lang.String" /><field name="VALUEA" class="java.lang.Double" />----<xyLineChart> <chart evaluationTime="Report"> <reportElement x="0" y="0" width="555" height="350" /> </chart> <xyDataset> <dataset incrementType="None" /> <xySeries> <seriesExpression><![CDATA[$F{DESCRIPTION}]]></seriesExpression> <xValueExpression><![CDATA[$F{HALFHOUR}]]></xValueExpression> <yValueExpression><![CDATA[$F{VALUEA}]]></yValueExpression> </xySeries> </xyDataset> <linePlot> <plot /> </linePlot> </xyLineChart>

Now, when i try to use the method intValue() i get a new error: The method intValue() is undefined for the type String I actually also try to create LineChart but it can't show time parameter in x-axis. The x-axis is without a descirption of Halfhour String. Here the chart seems to be ok but i want to create it with XYLineChart or maybe i use TimeSeries? If i use this template in eclipse i get over 60 errors. But first of all i need to create it in ireport.

Hey, i want to generate a xyline chart in ireport with existing database. I use for x-axis a field in string but i need to convert to number. When i use <field name="DESCRIPTION" class="java.lang.String" /> <field name="HALFHOUR" class="java.lang.String" /> <field name="VALUEA" class="java.lang.Double" /> ........ <xyLineChart> <chart> <reportElement x="126" y="32" width="311" height="253"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <xyDataset> <xySeries> <seriesExpression><![CDATA[$F{DESCRIPTION}]]></seriesExpression> <xValueExpression><![CDATA[new java.text.SimpleDateFormat("hh24:mi").format(new java.text.SimpleDateFormat("hh24:mi").parse($F{HALFHOUR}))]]></xValueExpression> <yValueExpression><![CDATA[$F{VALUEA}]]></yValueExpression> </xySeries> </xyDataset> <linePlot> <plot/> <categoryAxisFormat> <axisFormat> <labelFont/> <tickLabelFont/> </axisFormat> </categoryAxisFormat> <valueAxisFormat> <axisFormat> <labelFont/> <tickLabelFont/> </axisFormat> </valueAxisFormat> </linePlot> </xyLineChart> When i try to compile i get the message: Cannot cast from string to number. Can somebody help ply and can i use this template in Eclipse/JasperReports? Thanks and Regards