0

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

1

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:

2

Please help me with this issue.

Thanks in advance! :)

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
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
  • 3,240
  • 2
  • 24
  • 31