Pivot Table without Group Headers

[ashwitanayudu92]

Hi All,

I am trying to get the below template designed in jaspersoft, but have not found any hack.

Can someone  please help, if they have encountered the same?

Model Name	Model ID	1/31/2020	1/31/2020	2/29/2020	3/31/2020	4/30/2020
Mahendra	00B2	5	5	2	6	7
Swiss	0CGH	8	4	6	5	8
Jaguar	FD25	7	2	5	3	4
Maruti	X085	3	2	5	7	8
Total		23	13	18	21	27

Dates columns here are stored in rows in the underlying data. I have tried this with Cross tab as well as subreports.

Please help.

[yama818]

I was able to achieve something similar.

- Report preview image

 

- Report design image
Note that 'Model Name' and 'Model ID' are label components.

 

- Test Data

I hope this is useful to you.