Eclipse Community Forums: BIRT » Multiple query execution

Home » Archived » BIRT » Multiple query execution

Multiple query execution [message #220780]

Fri, 23 February 2007 19:19

Eclipse User

Hi,

Is it possible to execute multiple queries in the report to display result
in one table. I know that I can create multiple datasets (each representing
one query), but then I have to assign each dataset to a different table.
Currently what I want is to execute multiple queries and the result to be
shown in one table. May be there is a way to do it using the scripting. Any
help in this regard would be appreciated.

Thanks
Bidyut

Re: Multiple query execution [message #220873 is a reply to message #220780]

Sun, 25 February 2007 11:21

Eclipse User

Originally posted by: martin.tauber.t-online.de

Hi Bidyut,

since you are using queries and I quess you are talking about
sql-queries, why aren't you just using sql to do the job for you, after
all this is a major feature of sql.

consider looking at something like this:

select a.col1, b.col2 c.col3
from table1 a, table2 b table3 c
where a.key = b.key and
a.key = c.key

regards
Martin

Bidyut Pattanayak schrieb:
> Hi,
>
> Is it possible to execute multiple queries in the report to display
> result in one table. I know that I can create multiple datasets (each
> representing one query), but then I have to assign each dataset to a
> different table. Currently what I want is to execute multiple queries
> and the result to be shown in one table. May be there is a way to do it
> using the scripting. Any help in this regard would be appreciated.
>
> Thanks
> Bidyut
>
>

Re: Multiple query execution [message #220907 is a reply to message #220873]

Sun, 25 February 2007 19:36

Eclipse User

or you can try to use the stored procedure

Re: Multiple query execution [message #221187 is a reply to message #220873]

Mon, 26 February 2007 13:48

Eclipse User

Hello Martin,

I am exactly talking about sql queries. But I can only assign one sql query
to one dataset or can I use multiple queries for one data set?

Thanks
Bidyut
> Hi Bidyut,
>
> since you are using queries and I quess you are talking about
> sql-queries, why aren't you just using sql to do the job for you,
> after all this is a major feature of sql.
>
> consider looking at something like this:
>
> select a.col1, b.col2 c.col3
> from table1 a, table2 b table3 c
> where a.key = b.key and
> a.key = c.key
> regards
> Martin
> Bidyut Pattanayak schrieb:
>
>> Hi,
>>
>> Is it possible to execute multiple queries in the report to display
>> result in one table. I know that I can create multiple datasets (each
>> representing one query), but then I have to assign each dataset to a
>> different table. Currently what I want is to execute multiple queries
>> and the result to be shown in one table. May be there is a way to do
>> it using the scripting. Any help in this regard would be appreciated.
>>
>> Thanks
>> Bidyut

Re: Multiple query execution [message #221195 is a reply to message #220907]

Mon, 26 February 2007 13:49

Eclipse User

Hello 70,

Stored procedure is not a viable option because our application supports
multiple database types. Hence we won't be able to write stored procedures
that can be run on Oracle, SQL Server and MySQL.

Thanks
Bidyut

> or you can try to use the stored procedure
>

Re: Multiple query execution [message #221283 is a reply to message #220780]

Mon, 26 February 2007 16:53

Eclipse User

I had the same problem and tried several different methods. I looked at
Stored Procedures but there seemed to be too many differences between dbs to
implement effectively. I ended up creating a View where I could specify the
multiple queries. Then you can easily access the View as any other table in
your db from Birt.

Bill

"Bidyut Pattanayak" <bidyut@yahoo.com> wrote in message
news:65c30c7bd8b48c9257d75f8f9fa@news.eclipse.org...
> Hi,
>
> Is it possible to execute multiple queries in the report to display result
> in one table. I know that I can create multiple datasets (each
> representing one query), but then I have to assign each dataset to a
> different table. Currently what I want is to execute multiple queries and
> the result to be shown in one table. May be there is a way to do it using
> the scripting. Any help in this regard would be appreciated.
>
> Thanks
> Bidyut
>
>

Previous Topic:	Setting Portion of Data to Bold within 1 expression
Next Topic:	BIRT Viewer: temporary files management?

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 09:05:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter