Filtering a dataset in a dynamic text

Hi all,

In a report, I would like to have table header labels in different language based on a report parameter.
I know that we can use ressource files to deal with multilingual content but in my case it is not possible.
I'm retrieving the translated labels within a dataset with such structure:
label_code | translated_label
LABEL_1 | The label 1
LABEL_2 | The label 2
...

My probleme is that we cannot have a table placed in a table header cell.
I tried to do it with a dynamic text but I don't know how to filter the dynamic text with the label_code.

Any suggestion would be appreciate.

Find more posts tagged with

Comments

thuston

<blockquote class='ipsBlockquote' data-author="'slievain'" data-cid="70116" data-time="1289309326" data-date="09 November 2010 - 06:28 AM">
My probleme is that we cannot have a table placed in a table header cell. </blockquote>
Why not? 
If your translation data needs to be queried for, a Table or a Grid is probably the best way to get it.

slievain

Thank you thuston for your response. 
 
<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="70120" data-time="1289313199" data-date="09 November 2010 - 07:33 AM">
Why not? </blockquote>
 
Because the BIRT Designer doesn't allow the user to drop a table in a table header cell. 
 
<blockquote class='ipsBlockquote' data-author="'thuston'" data-cid="70120" data-time="1289313199" data-date="09 November 2010 - 07:33 AM">
If your translation data needs to be queried for, a Table or a Grid is probably the best way to get it. </blockquote>
 
As I said before I cannot use a table and a grid ahs no filtering capability.

slievain

Hi all,

Another solution that pops in mind is to create persistentvariables during the dataset onFetch event and to use these variables in my table.
The problem however is that we need the dataset to be run ones to create the variable.
Creating a table binded to the dataset and hiding it is not acceptable.

Does anyone knows how to trigger the refresh of a dataset within a script??

Thanks in advanced

stephou85

Hi all, 
 
slievain, I have the same problem, have you find a simpler way of filtering a data set binded to an dynamic text ? 
It really sucks that filtering option is only available at a data set or table level. 
 
Thx in advance if anyone has a solution 
 
<blockquote class='ipsBlockquote' data-author="'slievain'" data-cid="70123" data-time="1289316073" data-date="09 November 2010 - 08:21 AM">
Hi all, 
 
Another solution that pops in mind is to create persistentvariables during the dataset onFetch event and to use these variables in my table. 
The problem however is that we need the dataset to be run ones to create the variable. 
Creating a table binded to the dataset and hiding it is not acceptable. 
 
Does anyone knows how to trigger the refresh of a dataset within a script?? 
 
Thanks in advanced </blockquote>