Eclipse Community Forums: BIRT » using more than 2 data sets

Home » Archived » BIRT » using more than 2 data sets

using more than 2 data sets [message #59617]

Mon, 18 July 2005 19:32

Eclipse User

Is there any way to see more than 2 data sets in the "Expression Builder"?

Here is my situation:
I have a grid that is bound to a data set called DS0. There are two tables
inside the grid; Table1 is bound to DS1 and Table2 is bound to DS2.

From Table2 Expression Builder, only DS0 and DS2 are visible. Is there any
way to see DS1 also?

Any help is appreciated.

Thanks!
-Lillian

Re: using more than 2 data sets [message #60544 is a reply to message #59617]

Thu, 21 July 2005 14:11

Eclipse User

In BIRT 1.0, DS1 cannot be accessed in scripts defined on Table 2/ DS2. I
can perhaps suggest an alternative if you can explain in more detail what
you are trying to do here. What properties of DS1 do you want to access in
Table 2?

thanks,
Gary Xue

"Lillian Tan" <lillian.tan@gmail.com> wrote in message
news:4e7d0596bd138fd4ab61f19a66b0011b$1@www.eclipse.org...
> Is there any way to see more than 2 data sets in the "Expression Builder"?
>
> Here is my situation:
> I have a grid that is bound to a data set called DS0. There are two tables
> inside the grid; Table1 is bound to DS1 and Table2 is bound to DS2.
>
> From Table2 Expression Builder, only DS0 and DS2 are visible. Is there any
> way to see DS1 also?
>
> Any help is appreciated.
>
> Thanks!
> -Lillian
>

Re: using more than 2 data sets [message #61283 is a reply to message #60544]

Fri, 22 July 2005 19:32

Eclipse User

Thanks Gary.

Basically I want to modularize SQL statements into DS1 and DS2 instead of
having one LONG statement in DS2. So from Table2, I want to use some
values returned by DS1's SELECT. Is this possible? Will we be able to do
this in the next BIRT release?

Thanks,
-l.t.

Re: using more than 2 data sets [message #61736 is a reply to message #61283]

Mon, 25 July 2005 17:32

Eclipse User

This may be doable with the current BIRT release through the clever use of
scripting. You can write Javascripts for various events during Table1's
rendering (for example, the onStart(), onRow() methods etc) and save
whatever data you might need to use for Table2 in global JS variables.
regards,
Gary

"Lillian Tan" <lillian.tan@gmail.com> wrote in message
news:205d3ed111886fca42764d86b06481e3$1@www.eclipse.org...
> Thanks Gary.
>
> Basically I want to modularize SQL statements into DS1 and DS2 instead of
> having one LONG statement in DS2. So from Table2, I want to use some
> values returned by DS1's SELECT. Is this possible? Will we be able to do
> this in the next BIRT release?
>
> Thanks,
> -l.t.
>

Previous Topic:	Dynamic Font
Next Topic:	page numbers

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Oct 20 02:17:57 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter