cheapwebhoster Posted December 4, 2015 Share Posted December 4, 2015 Hi,I am new to jaspersoft report designer and sorry if this question has been asked before anyway it seem i couldn't really find the exact and structured answer to my problem. So the question is in the jaspersoft ireport designer (web version) how can i create a table or crosstab to show data group by Quarterly. Relative to the date time of the system like picture belowIf possible also can we make it Daily, Weekly, Monthly, Semi, or Yearly. Your answers is much appreciated. Thank you in advance Link to comment Share on other sites More sharing options...
cheapwebhoster Posted December 4, 2015 Author Share Posted December 4, 2015 By the way when using this measures it won't workCreate measures: MonthName("Day Date") then use MonthName measure to create another measures Quarter 1 where IF(Contains("MonthName", 'January', 'February', 'March'), 'Quarter 1')This will work if but it only contains 1 value of the month not quarterly that i wantedIF(Contains("MonthName", 'January'), 'Quarter 1') Link to comment Share on other sites More sharing options...
cheapwebhoster Posted December 16, 2015 Author Share Posted December 16, 2015 solved by myself 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