Conditional merging of cells in jasper reports without using cross tab

0

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.

aaratimaske19's picture
Joined: Jan 10 2019 - 5:08am
Last seen: 5 days 20 hours ago

1 Answer:

0

That's not possible with JasperReports.

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

hozawa's picture
36465
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 hours 43 sec ago
Feedback
randomness