Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Grouping data in a table(Grouping data in a table)
Grouping data in a table [message #1835390] Wed, 02 December 2020 09:40 Go to next message
Nikolai Elders is currently offline Nikolai EldersFriend
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 25 times)
  • Attachment: groupin 2.png
    (Size: 38.23KB, Downloaded 26 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 Go to previous messageGo to next message
dmitry khotsko is currently offline dmitry khotskoFriend
Messages: 38
Registered: March 2020
Member
more details please
Re: Grouping data in a table [message #1835407 is a reply to message #1835406] Wed, 02 December 2020 14:36 Go to previous messageGo to next message
Nikolai Elders is currently offline Nikolai EldersFriend
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.
Re: Grouping data in a table [message #1835408 is a reply to message #1835407] Wed, 02 December 2020 15:21 Go to previous messageGo to next message
dmitry khotsko is currently offline dmitry khotskoFriend
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
Re: Grouping data in a table [message #1835410 is a reply to message #1835408] Wed, 02 December 2020 15:52 Go to previous message
Nikolai Elders is currently offline Nikolai EldersFriend
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.
Previous Topic:birt presto jdbc connexion
Next Topic:page break in data cube
Goto Forum:
  


Current Time: Wed Oct 20 01:57:10 GMT 2021

Powered by FUDForum. Page generated in 0.01509 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top