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

Help

Home

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

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

using more than 2 data sets [message #59617]

Mon, 18 July 2005 23:32

Lillian

Messages: 8
Registered: July 2009

Junior Member

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

Report message to a moderator

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

Thu, 21 July 2005 18:11

Gary Xue

Messages: 193
Registered: July 2009

Senior Member

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
>

Report message to a moderator

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

Fri, 22 July 2005 23:32

Lillian

Messages: 8
Registered: July 2009

Junior Member

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.

Report message to a moderator

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

Mon, 25 July 2005 21:32

Gary Xue

Messages: 193
Registered: July 2009

Senior Member

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.
>

Report message to a moderator

Previous Topic:	Dynamic Font
Next Topic:	page numbers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 19:00:06 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter