finn.hoffmeister Posted September 21, 2015 Share Posted September 21, 2015 Hey. :-)My database contains a column "month" (with is the first letter of each month only) and the matching value.Since there are several letters like "J" for january, june and july or "M" for March and May with multiple values, I have the problem that Jaspersoft is summerizing them.Is there any way I can seperate them? Do I have to change the query?Thanks in advance! Link to comment Share on other sites More sharing options...
carlos2015 Posted September 21, 2015 Share Posted September 21, 2015 The big question is: How do you know when "J" is for January or June? Link to comment Share on other sites More sharing options...
finn.hoffmeister Posted September 22, 2015 Author Share Posted September 22, 2015 There are a lot of additional columns like one for the date (DD.MM.YYYY) and number of month. So I was already trying to do an "ORDER BY" query, but it would still sum up the J´s. 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