Cross Tab with both Ignore Pagination and Ignore Width

0

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: 
vignesh.september's picture
Joined: Mar 18 2014 - 11:30pm
Last seen: 4 months 3 weeks ago

0 Answers:

No answers yet
Feedback
randomness