<p>Hi All,</p>
<p> I am new to BIRT world and need a design help from experts. I have three tables without common columns such as TABLE AB, TABLE BC, TABLE CD and have the following report parameters.</p>
<p> </p>
<p>param_DATE:- each table has Date column.</p>
<p>param_TYPE- SALES,MARKETING, FINANCE </p>
<p>param_REGION- AB,BC,CD</p>
<p> </p>
<p>So,whenver we select AB in Region and SALES/MKT/FIN with a DATE, data is pulled from AB tables.</p>
<p> When we select BC in Region and SALES/MKT/FIN with DATE , data is pulled from BC tables.</p>
<p> When select CD in Region and SALES/MKT/FIN with DATE , data is pulled from CD tables.</p>
<p> </p>
<p>How we ca achieve this in one report.</p>
<p> </p>
<p>Thanks,</p>
<p> </p>
<p>Andy.</p>
