show data in horizontal part 2

Stimulsoft Reports.PHP discussion
Post Reply
kclow93
Posts: 6
Joined: Tue Dec 15, 2015 6:38 am
Location: Usa

show data in horizontal part 2

Post 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| Data A
Data 1 | Data 5| Data B
Data 1 | Data 6| Data C
Data 2 | Data 7| Data A
Data 2 | Data 8| Data B
Data 2 | Data 9| Data C
Data 3 | Data 10| Data A
Data 3 | Data 11| Data B
Data 3 | Data 12| Data C

thank you...
kclow93
Posts: 6
Joined: Tue Dec 15, 2015 6:38 am
Location: Usa

Re: show data in horizontal part 2

Post by kclow93 »

up
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: show data in horizontal part 2

Post by Alex K. »

Hello,

Please try to use the Cross-Table component.

Thank you.
Post Reply