Merge rows - when repeated values in table


I'm looking for a solution to join a line with repeated values. I'm joining three tables (revenue, cost, fmparty) in one table.

This is the result of the query:

This is the result I need:

I cannot uncheck "Print repeated values" because it is not suitable for the project.

I've tried the crosstab solution but no results. 


Thanks a lot for your help!


Kevinapa9's picture
Joined: Jun 7 2023 - 7:52am
Last seen: 3 months 2 weeks ago

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit for direct access to our technical support teams offering guaranteed response times.

arai_4 - 3 months 3 weeks ago

1 Answer:


Unfortunately, I do not see a solution to this. The main problem  is that any column may be subject to span over the next one or more rows, preventing any type of predefined aggregation such as grouping. Also forwarding into a dataset is also not possible. I apologize I could not be more help or provide a solution, but as this stands now, this is not possible.



pjimenez_2's picture
Joined: Oct 26 2016 - 11:39am
Last seen: 2 weeks 5 days ago