[Time series dataset]

Hi,

Please find here a copy timeSeriesPlot.

When I run the report, I have one plot with one seriesExpression then another plot with two seriesExpression... aother one with three seriesExpression.

It is only the last plot which has all the seriesExpression. I would like to print only the last plot.

Thanks for your answer.

<?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="test" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1f7a53a6-ec83-4b9d-baf7-a3bf2e4842af">
 <property name="ireport.zoom" value="1.0"/>
 <property name="ireport.x" value="0"/>
 <property name="ireport.y" value="0"/>
 <queryString>
  <![CDATA[select
 round(extract(second from (max(stoptime)-min(starttime)))/60+
 extract(minute from (max(stoptime)-min(starttime)))+
 extract(hour from (max(stoptime)-min(starttime)))*60+
 extract(day from (max(stoptime)-min(starttime)))*60*24,1)
  DURATION,
 nuitbatch DAY_STRING,
 to_date(nuitbatch, 'yyyy-mm-dd') DAY_DATE,
 trunc(sysdate)-to_date(nuitbatch, 'yyyy-mm-dd') as DAY_BEFORE,
 application
from (
 select
  to_char(starttime-0.5, 'yyyy-mm-dd') AS nuitbatch,
  application,
  job,
  resultat,
  starttime,
  stoptime
 from my_table
 where resultat=0 and stoptime> sysdate-14)
group by application, nuitbatch]]>
 </queryString>
 <field name="DURATION" class="java.math.BigDecimal"/>
 <field name="DAY_STRING" class="java.lang.String"/>
 <field name="DAY_DATE" class="java.sql.Timestamp"/>
 <field name="DAY_BEFORE" class="java.math.BigDecimal"/>
 <field name="APPLICATION" class="java.lang.String"/>
 <background>
  <band splitType="Stretch"/>
 </background>
 <title>
  <band height="21" splitType="Stretch"/>
 </title>
 <detail>
  <band height="287">
   <timeSeriesChart>
    <chart>
     <reportElement uuid="101731c3-d247-4bdf-87ff-2b1a5eae9eb0" x="0" y="0" width="555" height="287"/>
     <chartTitle/>
     <chartSubtitle/>
     <chartLegend/>
    </chart>
    <timeSeriesDataset>
     <dataset incrementType="Report"/>
     <timeSeries>
      <seriesExpression><![CDATA[$F{APPLICATION}.toString()]]></seriesExpression>
      <timePeriodExpression><![CDATA[$F{DAY_DATE}]]></timePeriodExpression>
      <valueExpression><![CDATA[$F{DURATION}]]></valueExpression>
      <labelExpression><![CDATA[$F{APPLICATION}.toString()]]></labelExpression>
     </timeSeries>
    </timeSeriesDataset>
    <timeSeriesPlot>
     <plot/>
    </timeSeriesPlot>
   </timeSeriesChart>
  </band>
 </detail>
</jasperReport>

[Time series dataset]

Hi all,

I have a report with chart data (Time series dataset).

When i run the report, I have many curves but it is only the last one which has all the details.

Each new curve is analysing a different serie. The last curve has all the series.
How can I say to JasperReport to print only the last curve ?

Thanks.