Hi,
I am newbie in jasper reporting design. I am trying to generate jrxml for below table.I am using ireport to design. Can you pelase help me get jrxml samples for such tables or steps to design in ireport.
| Name | Type | Numbers | Total | ||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||||
| Test 1 | xyz | 1 | 5 | 10 | 12 | 0 | 0 | 0 | 0 | 28 | |
| abc | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| Test2 | xyz | 2 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 10 | |
| abc | 0 | 5 | 2 | 0 | 0 | 0 | 0 | 0 | 7 | ||
| Test3 | xyz | 0 | 3 | 2 | 3 | 0 | 0 | 0 | 0 | 8 | |
| abc | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
||
Thanks is advance
2 Answers:
The crosstab component is what you'll need to accomplish your goal. There are several example online, check out crosstab tutorials jasper reports on youtube and google. Crosstabs are fairly advanced but IReport has a wizard that can help step you through the process.
Here is a link to an example with nested rows
http://bekwam.blogspot.com/2011/06/expanding-crosstab-in-jaspersoft.html
I searched a lot too and finally managed to do it.. Here's the related post for whoever needs it:
Merge rows when repeated values table
Cheers :)
