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 |
Allan Chandler 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 |
|
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 #522380 is a reply to message #522098] |
Mon, 22 March 2010 09:18 |
|
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.
>
|
|
|
Goto Forum:
Current Time: Thu Apr 25 07:27:34 GMT 2024
Powered by FUDForum. Page generated in 0.03153 seconds
|