Page 1 of 1

show data in horizontal

Posted: Tue Dec 15, 2015 7:13 am
by 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...

Re: show data in horizontal

Posted: Tue Dec 15, 2015 10:17 am
by Alex K.
Hello,

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

Thank you.

Re: show data in horizontal

Posted: Tue Dec 15, 2015 12:00 pm
by kclow93
Hi Aleksey,

Can you give me some example?

Thank You.

Re: show data in horizontal

Posted: Wed Dec 16, 2015 6:42 am
by Alex K.
Hello,

Please check the sample report in the attachment.

Thank you.