| Displaying SQL data in a horizontal format [message #104939] |
Thu, 05 January 2006 13:30  |
Eclipse User |
|
|
|
Originally posted by: jake.westviewclose.co.uk
All,
I'm currently building a report in which I have a table of data values
that I want to display on the report. This is very simple when the
values are to go in a vertical (ie down the page) direction, as I write
a simple SQL query and use a table to display the data.
However, I want these values to be written horizontally (ie across the
page instead). There are a specified maximum amount of values (so I
won't exceed page width).
For example
Current report :-
2.0
1.5
1.4
1.3
1.2
1.1
1.08
1.04
1.03
1.02
1.01
Desired report format
2.0 1.5 1.4 1.3 1.2 1.1 1.08 1.04 1.03 1.02 1.01
It should be obvious, but i've been going round and round in circles all
day...
Please can anyone advise if a) it is possible... b) if they could
provide a solution, or a suggested method?
Thank you kindly in advance for any help.
Jake
|
|
|
|
|
|
| Re: Displaying SQL data in a horizontal format [message #105960 is a reply to message #105906] |
Sat, 07 January 2006 18:40  |
| Eclipse User |
|
|
|
Originally posted by: jake.westviewclose.co.uk
Dwarakanath / Daniel,
Thanks for your responses...sadly I'm using MySQL, not Oracle - and yes
I believe that a Cross-tab report would fulfil my needs, but as you
state Daniel, I don't think this is a feature yet.
My only option so far is to write a small program that selects the 50
values that I need from multiple rows and inserts them into the same,
single row.
Its an incredibly inefficient way to work, both storage and
processing-wise, and i'd have hoped that with a product like BIRT there
would have been a smarter way around it. (i still suspect that there
might be, i just haven't discovered it yet!).
However, the search goes on, and i'm hoping that someone may provide the
key to the answer before I write one of the more embarrassing pieces
of code of my programming life ;)
thanks again
jake
Dwarakanath wrote:
> I think you can use the decode function of oracle to get this functionality
> (if you are using oracle). Decode transposes the data.
>
> Regards
> Dwarakanath
>
> "daniel" <sasa@sasa.com> wrote in message
> news:57207b334af08548107ff868b3007c51$1@www.eclipse.org...
>
>>Maybe you want a cross-tab Report??
>>I think this feature is not ready in Birt yet...
>>Someone knows when Birt will have this feature??
>>
>
>
>
|
|
|
| Re: Displaying SQL data in a horizontal format [message #106549 is a reply to message #105960] |
Tue, 10 January 2006 02:06 |
| Eclipse User |
|
|
|
Hi Jake
You might want to take a look at this and do some R&D. Maybe it will help
http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-041.ht ml
Regards
Dwarakanath
"Jake Day" <jake@westviewclose.co.uk> wrote in message
news:43C05150.7060900@westviewclose.co.uk...
> Dwarakanath / Daniel,
>
> Thanks for your responses...sadly I'm using MySQL, not Oracle - and yes I
> believe that a Cross-tab report would fulfil my needs, but as you state
> Daniel, I don't think this is a feature yet.
>
> My only option so far is to write a small program that selects the 50
> values that I need from multiple rows and inserts them into the same,
> single row.
>
> Its an incredibly inefficient way to work, both storage and
> processing-wise, and i'd have hoped that with a product like BIRT there
> would have been a smarter way around it. (i still suspect that there might
> be, i just haven't discovered it yet!).
>
> However, the search goes on, and i'm hoping that someone may provide the
> key to the answer before I write one of the more embarrassing pieces of
> code of my programming life ;)
>
> thanks again
>
> jake
> Dwarakanath wrote:
>> I think you can use the decode function of oracle to get this
>> functionality (if you are using oracle). Decode transposes the data.
>>
>> Regards
>> Dwarakanath
>>
>> "daniel" <sasa@sasa.com> wrote in message
>> news:57207b334af08548107ff868b3007c51$1@www.eclipse.org...
>>
>>>Maybe you want a cross-tab Report??
>>>I think this feature is not ready in Birt yet...
>>>Someone knows when Birt will have this feature??
>>>
>>
>>
|
|
|
|
Powered by
FUDForum. Page generated in 0.58091 seconds
Home