show data in horizontal
Posted: Tue Dec 15, 2015 7:13 am
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...
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...