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.
3 Answers:
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
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...
