Eclipse Community Forums: BIRT » Grouping data in a table

Home » Archived » BIRT » Grouping data in a table(Grouping data in a table)

Grouping data in a table [message #1835390]

Wed, 02 December 2020 04:40

Eclipse User

Hello!

I'm trying to gather/ group the data I have in my table to one line pr subject (ref attachments). Instead of the "direktoratet" is repeated several times, I want it only one time and then the count to show me how many times in that certain subject in one line.

Like this:
Direktoratet ----------------------------------- 18
Tjenestelinjen ---------------------------------- 1
økonomilinjen ---------------------------------- 4

I've tried to use the group function, but it doesn't seem to help me.

Any suggestions?

Attachment: grouing.png
(Size: 15.08KB, Downloaded 125 times)
Attachment: groupin 2.png
(Size: 38.23KB, Downloaded 150 times)

[Updated on: Wed, 02 December 2020 04:47] by Moderator

Re: Grouping data in a table [message #1835406 is a reply to message #1835390]

Wed, 02 December 2020 09:31

Eclipse User

more details please

Re: Grouping data in a table [message #1835407 is a reply to message #1835406]

Wed, 02 December 2020 09:36

Eclipse User

what info do you need?

So I reckon this happens because it gathers the different records in the AR system, and then each record is shown in the BIRT table.

please let me know what info you need in this case.

Re: Grouping data in a table [message #1835408 is a reply to message #1835407]

Wed, 02 December 2020 10:21

Eclipse User

for example - your second screenshot have field "group on = organisering" but I dont see it field on first screen

Re: Grouping data in a table [message #1835410 is a reply to message #1835408]

Wed, 02 December 2020 10:52

Eclipse User

it is supposed to field, but it doesnt.. that is my problem.

It works kind of in the cross tab ( see attachment), but then I have some other obstacles in terms of coulmn. Therefore, I thought it would be a better idea to do it with a regular table.

For the solution, I got told that grouping would be the right way. and if not, you could use "suppress duplicates", but that does not seem to be in the 4.8.0 version.

Attachment: data binding.png
(Size: 27.22KB, Downloaded 134 times)
Attachment: data set.png
(Size: 30.57KB, Downloaded 128 times)
Attachment: table 1.png
(Size: 17.16KB, Downloaded 152 times)
Attachment: crosstab.png
(Size: 5.80KB, Downloaded 133 times)

Previous Topic:	birt presto jdbc connexion
Next Topic:	page break in data cube

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Apr 24 14:09:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter