<p>Hi,</p>
<p> </p>
<p>I use Birt since a while (10 years...), mainly for personal tools. Big thanks to Actuate for that wonderful piece of software.</p>
<p> </p>
<p>I'd like to know if it's possible to create a database table according to submitted birt parameter. I'd like to improve performances and readability of reports.</p>
<p> </p>
<p>For instance with a parameter on year, a temporary table could be :</p>
<p> </p>
<p>'create table year2014 as select customer, count(distinct product) nb_products from purchases where year =? group by customer'</p>
<p> </p>
<p>and datasets may use it :</p>
<p>dataset 1 : 'select * from year2014 where nb_products =5'</p>
<p> </p>
<p>Any advice ?</p>
<p> </p>
<p>Thank you in advance,</p>
<p> </p>
<p>Ali</p>
