Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » how to merge rows with same values
how to merge rows with same values [message #77514] Wed, 28 September 2005 16:03 Go to next message
Eclipse UserFriend
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

Report message to a moderator

Re: how to merge rows with same values [message #77572 is a reply to message #77514] Wed, 28 September 2005 17:10 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member
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
>
>

Report message to a moderator

Re: how to merge rows with same values [message #77587 is a reply to message #77572] Wed, 28 September 2005 17:23 Go to previous messageGo to next message
Eclipse UserFriend
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
>>
>>
>
>

Report message to a moderator

Re: how to merge rows with same values [message #77801 is a reply to message #77587] Thu, 29 September 2005 02:06 Go to previous message
David Trainor is currently offline David TrainorFriend
Messages: 23
Registered: July 2009
Junior Member
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 00:07:53 GMT 2024

Powered by FUDForum. Page generated in 0.04018 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