Crosstab or not for transpose data?

[mwk]

How can I do to represent a relational table vertically in my report? I want to transpose it.

 

I've the following data to represent :

 

+----+-------+-------+------+

|id |right1 |right2 |right3|

+----+-------+-------+------+

id1 r1 r2 r3

id2 r4 r5 r6

id3 r7 r8 r9

... .. .. ..

 

And I want it to be represented like that in my report :

 

| id1 | id2 | id3 | ... | ... |

-------------------------------------------

right1 | r1 | r4 | r7 | ... | ... |

right2 | r2 | r5 | r8 | ... | ... |

right3 | r3 | r6 | r9 | ... | ... |

-------------------------------------------

 

page 1/2

 

| id9 | id10| id11| etc | ... |

-------------------------------------------

right1 | r12 | r4 | r7 | ... | ... |

right2 | r2 | r51 | r8 | ... | ... |

right3 | r2 | r6 | r9 | ... | ... |

-------------------------------------------

 

page 2/2

etc.