I am trying to create a crosstab that looks something like this:
That is there is a person 'a' occupying a room 'Room1' for a certain date 01/01/2020 and also a person 'b' occupying 'Room2' for the same date. Have a oracle table from where i am fetching the data into the report.
But instead of that it is being displayed as:
Please help me with this issue.
Thanks in advance! :)