How to regroup cells in details

0

Hi,

First I am new to jasper, so maybe the question is trivial, but I don't find solution on the internet.

 

I have this kind of data:

id groupid groupLabel value
1 0 SOME LABEL hello
2 0 SOME LABEL how
3 1 ANOTHER LABEL are
4 1 ANOTHER LABEL you

 

But I would like to regroup groupLabel by groupId  to have this display:

id groupid groupLabel value
1 0 SOME LABEL hello
2 0 how
3 1 ANOTHER LABEL are
4 1 you

 

I don't find the solution to this problem.

tyvain's picture
3
Joined: Aug 13 2018 - 5:20pm
Last seen: 8 months 3 weeks ago

3 Answers:

0

I don't think it's possible to implement the exact layout you did. Once I asked a Tibco consultant he did not know it too.

The closest possible layout is like this: https://postimg.cc/image/ow4d47jkx/

Of course, you can remove the borders in each group to make it look better.

To implement this, first sort your data on the grouping column (I did this in Dataset and Query -> Sorting) then check Textfield property -> Print Repeated Values -> Uncheck

riodavid's picture
507
Joined: Oct 27 2016 - 1:57am
Last seen: 1 year 1 week ago
0

Hi riodavid,

I mange to do it as you said. But this 'unsued' space is a waste.

In my case, the merged cell is a big text, so its looks like this (it's ugly...):

 

id groupid groupLabel value
1 0

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum

 

 

 

 

 

 

hello
2 0 how
3 1

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum

 

 

 

 

 

 

are
4 1 you

 

The perfect solution would be to use this empty space...

tyvain's picture
3
Joined: Aug 13 2018 - 5:20pm
Last seen: 8 months 3 weeks ago
0

Sorry, as I said, this is the closest solution I know. As well as a Tibco consultant suggested.

riodavid's picture
507
Joined: Oct 27 2016 - 1:57am
Last seen: 1 year 1 week ago
Feedback