[#10991] - Duplicates are not summing in crosstab in ireport desighner

Category:
Feature request
Priority:
High
Status:
New
Project: Severity:
Block
Resolution:
Duplicate
Component: Reproducibility:
Unable to Reproduce
Assigned to:
0

class_sec religion total_fee
1 hindu 100
2 muslim 300
3 jyana 400
3 jyna 200

this is my input

I have done group by in mysql on class_sec,religion in mysql

class_sec religion totalfee
1 hindu 100
2 muslim 300
3 jyana 600

when I cross tab in jaspersoft i reports it's displaying like as below
hindu muslim jyana totalfee
class_sec 1 100 0 100
2 0 300 0 300
3 0 0 400 400
3 0 0 200 200

but I want it as followed

hindu muslim jyana totalfee
class_sec 1 100 0 100
2 0 300 0 300
3 0 0 600 600

Could you please look into this issue and let me know any feature is available in i- reports?

For clear view please find attachment.

AttachmentSize
File duplicates_issuein_cross_tab.xlsx8.93 KB
v5.6.0
iReport Designer
sury.90830's picture
Joined: Jul 2 2018 - 10:20am
Last seen: 10 months 2 weeks ago
Feedback