Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » How can we combine group header with first group detail line?
How can we combine group header with first group detail line? [message #521898] Fri, 19 March 2010 08:24 Go to next message
Allan Chandler is currently offline Allan ChandlerFriend
Messages: 20
Registered: July 2009
Junior Member
When grouping in BIRT, we frequently want the grouping
value to show up on the first line as follows:

Group   User                       Reputation
------  ---------------            ----------
Admins  Bill The Weasel                51,018
        Mark Grovel                   118,101
Users   Pax_my_bags_got_to_go          73,554
        Jon Scoot                  **,***,*** <- overflow
        Clueless                       92,928

The normal way of achieving this is to lay out the group in the
designer as follows:

        +---------+--------+--------------+
Tbl Hdr | Group   | User   |   Reputation |
        +---------+--------+--------------+
Grp Hdr | [Group] |        |              |
        +---------+--------+--------------+
Grp Dtl |         | [User] | [Reputation] |
        +---------+--------+--------------+
Grp Ftr |         |        |              |
        +---------+--------+--------------+
Tbl Ftr |         |        |              |
        +---------+--------+--------------+

which, unfortunately, lays out the data in exactly that way, with
the grouped value on a different line:

Group   User                       Reputation
------  ---------------            ----------
Admins
        Bill The Weasel                51,018
        Mark Grovel                   118,101
Users
        Pax_my_bags_got_to_go          73,554
        Jon Scoot                  **,***,*** <- overflow
        Clueless                       92,928

This is particularly painful with data where there's lots of
groups with only one user since we use twice as much
space as needed. If we move the [Group] data item down
to the Grp Dtl line, we get it printed for every line in the group.

How, in BIRT, do we merge the two lines Grp Hdr and the
first Grp Dtl?

[Updated on: Fri, 19 March 2010 08:26]

Report message to a moderator

Re: How can we combine group header with first group detail line? [message #522010 is a reply to message #521898] Fri, 19 March 2010 11:06 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Allan,

Drop the group data item to the detail row and then check the suppress
duplicates in the table column's general properties.

Jason

Allan Chandler wrote:
> When grouping in BIRT, we frequently want the grouping value to show up
> on the first line as follows:
>
> Group User Reputation
> ------ --------------- ----------
> Admins Bill The Weasel 51,018
> Mark Grovel 118,101
> Users Pax_my_bags_got_to_go 73,554
> Jon Scoot **,***,*** <- overflow
> Clueless 92,928
>
> The normal way of achieving this is to lay out the group in the designer
> as follows:
>
> +---------+--------+--------------+
> Tbl Hdr | Group | User | Reputation |
> +---------+--------+--------------+
> Grp Hdr | [Group] | | |
> +---------+--------+--------------+
> Grp Dtl | | [User] | [Reputation] |
> +---------+--------+--------------+
> Grp Ftr | | | |
> +---------+--------+--------------+
> Tbl Ftr | | | |
> +---------+--------+--------------+
>
> which, unfortunately, lays out the data in exactly that way, with the
> grouped value on a different line:
>
> Group User Reputation
> ------ --------------- ----------
> Admins
> Bill The Weasel 51,018
> Mark Grovel 118,101
> Users
> Pax_my_bags_got_to_go 73,554
> Jon Scoot **,***,*** <- overflow
> Clueless 92,928
>
> This is particularly painful with data where there's lots of groups with
> only one user since we use twice as much space as needed. If we move the
> [Group] data item down to the Grp Dtl line, we get it printed for every
> line in the group.
>
> How, in BIRT, do we merge the two lines Grp Hdr and the first Grp Dtl?
>
>
Re: How can we combine group header with first group detail line? [message #522098 is a reply to message #522010] Fri, 19 March 2010 23:50 Go to previous messageGo to next message
Allan Chandler is currently offline Allan ChandlerFriend
Messages: 20
Registered: July 2009
Junior Member
>Drop the group data item to the detail row and then check the suppress duplicates in the table column's general properties.

Jason et al,

Will this only suppress adjacent duplicates or all duplicates? By that I mean, if I have the data:

A-1-X
A-2-X
A-3-X
B-1-X
B-7-X

with grouping on columns 1 and 2, I understand that I'll only get the first A and B in column 1.

But, will the 1 in B-1-X be suppressed as a duplicate of the 1 in A-1-X or is the fact that we're in a new higher group (column 1) allow this to display.

Cheers.
Re: How can we combine group header with first group detail line? [message #522380 is a reply to message #522098] Mon, 22 March 2010 09:18 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Allan,

It should only suppress duplicates for the specific column that are
adjacent.

Jason

Allan Chandler wrote:
>> Drop the group data item to the detail row and then check the suppress
>> duplicates in the table column's general properties.
>
> Jason et al,
>
> Will this only suppress adjacent duplicates or all duplicates? By that I
> mean, if I have the data:
>
> A-1-X
> A-2-X
> A-3-X
> B-1-X
> B-7-X
>
> with grouping on columns 1 and 2, I understand that I'll only get the
> first A and B in column 1.
>
> But, will the 1 in B-1-X be suppressed as a duplicate of the 1 in A-1-X
> or is the fact that we're in a new higher group (column 1) allow this to
> display.
>
> Cheers.
>
Previous Topic:eSite selects Yellowfin for its integrated Location Intelligence
Next Topic:Convert RTF-Files to a Report
Goto Forum:
  


Current Time: Thu Apr 25 07:27:34 GMT 2024

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

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

Back to the top