Dynamic columns Jasper Reports

[john.logia]

Hello all,

I am trying to create a jasper report with dynamic columns.

I have a database table

DAYTIME	Account	Num Value 1	Num  Value 2	Text	Num Value 3	Num Value 4	Num Value 5
01/01/2017	10	50	60	ABC	100	56	30
01/01/2017	10				200
01/01/2017	10				300
02/01/2017	20	67	34	BED	500	800	87
03/01/2017	10	133	456	ABC	123	233	345
03/01/2017	30	122	222	GEF	124	331	123

I would like to create a report that will generate a dynamic column on the highlighted column attribute to a report like this

Daytime	Account	Num Value 1	Num Value 2	Text	Num Value 3	Num Value 3	Num Value 3	Num Value 4	Num Value 5
01/01/2017	10	50	60	ABC	100	200	300	56	30
02/01/2017	20	67	34	BED	500			800	87
03/01/2017	10	133	456	ABC	123			233	345
03/01/2017	30	122	222	GEF	124			331	123

Is this Possible in Jasper Reports?

 

[Alex42]

This might not be a solution but a workaround.

You cound do something like that in ad-hoc views where data can be pivoted(or designed alreay pivoted) at the click of a buton. It's not the same, since you can't really format it to get a standard template for the result, but it might work, as it is dynamic and you can also export it and even save it as a report(just be carefull with the overwrite of the view "feature" aka "bug" from Jasper).