Jump to content
Changes to the Jaspersoft community edition download ×

Conditional merging of cells in jasper reports without using cross tab


aaratimaske19

Recommended Posts

Hi Team, 

Please help me with the below issue :- 

I have below actual report 

Targetweightage50%75%100%125%150%
A1-cases per month30% 46810
A1-cases per quarter30% 12182430
A1-cases per annum30% 487296120
A1-FYAP per annum30% 360,000480,000600,000720,000
A215%10.00%15.00%20.00%25.00%30.00%
A3a-1st Year15% 85.00%90.00%92.00%95.00%
A3b-2nd Year15% 75.00%80.00%85.00%90.00%
A410%  0  
A515%  30  
A5-Total15%  5  

and expected report is 

Targetweightage50%75%100%125%150%
A1-cases per month30% 46810
A1-cases per quarter 12182430
A1-cases per annum 487296120
A1-FYAP per annum 360,000480,000600,000720,000
A215%10.00%15.00%20.00%25.00%30.00%
A3a-1st Year15% 85.00%90.00%92.00%95.00%
A3b-2nd Year15% 75.00%80.00%85.00%90.00%
A410%  0  
A515%  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.

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...