Jump to content
Changes to the Jaspersoft community edition download ×

Crosstab or not for transpose data?


mwk

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...