How to change Columns to Rows in a table in iReport

Question

I am not finding how to achieve the following with iReport Designer.

Suppose I create the following table:

Field1 Field2 .....Fieldn
-------------------------
Val1   Val2   .....Valn

how can I display a table like the following:

Field1 Val1
Field2 Val2
.
.
.
Fieldn Valn

You can try this solution: [dispay values in detail band as TRANSPOSE](http://community.jaspersoft.com/questions/524244/dispay-values-detail-band-transpose). Other links: [IReport Convert Rows to columns](http://community.jaspersoft.com/questions/537821/ireport-convert-rows-columns) — Alex K, Dec 06 '13 at 11:58

score 1 · Answer 1 · edited May 23 '17 at 10:32

1

If you are using MySQL as your dataset you can transpose the data in your query. How to transpose mysql table rows into columns

edited May 23 '17 at 10:32

Community

answered Dec 06 '13 at 18:22

expozed

1 Answers1