Eclipse Community Forums: BIRT » Grouping data in a table

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

Grouping data in a table [message #1835390]

Wed, 02 December 2020 09:40

Nikolai Elders

Messages: 17
Registered: October 2020

Junior Member

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 79 times)
Attachment: groupin 2.png
(Size: 38.23KB, Downloaded 81 times)

[Updated on: Wed, 02 December 2020 09:47]

Report message to a moderator

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

Wed, 02 December 2020 14:31

dmitry khotsko

Messages: 38
Registered: March 2020

Member

more details please

Report message to a moderator

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

Wed, 02 December 2020 14:36

Nikolai Elders

Messages: 17
Registered: October 2020

Junior Member

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.

Report message to a moderator

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

Wed, 02 December 2020 15:21

dmitry khotsko

Messages: 38
Registered: March 2020

Member

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

Report message to a moderator

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

Wed, 02 December 2020 15:52

Nikolai Elders

Messages: 17
Registered: October 2020

Junior Member

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 88 times)
Attachment: data set.png
(Size: 30.57KB, Downloaded 90 times)
Attachment: table 1.png
(Size: 17.16KB, Downloaded 86 times)
Attachment: crosstab.png
(Size: 5.80KB, Downloaded 78 times)

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 08:18:35 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter