Time series dataset

[hngfoto]

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.

[emistry]

Hi,

We had a basic look at the issue you were experiencing and found that we did not have enough information to recreate the problem. Not sure if the problem was due to variables or evaluation times. Please find attached our time series chart built against the sample foodmart db. Come back to us with more information.

Thanks

 

 

 

[hngfoto]

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>