0

I am trying to create a crosstab in webi reports that should look something like this:

Use link https://i.stack.imgur.com/0H5ej.png for the image

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:

Use link 2 for this image

Please help me with this issue.

Thanks in advance! :)

Chill Guy
  • 1
  • 6
  • Yu can use pivot table function there is an example https://stackoverflow.com/questions/15931607/convert-rows-to-columns-using-pivot-in-sql-server/15931734 – Adem Acehan Feb 01 '20 at 21:06
  • Thank you for your answer but Pivot takes fixed values and i have dynamic values. – Chill Guy Feb 04 '20 at 05:42

1 Answers1

0

What object represents the values of 'a' and 'b'? Let's say it is Person. Create a variable called MaxPerson defined as follows and use that in place of Person.

MaxPerson=Max([Person])

Does that work for you?

Isaac
  • 2,872
  • 2
  • 23
  • 29