<p>Hello everyone,</p>
<p> </p>
<p>I am now working on a report which acts a drill-through from a main report page(Hyper-linked). This report contains multiple datasets (about 14) and each dataset has a table. Out of these datasets only 2 datasets at any given time are needed based on the parameter that is being passed from the main report while the user clicks the hyper-link. I have included a specific parameter unique to each dataset which is checked in all of the queries and I assume only that relevant dataset runs every time. I am not sure if my understanding is correct or not. I would like to learn how BIRT works when there are multiple datasets.</p>
<p> </p>
<p>I am sure my report takes very long time to display the results although the queries execute faster separately. Please let me know if there is a way to reduce the run time of this report.</p>
<p> </p>
<p><em>Note: I had to create multiple datasets because the no of columns that are selected in each of these queries vary and hence I was unable to use property binding feature to choose the query based on the parameter selection.</em></p>
<p> </p>
<p>Thanks</p>
<p>Neel</p>
