Artan Telkiu
Artan Telkiu

Reputation: 33

How to change Columns to Rows in a table in iReport

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

Upvotes: 0

Views: 3305

Answers (1)

expozed
expozed

Reputation: 31

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

Upvotes: 1

Related Questions