Crosstab without column groups

[makbolat]

Hi,

I want to design a pivot report with Crosstab,

My data is on the below table:

REFERENCE	SHIP NAME	DOCK	STARTING TIME	ENDING TIME	DATE	SHIFTING	CARGO	TONNAGE
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/02	3 rd Shifting	COAL	7.200.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/03	1st Shifting	COAL	19.400.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/03	2nd Shifting	COAL	13.876.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/03	3 rd Shifting	COAL	16.900.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/04	1st Shifting	COAL	14.624.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/04	2nd Shifting	COAL	14.850.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/04	3 rd Shifting	COAL	14.650.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/05	1st Shifting	COAL	13.000.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/05	2nd Shifting	COAL	12.200.000
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/05	3 rd Shifting	COAL	9.969.837
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/06	1st Shifting	COAL	8.000.000
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/06	2nd Shifting	COAL	7.870.000
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/06	3 rd Shifting	COAL	5.900.000
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/07	1st Shifting	COAL	6.230.000
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/07	2nd Shifting	COAL	7.320.000
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/07	3 rd Shifting	COAL	5.480.000
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/08	1st Shifting	COAL	2.609.337

 

 

And I want to show this data like below table:

 

REFERENCE	SHIP NAME	DOCK	STARTING TIME	ENDING TIME	DATE	SHIFTING	CARGO	TONNAGE
2015-00047	BALTIC WOLVARIANE	1st Dock	02.04.2015 21:30	05.04.2015 22:00	2015/04/02	3 rd Shifting	COAL	7.200.000
						TOTAL		7.200.000
					2015/04/03	1st Shifting	COAL	19.400.000
						2nd Shifting	COAL	13.876.000
						3 rd Shifting	COAL	16.900.000
						TOTAL		50.176.000
					2015/04/04	1st Shifting	COAL	14.624.000
						2nd Shifting	COAL	14.850.000
						3 rd Shifting	COAL	14.650.000
						TOTAL		44.124.000
					2015/04/05	1st Shifting	COAL	13.000.000
						2nd Shifting	COAL	12.200.000
						3 rd Shifting	COAL	9.969.837
						TOTAL		35.169.837
	GENERAL TOTAL							136.669.837
2015-00059	SUPER TEMPTATION	2nd Dock	06.04.2015 03:55	08.04.2015 01:50	2015/04/06	1st Shifting	COAL	8.000.000
						2nd Shifting	COAL	7.870.000
						3 rd Shifting	COAL	5.900.000
						TOTAL		21.770.000
					2015/04/07	1st Shifting	COAL	6.230.000
						2nd Shifting	COAL	7.320.000
						3 rd Shifting	COAL	5.480.000
						TOTAL		19.030.000
					2015/04/08	1st Shifting	COAL	2.609.337
						TOTAL		2.609.337
	GENERAL TOTAL							43.409.337

 

The problem is on Crosstab, do I have to add column group? Becouse on my report there is no column group. 

Or shold I do this with another component and method?

Thank for answers.

 

By the way my tool info:

Product Version: Jaspersoft iReport Designer 4.1.2

Java: 1.6.0_35; Java HotSpot Client VM 20.10-b01

System: Windows 7 version 6.1 running on x86; Cp1254; tr_TR (ireport)