Line Graphs rendering in Jasper 6 but not Jasper 6.0.1

Posted on March 10, 2015 at 10:32am

I have a Report that will render correctly in Jasper Server 6.0 but not in Jasper Server 6.0.1. This report was created in Jaspersoft Studio 6.0, however, I have tried re-building it in Jaspersoft studio 6.0.1 but the problem still occurs.

The report is a line graph, this graph is meant to represent a timeline of all requests created by a certain support group. The Category level is the date, configured so that it groups all requests by Month-Year. This is the function I use in that Category level DATEFORMAT($F{Ticket_Information.Create_Date},"MMM-YYYY"). This function is a Java function, it is not custom.

 

The Series section is working correctly.

The Measures section is a count of all requests by month.

 

Again, this report renders correctly in Jasper Reports 6.0 but NOT in Jasper 6.0.1, the Dateformat function is ignored and the graph only represents a grand total split by the Series.

 

I have added 2 screenshots to show you what I mean.

Screenshot 1, Correct Report(in Jasper 6.0)

Screenshot 2, Incorrect(Jasper 6.0.1)

This happens in any browser and mobile client.

I checked the versions of Java in both servers and it is the same.

Has anyone encountered an issue with Jasper 6.0.1 not recognizing certain detault Java functions?

JasperReports® Server
Jaspersoft® Studio
efrain_santiago's picture
efrain_santiago
51
Joined: Sep 12 2014 - 5:28am
Last seen: 4 years 4 months ago

Does it possibly have to do with the data typing of the DATEFORMAT() function or its results?

 

djohnson53 - 8 years 3 weeks ago

The field type is java.sql.Timestamp, the same as in Jasper 6.0. 

efrain_santiago - 8 years 2 weeks ago
add comment

5 Answers:

Posted on March 10, 2015 at 11:31am

One thing to look at is the date sliders in the input control area.  It looks like maybe they have collapsed from month to year.

elizam's picture
elizam
14014
Joined: Mar 5 2012 - 9:19am
Last seen: 2 years 7 months ago
Posted on March 10, 2015 at 11:51am

Hmm, this is not a report created via the Ad Hoc editor, the date input controls are controls I created. So there isnt a date slider in them. Can you elaborate a bit more to see if I am just misunderstanding your suggestion?

efrain_santiago's picture
efrain_santiago
51
Joined: Sep 12 2014 - 5:28am
Last seen: 4 years 4 months ago
Posted on March 10, 2015 at 2:37pm

How does the graphs look when viewed on Jaspersoft Studio? Are they the same on Jaspersoft Studio 6.0 and 6.0.1?

hozawa's picture
hozawa
171093
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 9 months ago
Posted on March 10, 2015 at 3:06pm
The report runs fine in jasper studio 6 but the same problem happens in jasper studio 6.0.1
efrain_santiago's picture
efrain_santiago
51
Joined: Sep 12 2014 - 5:28am
Last seen: 4 years 4 months ago
Posted on March 11, 2015 at 7:15am

Turns out I fixed my own problem. I didnt read my own documentation when I was setting up our production environment and I forgot to replace the applicationContext-el.xml file. Which takes care of our Date conversion functions. Once I replaced this file, the charts started working correctly. Thank you all for your help!

efrain_santiago's picture
efrain_santiago
51
Joined: Sep 12 2014 - 5:28am
Last seen: 4 years 4 months ago
Feedback
randomness