|
| Re: dynamic data set from different table different feilds, according to parameter [message #684399 is a reply to message #684219] |
Wed, 15 June 2011 14:15   |
|
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 #684708 is a reply to message #684631] |
Thu, 16 June 2011 04:57 |
|
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.
|
|
|
|
Powered by
FUDForum. Page generated in 0.03429 seconds
] 
Search
Help
Register
Login
Home
