efrain_santiago Posted March 10, 2015 Share Posted March 10, 2015 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? Link to comment Share on other sites More sharing options...
elizam Posted March 10, 2015 Share Posted March 10, 2015 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. Link to comment Share on other sites More sharing options...
efrain_santiago Posted March 10, 2015 Author Share Posted March 10, 2015 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? Link to comment Share on other sites More sharing options...
djohnson53 Posted March 10, 2015 Share Posted March 10, 2015 Does it possibly have to do with the data typing of the DATEFORMAT() function or its results? Link to comment Share on other sites More sharing options...
hozawa Posted March 10, 2015 Share Posted March 10, 2015 How does the graphs look when viewed on Jaspersoft Studio? Are they the same on Jaspersoft Studio 6.0 and 6.0.1? Link to comment Share on other sites More sharing options...
efrain_santiago Posted March 10, 2015 Author Share Posted March 10, 2015 The report runs fine in jasper studio 6 but the same problem happens in jasper studio 6.0.1 Link to comment Share on other sites More sharing options...
efrain_santiago Posted March 11, 2015 Author Share Posted March 11, 2015 The field type is java.sql.Timestamp, the same as in Jasper 6.0. Link to comment Share on other sites More sharing options...
efrain_santiago Posted March 11, 2015 Author Share Posted March 11, 2015 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! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now