Eclipse Community Forums: BIRT » how to merge rows with same values

Home » Archived » BIRT » how to merge rows with same values

how to merge rows with same values [message #77514]

Wed, 28 September 2005 12:03

Eclipse User

Originally posted by: jspsim.yahoo.com

Hi,

how can I merge cells in different rows with same values. For example I've
the following:

Continent Country City
Europe Germany Berlin
Europe Germany Munich
Europe England Heathrow
Europe England London
Asia China Beijing
Asia China Shanghai
Asia Malaysia Kuala Lumpur
Asia Malaysia Johor
Asia Thailand Bangkok

how do i make it look like this

Europe Germany Berlin
Munich
England Heathrow
London
Asia China Beijing
Shanghai
Malaysia Kuala Lumpur
Johor
Thailand Bangkok

cheers,
titan

Re: how to merge rows with same values [message #77572 is a reply to message #77514]

Wed, 28 September 2005 13:10

Eclipse User

Why not just put 2 nested groups on the table, by Continent, then Country
and
put the Continent and Country in the group header and leave city in the
detail?

Jason Weathersby
BIRT PMC

"titan" <jspsim@yahoo.com> wrote in message
news:dhef1f$j94$1@news.eclipse.org...
> Hi,
>
> how can I merge cells in different rows with same values. For example I've
> the following:
>
> Continent Country City
> Europe Germany Berlin
> Europe Germany Munich
> Europe England Heathrow
> Europe England London
> Asia China Beijing
> Asia China Shanghai
> Asia Malaysia Kuala Lumpur
> Asia Malaysia Johor
> Asia Thailand Bangkok
>
> how do i make it look like this
>
> Europe Germany Berlin
> Munich
> England Heathrow
> London
> Asia China Beijing
> Shanghai
> Malaysia Kuala Lumpur
> Johor
> Thailand Bangkok
>
> cheers,
> titan
>
>

Re: how to merge rows with same values [message #77587 is a reply to message #77572]

Wed, 28 September 2005 13:23

Eclipse User

Originally posted by: jspsim.yahoo.com

the user had explicitly wanted this type of view, so somehow i must try to
figure out how to do this.

"Jason Weathersby" <jweathersby@actuate.com> wrote in message
news:dheiqi$p4t$1@news.eclipse.org...
> Why not just put 2 nested groups on the table, by Continent, then Country
> and
> put the Continent and Country in the group header and leave city in the
> detail?
>
> Jason Weathersby
> BIRT PMC
>
> "titan" <jspsim@yahoo.com> wrote in message
> news:dhef1f$j94$1@news.eclipse.org...
>> Hi,
>>
>> how can I merge cells in different rows with same values. For example
>> I've the following:
>>
>> Continent Country City
>> Europe Germany Berlin
>> Europe Germany Munich
>> Europe England Heathrow
>> Europe England London
>> Asia China Beijing
>> Asia China Shanghai
>> Asia Malaysia Kuala Lumpur
>> Asia Malaysia Johor
>> Asia Thailand Bangkok
>>
>> how do i make it look like this
>>
>> Europe Germany Berlin
>> Munich
>> England Heathrow
>> London
>> Asia China Beijing
>> Shanghai
>> Malaysia Kuala Lumpur
>> Johor
>> Thailand Bangkok
>>
>> cheers,
>> titan
>>
>>
>
>

Re: how to merge rows with same values [message #77801 is a reply to message #77587]

Wed, 28 September 2005 22:06

Eclipse User

titan wrote:
> the user had explicitly wanted this type of view, so somehow i must try to
> figure out how to do this.
>
> "Jason Weathersby" <jweathersby@actuate.com> wrote in message
> news:dheiqi$p4t$1@news.eclipse.org...
>
>>Why not just put 2 nested groups on the table, by Continent, then Country
>>and
>>put the Continent and Country in the group header and leave city in the
>>detail?
>>
>>Jason Weathersby
>>BIRT PMC
>>
>>"titan" <jspsim@yahoo.com> wrote in message
>>news:dhef1f$j94$1@news.eclipse.org...
>>
>>>Hi,
>>>
>>>how can I merge cells in different rows with same values. For example
>>>I've the following:
>>>
>>>Continent Country City
>>>Europe Germany Berlin
>>>Europe Germany Munich
>>>Europe England Heathrow
>>>Europe England London
>>>Asia China Beijing
>>>Asia China Shanghai
>>>Asia Malaysia Kuala Lumpur
>>>Asia Malaysia Johor
>>>Asia Thailand Bangkok
>>>
>>>how do i make it look like this
>>>
>>>Europe Germany Berlin
>>> Munich
>>> England Heathrow
>>> London
>>>Asia China Beijing
>>> Shanghai
>>> Malaysia Kuala Lumpur
>>> Johor
>>> Thailand Bangkok
>>>
>>>cheers,
>>>titan
>>>
>>>
>>
>>
>
>
In your first level detail - right click - add group (add group for
Continent) then when this group has been added - right click the detail
row - add group for Country - and continue as needed

Previous Topic:	Bar Chart X-Axis grouping with dramatically different y-series scale
Next Topic:	"Enter Parameters" OK button greyed out

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jun 11 16:25:28 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter