plot timeSeriex chart with multipleDataSet OR pass a Collection Object in JRBeanCollectionDataSource

0
Acually I have to plot timeSeries using jasperReport . How to generate the time series graph for different data sets? I am able to generate the time series graph when i have one data set to plot over a period of time. However when i have multiple data set to plot then i am facing problem.
 
I am using List data source.
 
    public class KpiReportPoints {
        private String deviceDn;
        private List<KpiReportPoint> kpiPoints;
    }
    
    public class KPiReportPoint{
        private Date time;
        private Double value;
    
    public Date getTime() {
          
          return time;
       }
    
       
       /**
        * @param time the time to set
        */
       public void setTime(Date time) {
          this.time = time;
       }
    
       
       /**
        * @return the value
        */
       public Double getValue() {
          return value;
       }
    
       
       /**
        * @param value the value to set
        */
       public void setValue(Double value) {
          this.value = value;
       }
    
       @Override
       public int hashCode() {
          return time.hashCode();
       }
    
       @Override
       public boolean equals(Object obj) {
          boolean equal = false;
          if (obj instanceof KPIReportPoint){
             KPIReportPoint point  = (KPIReportPoint) obj;
             equal = time.equals(point.getTime())&& value.equals(point.getValue());
          }
          return equal;
       }
       
       @Override
       public int compareTo(KPIReportPoint o) {
          return this.time.compareTo(o.getTime());
       }
    
    }
 
Both the above classes have their getters and setters and all are public ,so no problem according to me is there in the definition of each. I am passing the populated List<KpiReportPoints> as JRBEanCollectionDataSource(kpiReportpointsList)
 
Now below is my 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="KPI_Reports" 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="191"/>
    <subDataset name="Dataset">
    <field name="time" class="java.util.Date"/>
    <field name="value" class="java.lang.Double"/>
    </subDataset>
    <parameter name="X_UNIT" class="java.lang.String">
    <parameterDescription><![CDATA[]]></parameterDescription>
    <defaultValueExpression><![CDATA["Date"]]></defaultValueExpression>
    </parameter>
    <parameter name="Y_UNIT" class="java.lang.String">
    <parameterDescription><![CDATA[]]></parameterDescription>
    <defaultValueExpression><![CDATA["%"]]></defaultValueExpression>
    </parameter>
    <parameter name="REPORT_NAME" class="java.lang.String">
    <defaultValueExpression><![CDATA["KPI Report"]]></defaultValueExpression>
    </parameter>
    <parameter name="from" class="java.util.Date"/>
    <parameter name="to" class="java.util.Date"/>
    <field name="deviceDn" class="java.lang.String"/>
    <field name="kpiPoints" class="java.util.List"/>
    <background>
    <band splitType="Stretch"/>
    </background>
    <title>
    <band height="20" splitType="Stretch">
    <textField pattern="EEE, d MMM yyyy HH:mm:ss Z" isBlankWhenNull="true">
    <reportElement x="513" y="0" width="253" height="20"/>
    <textElement/>
    <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
    </textField>
    </band>
    </title>
    <summary>
    <band height="443">
    <timeSeriesChart>
    <chart isShowLegend="true" customizerClass="com.ipaccess.nos.business.pm.impl.KPIChartCustomizer">
    <reportElement mode="Opaque" x="0" y="0" width="766" height="443" isPrintInFirstWholeBand="true"/>
    <chartTitle position="Top">
    <font size="14" isBold="true" pdfFontName="Courier-Bold" isPdfEmbedded="true"/>
    <titleExpression><![CDATA[$P{REPORT_NAME}]]></titleExpression>
    </chartTitle>
    <chartSubtitle/>
    <chartLegend position="Bottom"/>
    </chart>
    <timeSeriesDataset timePeriod="Second">
                        <datasetRun subDataset="Dataset">
                            <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{kpiPoints})]]></dataSourceExpression>
                        </datasetRun>
    <timeSeries>
    <seriesExpression><![CDATA[$F{deviceDn}]]></seriesExpression>
    <timePeriodExpression><![CDATA[$F{time}]]></timePeriodExpression>
    <valueExpression><![CDATA[$F{value}]]></valueExpression>
    </timeSeries>
    </timeSeriesDataset>
    <timeSeriesPlot isShowLines="true" isShowShapes="true">
    <plot labelRotation="90.0"/>
    <timeAxisLabelExpression><![CDATA[$P{X_UNIT}]]></timeAxisLabelExpression>
    <valueAxisLabelExpression><![CDATA[$P{Y_UNIT}]]></valueAxisLabelExpression>
    <valueAxisFormat>
    <axisFormat>
    <labelFont>
    <font size="10"/>
    </labelFont>
    </axisFormat>
    </valueAxisFormat>
    <domainAxisMinValueExpression><![CDATA[$P{from}]]></domainAxisMinValueExpression>
    <domainAxisMaxValueExpression><![CDATA[$P{to}]]></domainAxisMaxValueExpression>
    </timeSeriesPlot>
    </timeSeriesChart>
    </band>
    </summary>
    </jasperReport>
 
This issue is jrxml compiles fine but on trying to generate a report it throws the exception :
 
    [#|2014-10-10T09:59:05.769+0530|SEVERE|glassfish3.1.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=290;_ThreadName=Thread-3;|net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : time
            at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:127)
            at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:100)
            at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:104)
        at net.sf.jasperreports.engine.fill.JRFillData
 
I have been completely mad with this issue and not able to find even a single problem in the above code which may cause this . If any of you is able to see that and have any time faced this error then please give me some clue as to what is wrong . Thanks a lot in advance 
ruchiagraw's picture
Joined: Oct 8 2014 - 12:53am
Last seen: 5 years 3 months ago

0 Answers:

No answers yet
Feedback
randomness