Skip to Content
Jan 30, 2020 at 06:33 PM

Duplicate values being created for same column value in a crosstab

67 Views Last edit Jan 30, 2020 at 10:47 AM 2 rev


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! :)


capture.png (1.4 kB)
capture.png (1.9 kB)