Merge row

[rupeshrp12]

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

 

[darth_fader]

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

[anji.viper]

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 :)