<p>I am developing a scripted data source based report , which has 3 tables ,</p>
<p> </p>
<p>first table is the master of second table , will have only one row.</p>
<p> </p>
<p>second table is master of third table will have maximum of 10 rows.</p>
<p> </p>
<p>third table will have more then 30 rows.</p>
<p> </p>
<p>I want to list them to one after another [independently] as shown below.</p>
<p> </p>
<p>TABLE 1 ROWS</p>
<p> </p>
<p>TABLE 2 ROWS</p>
<p> </p>
<p>TABLE 3 ROWS</p>
<p> </p>
<p>I am using JSON object to load tables in the fetch method.</p>
<p> </p>
<p>I am facing following problems.</p>
<p> </p>
<p>1) open method is called 3 times , hence , my client code is called 3 times ,making 3 server call and this slows the report by loading same data again and again. How can I make sure that open method is called only once for the 3 tables ?</p>
<p> </p>
<p>2) to solve the above problem , I tried to create 3 separate data sets and datasources for each table , But BIRT allowing me to drag columns from only one data set for all the 3 tables , how can load 3 tables independent of each other ?</p>
<p> </p>
<p>your earlier reply appreciated.</p>
