Jump to content
Changes to the Jaspersoft community edition download ×

Merge rows - when repeated values in table


Kevinapa9

Recommended Posts

Hello 

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:

converted-file.png.0786316e6c192ff5ec0f7ab2628e7b21.png

This is the result I need:

converted-file.png.b013aa05b7879a7649d19959ddfe56cf.png

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!

Kevin

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

  • 1 month later...

Hello,

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.

Regards,

Paul

Link to comment
Share on other sites

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...