show data in horizontal

[kclow93]

Hello, I had use databand with Cross-Header, Cross-Data and Cross-Footer to create the horizontal table and the result is not what I want...

now
Data1 Data2 Data3
Data4 Data7 Data10
Data5 Data8 Data11
Data6 Data9 Data12

What I want is
.......|Data A | Data B | Data C
Data1 Data4 Data5 Data6
Data2 Data7 Data8 Data9
Data3 Data10 Data11 Data12

It's possible to make it ? I am using mysql and my database is

Column 1|Column 2 |Column 3

Data 1 | Data 4| a
Data 1 | Data 5| b
Data 1 | Data 6| c
Data 2 | Data 7| a
Data 2 | Data 8| b
Data 2 | Data 9| c
Data 3 | Data 10| a
Data 3 | Data 11| b
Data 3 | Data 12| c

thank you...

[Alex K.]

Hello,

In this case, please try to use the additional Grouping by Column1.

Thank you.

[kclow93]

Hi Aleksey,

Can you give me some example?

Thank You.

[Alex K.]

Hello,

Please check the sample report in the attachment.

Thank you.