kp402 Posted April 16 Share Posted April 16 I created a table object which includes timestamps (hours of the day) and values from 4 datapoints. I am using group functions and "Blank when NULL" but the result is not nice, it looks like: Timestamp Datapoint1 Datapoint2 Datapoint3 Datapoint4 ----------------|----------------|----------------|----------------|----------------- 01:00 1,23 01:00 1,23 3,45 01:00 1,23 2,34 3,45 01:00 0,12 1,23 2,34 3,45 02:00 11,23 01:00 11,23 13,45 01:00 11,23 12,34 13,45 01:00 10,12 11,23 12,34 13,45 02:00 .... but it should look like that: Timestamp Datapoint1 Datapoint2 Datapoint3 Datapoint4 ----------------|----------------|----------------|----------------|----------------- 01:00 0,12 1,23 2,34 3,45 01:00 10,12 11,23 12,34 13,45 02:00 .... How can I reduce the query result to one line per timestamp? Source Code is attached Test_1hour.jrxml Link to comment Share on other sites More sharing options...
shreekrishna.shankhwar Posted Sunday at 05:19 AM Share Posted Sunday at 05:19 AM Try to create with Cross tab that should work. 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