Cross Tab with both Ignore Pagination and Ignore Width

Posted on May 5, 2020 at 8:49am

Following is my requirement for crosstab,

I have 40 users data, which is Row group (User count will vary)
I have 5 test result data, which is Column group (Test count will vary)
I have to display two test per page.
I have to display all the user data in single page

Following is my sample data,

Student Name	Test Name	Score
std1	test1	35
std1	test2	45
std1	test3	55
std1	test4	65
std1	test5	75
std2	test1	86
std2	test2	76
std2	test3	66
std2	test4	56
std2	test5	65
std3	test1	35
std3	test2	65
std3	test3	98
std3	test4	67
std3	test5	25
std4	test1	65
std4	test2	98
std4	test3	67
std4	test4	25
std4	test5	35

Following is the result, I am getting,

Page1			Page2			Page3			Page4			Page5		Page6
	Test1	Test2		Test1	Test2		Test3	Test4		Test3	Test4		Test5		Test5
std1	35	45	std3	35	65	std1	55	65	std3	98	67	std1	75	std3	25
std2	86	76	std4	65	98	std2	66	56	std4	67	25	std2	65	std4	35

Following is the result I am looking for,

Page1			Page2			Page3
	Test1	Test2		Test3	Test4		Test5
std1	35	45	std1	55	65	std1	75
std2	86	76	std2	66	56	std2	65
std3	35	65	std3	98	67	std3	25
std4	65	98	std4	67	25	std4	35

The thing is I have to display all the 40 users data with two test per page. In this case I have use both Ignorepagination of Report property and Ignore Width of CrossTab property.

Can someone help me on this?

I have also attached the jrxml file of my sample report.

Attachments: