Line Graphs rendering in Jasper 6 but not Jasper 6.0.1

0

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?

efrain_santiago's picture
Joined: Sep 12 2014 - 5:28am
Last seen: 2 years 11 months ago

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

 

djohnson53 - 6 years 7 months ago

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

efrain_santiago - 6 years 7 months ago

5 Answers:

0

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
5899
Joined: Mar 5 2012 - 9:19am
Last seen: 1 year 2 months ago
0

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
Joined: Sep 12 2014 - 5:28am
Last seen: 2 years 11 months ago
0

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
74040
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 years 4 months ago
0
The report runs fine in jasper studio 6 but the same problem happens in jasper studio 6.0.1
efrain_santiago's picture
Joined: Sep 12 2014 - 5:28am
Last seen: 2 years 11 months ago
0

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
Joined: Sep 12 2014 - 5:28am
Last seen: 2 years 11 months ago
Feedback
randomness