Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Alternate Table Views
Alternate Table Views [message #368345] Fri, 22 May 2009 14:31 Go to next message
Mitch Christensen is currently offline Mitch ChristensenFriend
Messages: 35
Registered: July 2009
Member
Hey,

I need to create to separate tables that are driven from the same Data
Set. I will only ever display one or the other, and I would like to avoid
executing the SQL query twice even though I only consume the result set
once.

It seems that I've seen this before, but I can't find it.

Is there a way to disable/delete a table such that it doesn't display and
doesn't cause the Data Set to re-execute the SQL query?

Thanks.
-Mitch Christensen
Re: Alternate Table Views [message #368348 is a reply to message #368345] Fri, 22 May 2009 14:38 Go to previous message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Mitch,

Are you basing which table is displayed by a report parameter?
If so you can name both tables (General Property) and then in the
beforeFactory event just drop the one you do not need.

//bool param
if( params["droptable"].value ){
reportContext.getDesignHandle().findElement("mytable").drop();
}

Jason


Mitch Christensen wrote:
> Hey,
>
> I need to create to separate tables that are driven from the same Data
> Set. I will only ever display one or the other, and I would like to
> avoid executing the SQL query twice even though I only consume the
> result set once.
>
> It seems that I've seen this before, but I can't find it.
>
> Is there a way to disable/delete a table such that it doesn't display
> and doesn't cause the Data Set to re-execute the SQL query?
>
> Thanks.
> -Mitch Christensen
>
Previous Topic:Change logs?
Next Topic:Nested TOC Entries
Goto Forum:
  


Current Time: Fri Apr 19 21:35:26 GMT 2024

Powered by FUDForum. Page generated in 0.03108 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top