Time Series Chart displays a chart per row returned instead of ONE chart

[Maine]

PLEASE help! I've been struggling with this problem now for 5 hours! 

I have a query that returns x change rates on x days between 2 date parameters $P{datum1} and $P{datum2}.

Let's say that $P{datum1} = 01-Jul-2014 and $P{datum2} = 05-Jul-2014. Then I will get 5 charts: all containing only one dot and the X-axis going from 23:59 till 00:00

What I want ismy X-axis to show the date period between 01-Jul-2014 and 05-Jul-2014 and the dots all connected by a fluent graph.

Can someone please help?? :(

The relevant part (I guess) of my XML looks like this:

<timeSeriesChart>

<chart renderType="image">

<reportElement isPrintRepeatedValues="false" x="173" y="0" width="391" height="212"/>

<chartTitle/>

<chartSubtitle/>

<chartLegend position="Bottom"/>

</chart>

<timeSeriesDataset timePeriod="Week">

<dataset resetType="None"/>

<timeSeries>

<seriesExpression><![CDATA[$F{datum}]]></seriesExpression>

<timePeriodExpression><![CDATA[$F{datum}]]></timePeriodExpression>

<valueExpression><![CDATA[$F{rate}]]></valueExpression>

<labelExpression><![CDATA["test"]]></labelExpression>

</timeSeries>

</timeSeriesDataset>

<timeSeriesPlot isShowShapes="true">

<plot/>

<timeAxisFormat>

<axisFormat>

<labelFont/>

<tickLabelFont/>

</axisFormat>

</timeAxisFormat>

<valueAxisFormat>

<axisFormat>

<labelFont/>

<tickLabelFont/>

</axisFormat>

</valueAxisFormat>

</timeSeriesPlot>

</timeSeriesChart>

 

 

[rajesh.sirsikar]

Hi Maine,

 

As per your description, I created the scenario for my testing and got it confirmed that the problem for your issue is that you have placed your Chart in the Detail section of the report.

 

Charts Must be kept either in the Title Bar or in the Summary Bar. In your case place it in teh Summary Bar and you will see the issue getting resolved in seconds.

 

Thanks,

Rajesh S

[Maine]

Dear Rajesh,

Thank you very much for your reply.

It solved just a part of my problem. Now , indeed, I only have one graph. But now I only have a graph with one dot on it.

Maine

[rajesh.sirsikar]

Hi maine,

 

If you are checking the chart for the data between 01 Jul 2014 to 05 Jul 2014 (As mentioned in your example), then using " will fetch you record for only one week and hence one dot. I am just thinking aloud here. Try Changing to then you shd get 5 Dots for 5 days data.

[Maine]

Thanks again for your help Rajesh, but that was not the problem. What did help was using another kind of chart. "Line chart" instead of "Time Series"

[Maine]

What did help was using another kind of chart. "Line chart" instead of "Time Series"