Eclipse Community Forums: BIRT » Displaying a table based on the value of its data elements

Help

Home

Home » Archived » BIRT » Displaying a table based on the value of its data elements

Show: Today's Messages :: Show Polls :: Message Navigator

Displaying a table based on the value of its data elements [message #368539]

Tue, 09 June 2009 06:12

shivam

Messages: 15
Registered: July 2009

Junior Member

Hi,
I have a database table that has data as follows:

1 xx
2 xy
4 xz

I have to finally display the data as :
xx xy xz
1 2 4

The number of columns are fixed i.e. (xx , xy and xz )

Any ideas ?

Thanks in Advance.

-- Shivam

Report message to a moderator

Re: Displaying a table based on the value of its data elements [message #368551 is a reply to message #368539]

Tue, 09 June 2009 13:35

Eclipse User

Originally posted by: jasonweathersby.windstream.net

Shivam,

How many rows are in the example you posted?
You should be able to use a crosstab to show this.

Jason

shivam wrote:
> Hi,
> I have a database table that has data as follows:
>
> 1 xx
> 2 xy 4 xz
>
>
> I have to finally display the data as :
> xx xy xz 1 2 4
>
> The number of columns are fixed i.e. (xx , xy and xz )
> Any ideas ?
> Thanks in Advance.
>
> -- Shivam

Report message to a moderator

Re: Displaying a table based on the value of its data elements [message #368591 is a reply to message #368551]

Fri, 12 June 2009 08:29

sissi

Messages: 533
Registered: July 2009

Senior Member

This also can be done by insert two lists, and one column in one list, set
its display as "Inline".

Thanks,
sissi

"Jason Weathersby" <jasonweathersby@windstream.net> wrote in message
news:h0loco$phb$1@build.eclipse.org...
> Shivam,
>
> How many rows are in the example you posted?
> You should be able to use a crosstab to show this.
>
> Jason
>
>
> shivam wrote:
>> Hi,
>> I have a database table that has data as follows:
>>
>> 1 xx
>> 2 xy 4 xz
>>
>>
>> I have to finally display the data as :
>> xx xy xz 1 2 4
>>
>> The number of columns are fixed i.e. (xx , xy and xz )
>> Any ideas ?
>> Thanks in Advance.
>>
>> -- Shivam

Report message to a moderator

Previous Topic:	Batch Processing
Next Topic:	iterate over report parameters in javascrips

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:04:34 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter