BIRT Multiple table in single report using scripted data source

I am developing a scripted data source based report , which has 3 tables ,
 
first table is the master of second table , will have only one row.
 
second table is master of third table will have maximum of 10 rows.
 
third table will have more then 30 rows.
 
I want to list them to one after another [independently] as shown below.
 
TABLE 1 ROWS
 
TABLE 2 ROWS
 
TABLE 3 ROWS
 
I am using JSON object to load tables in the fetch method.
 
I am facing following problems.
 
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 ?
 
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 ?
 
your earlier reply appreciated.

Find more posts tagged with

Comments

Clement Wong

Do your tables use the same data?
 
If so, yes, you can use your scripted data source for your JSON for the first table. In the Fetch method, save off the values you need into an array.
 
Now, create a new simple scripted data source and loop through the array to fetch the values for the 2nd and 3rd table.

muthuvel

Dear Wong,
 
 thanks for your reply !.
 
 I have used separate data-set for each table and each data-set has it own open ,fetch and close method.it is working fine now.

Clement Wong

Glad to hear it's working.