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
Eclipse UserFriend
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 110 times)
  • Attachment: groupin 2.png
    (Size: 38.23KB, Downloaded 130 times)

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

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
Eclipse UserFriend
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
Eclipse UserFriend
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
Eclipse UserFriend
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
Eclipse UserFriend
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 120 times)
  • Attachment: data set.png
    (Size: 30.57KB, Downloaded 115 times)
  • Attachment: table 1.png
    (Size: 17.16KB, Downloaded 134 times)
  • Attachment: crosstab.png
    (Size: 5.80KB, Downloaded 118 times)
Previous Topic:birt presto jdbc connexion
Next Topic:page break in data cube
Goto Forum:
  


Current Time: Wed Feb 19 11:53:12 GMT 2025

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

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

Back to the top