jasper reports - Printing the data in horizontal order. Dynamic columns -

jasper reports - Printing the data in horizontal order. Dynamic columns -

i facing issues design of below jasperreports format:

i have requirement in need print info in horizontal order rather vertical.

there 2 tables:

teacher

teacher_id teacher_name 1 tom 2 monique 3 sofie

subject

subject_id subject_name 1 phy 2 chem 3 bio 4 eng etc....

the study presentation below subject column grow horizontally each record.

teacherid teachername subjects 1 tom physics chem bio 2 sofie eng history geography 3 monique eng chem physics

i have used subreport subjects. , have been able grow list of subjects horizontally specifying column “20” , printorder “horizontal”. approach columns printed horizontally don’t grow horizontally. there size fixed 20 , such leave lot of blank space. not sure how create subjects column grow dynamically in horizontal direction (dynamic columns). tried alternative of subreport + list element without success. crosstabs haven’t tried , neither sure if work out. if can accomplish dynamic columns, can aim next level of study output below:

teacherid teachername subjects physics chem bio eng 1 tom yes 2 sofie yes 3 monique yes

any clue how go this?

we have utilize crosstab in ireports dynamic columns

jasper-reports crosstab subreport