Eclipse Community Forums: BIRT » dynamic data set from different table different feilds, according to parameter

Home » Archived » BIRT » dynamic data set from different table different feilds, according to parameter

dynamic data set from different table different feilds, according to parameter [message #684219]

Wed, 15 June 2011 04:49

Eclipse User

Hi,
I just start BIRT so might get some wrong way. And this might sounnds a common question here.

I would like to fetch different feilds from different table according to one parameter's value.

Say if parameter value is "Apple", I would do query:

select taste from table_fruit;

if parameter value is "Rice", I would do query:

select protein from table_grain;

I knew I can do something in data set "beforeOpen" to replace string. But how can I control both the table name and the field name with one parameter? I am sure there are plenty of solution for this thing.

Thanks.

Re: dynamic data set from different table different feilds, according to parameter [message #684399 is a reply to message #684219]

Wed, 15 June 2011 10:15

Eclipse User

Do table_fruit and table_grain have the same number of columns and
column types? In the before open you can check any report parameter and
set the query to whatever you want

if( params["food"].value == "Apple" ){
this.queryText = "select * from table_fruit";
}else{
this.queryText = "select * from table_grain";
}

The only issue is that both tables have to have the same column metadata
or you will get an error.

Jason

On 6/15/2011 4:49 AM, forums-noreply@eclipse.org wrote:
> Hi,
> I just start BIRT so might get some wrong way. And this might sounnds a
> common question here.
>
> I would like to fetch different feilds from different table according to
> one parameter's value.
> Say if parameter value is "Apple", I would do query:
>
> select taste from table_fruit;
>
> if parameter value is "Rice", I would do query:
>
> select protein from table_grain;
>
>
> I knew I can do something in data set "beforeOpen" to replace string.
> But how can I control both the table name and the field name with one
> parameter? I am sure there are plenty of solution for this thing.
> Thanks.
>
>

Re: dynamic data set from different table different feilds, according to parameter [message #684631 is a reply to message #684399]

Wed, 15 June 2011 20:17

Eclipse User

Thanks for the info. The issue came the two tables have different column numbers and name. According to param, the data set need to select different column from different table, but give same output. For example, choose "taste" (string) from table "fruit", and choose "protein" (string) from table "grain". Is it possible?

Alternatively, I can do it in another way.

Say I have a list item in report, how can I bind it to different data set according to param's value? Thanks.

Re: dynamic data set from different table different feilds, according to parameter [message #684708 is a reply to message #684631]

Thu, 16 June 2011 00:57

Eclipse User

You could always create two datasets and add two tables to the report
and then use the parameter to drop one of them. for Example name the
two tables in their general properties to table1 and table2. Then in
the beforeFactory do this:

if( params["type"].value == fruit ){
reportContext.getDesignHandle().findElement("table1").drop();
}else{
reportContext.getDesignHandle().findElement("table2").drop();
}

You could always write de-api to change the column data in a script but
it will be more code than the above approach.

Jason

On 6/15/2011 8:17 PM, forums-noreply@eclipse.org wrote:
> Thanks for the info. The issue came the two tables have different column
> numbers and name. According to param, the data set need to select
> different column from different table, but give same output. For
> example, choose "taste" (string) from table "fruit", and choose
> "protein" (string) from table "grain". Is it possible?
> Alternatively, I can do it in another way.
>
> Say I have a list item in report, how can I bind it to different data
> set according to param's value? Thanks.

Re: dynamic data set from different table different feilds, according to parameter [message #685216 is a reply to message #684708]

Thu, 16 June 2011 23:39

Eclipse User

Thank you for that, Jason.

Previous Topic:	How to retrieve ResultSet metadata in script
Next Topic:	Drill-Through

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 12 15:18:42 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter