Maine

It seems that the error was a bit misleading. The server could not handle the date format "EEEEE dd MMMMM yyyy". Hence the error. When that format was changed there was no error message left. That was a completely different situation! Then the parameter "ignoreGraphics" of the file "WEB-INF/applicationContext.xml" on the server was checked and indeed...this was set to true. When changed to false the graphics finally appeared in Excel on the server as well as locally.

When I my report to Excel in iReport, all goes well and apart from my data I get a nice image of my chart. But as soon as I upload my report to Jasperserver and export my report to Excel I get this error saying "File error. Some number formats may have been lost". Even my print date will turn into some strange number. Can somebody please tell me what I am doing wrong?

Can you help me with this one please? I have a table on my report that has 2 groups. The query feeding this table is returning 8 records like this: money-type, volume1, volume2, rate1, volume3, volume4, rate2, percentage The first and relevant (for my Q) group should help me calculate the sum of volume1 of all the records of the same money-type (USD or EUR or...) so I created a group "val_grp" in the dataset that is feeding this table with the group expression $F{valsrt} This should be very simple. However the variable that should calculate the sum (defined with Calculation: Sum, Reset type: Group, Reset group: val_grp, Increment type: None, Variable expression: $F{volume1}) does NOT calculate anything. It just returns the latest value of volume1. I have previoulsy built this report not using a table and this same way of crouping and calculating worked just fine. In this version, using a table, though..........it WILL NOT WORK!! Does anybody have a brilliant idea for me?? This is my first time using a table in ireport. Does grouping in tables work differently? Thanks in advance.

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

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"

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

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>