Conditional merging of cells in jasper reports without using cross tab

[aaratimaske19]

Hi Team, 

Please help me with the below issue :- 

I have below actual report 

Target	weightage	50%	75%	100%	125%	150%
A1-cases per month	30%		4	6	8	10
A1-cases per quarter	30%		12	18	24	30
A1-cases per annum	30%		48	72	96	120
A1-FYAP per annum	30%		360,000	480,000	600,000	720,000
A2	15%	10.00%	15.00%	20.00%	25.00%	30.00%
A3a-1st Year	15%		85.00%	90.00%	92.00%	95.00%
A3b-2nd Year	15%		75.00%	80.00%	85.00%	90.00%
A4	10%			0
A5	15%			30
A5-Total	15%			5

and expected report is 

Target	weightage	50%	75%	100%	125%	150%
A1-cases per month	30%		4	6	8	10
A1-cases per quarter			12	18	24	30
A1-cases per annum			48	72	96	120
A1-FYAP per annum			360,000	480,000	600,000	720,000
A2	15%	10.00%	15.00%	20.00%	25.00%	30.00%
A3a-1st Year	15%		85.00%	90.00%	92.00%	95.00%
A3b-2nd Year	15%		75.00%	80.00%	85.00%	90.00%
A4	10%			0
A5	15%			30
A5-Total				5

Issue:- I am trying to do conditional merging based on 2 columns.  For e.g in above mentioned table I want to merge all cells in second column with same percentage as 30 where value in first column "Target"  starts from  A1 and cells in second column with same values corresponding to cells where value in column 1 starts from A5 . Refer highlighted in yellow and green color respectively in above expected report.

We do not want to merge cells with value in first col as A2,A3.(A2 and A3 are having same weightage but I dont want to merge it).

Data in weightage column is dynamic while in Target column it is constant. 

I have tried Crosstab and it is not working for this, as scenario is different.

Any help would be appreciable.

[hozawa]

That's not possible with JasperReports.

When I need to do that, I add a filter that would modify the generated html.