| birt report designing help [message #182089] |
Wed, 02 August 2006 17:04  |
Eclipse User |
|
|
|
Originally posted by: reshmabhat.yahoo.com
hi,
i'm trying to generate a report using birt.
i have problems in designing my reports.
my query goes this way...
select name, address, quantity from report
i need to get report as
quantity
name address1 address2, address3
name1 24 46 78
name2 8 78 89
here, name1, name2, .... are the values of 'name' column & 24, 46 ...all
are the quantity values. address1, address2,... are address field values.
my problem is I dont know, how to convert my resultant row set into column
values(in this case, address1, address2).
is it possible to place some kind of constraints say, address=address1
then place quantity under address1 column???
can someone help me?
i use eclipse callistro 3.2 with birt 2.1 rc3 & SQLServer.
thanx in advance.
|
|
|
| Re: birt report designing help [message #182131 is a reply to message #182089] |
Wed, 02 August 2006 18:42  |
| Eclipse User |
|
|
|
This type of report, commonly referred to as cross-tab, is not currently
supported in BIRT. We are considering this feature for a future release.
thanks,
--
Gary Xue
Actuate Corporation - Product Developmentk
BIRT Committer
"Reshma" <reshmabhat@yahoo.com> wrote in message
news:1cad06fd2bb695b1ee81dede9faf73c3$1@www.eclipse.org...
> hi,
>
> i'm trying to generate a report using birt.
> i have problems in designing my reports.
>
> my query goes this way...
>
> select name, address, quantity from report
>
> i need to get report as
>
> quantity
> name address1 address2, address3
>
> name1 24 46 78
> name2 8 78 89
>
> here, name1, name2, .... are the values of 'name' column & 24, 46 ...all
> are the quantity values. address1, address2,... are address field values.
>
> my problem is I dont know, how to convert my resultant row set into column
> values(in this case, address1, address2).
>
> is it possible to place some kind of constraints say, address=address1
> then place quantity under address1 column???
>
> can someone help me?
>
> i use eclipse callistro 3.2 with birt 2.1 rc3 & SQLServer.
>
> thanx in advance.
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.04792 seconds
Home