Aggregated values in a "?" sql parameter

egau

Hi,

Here is my problem:

I have a aggregation on data which make that kind of result :

'1234','4567','.... etc.

In data set, I have this request :

select <stuff> from <table> WHERE id_metric IN (?)

so as you understand, I would like to insert this aggregated values with a parameter in the "IN", so it replace the ? by the value and it looks like

select <stuff> from <table> WHERE id_metric IN ('1234','4567','.... ) and it select the good values in the table regarding conditions.

If someone has an idea, I ll appreciate.

Regards

mwilliams

Hi egau,<br />
<br />
You can build the IN portion of your query in the dataSet's beforeOpen script.<br />
<br />
This post from the devShare may help.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/535-using-in-like-clause-in-birt/#description'>Using IN/LIKE Clause in BIRT - Tutorials - BIRT Exchange</a>