[go: up one dir, main page]
Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » 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 99 times)
  • Attachment: groupin 2.png
    (Size: 38.23KB, Downloaded 113 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

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 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.

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 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

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 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.
  • Attachment: data binding.png
    (Size: 27.22KB, Downloaded 111 times)
  • Attachment: data set.png
    (Size: 30.57KB, Downloaded 107 times)
  • Attachment: table 1.png
    (Size: 17.16KB, Downloaded 112 times)
  • Attachment: crosstab.png
    (Size: 5.80KB, Downloaded 105 times)

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 16:36:22 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly