How to populate array dynamically from BIRT Dataset and store array in reportContext PGV

[font="calibri;"]Hi,[/font] [font="calibri;"]I am working on BIRT v2.6.1 (open source reporting tool from eclipse) and I have the following requirement:[/font] [font="calibri;"]I have to populate an array dynamically based on the data retrieved from one â€œBIRT Data Setâ€ and once the array is populated, I need to store the array in the â€œreportcontextâ€ as a PersistentGlobalVariable.[/font][font="calibri;"]And in another â€œBIRT Data Setâ€, I have to retrieve the array from the â€œreportcontextâ€ using â€œ[color=rgb(75,172,198);]reportContext.getPersistentGlobalVariable("myArray");â€[/color][/font] [font="calibri;"]This is what I have done:[/font][font="calibri;"]I have a dataset named [color=rgb(75,172,198);]â€œLibrary Data Setâ€.[/color][/font] The query for the dataset is [color=rgb(75,172,198);]â€œSELECT LIBRARY_ID FROM TABLE1â€.[/color]<ul class='bbc'><li>[font="calibri;"]In the â€œLibrary Data Setâ€->beforeOpen event, I have written the following code:[/font]</li></ul>[color=rgb(75,172,198);][font="calibri;"]idx=0;[/color][/font][color=rgb(75,172,198);][font="calibri;"]myArray=[];[/color][/font]<ul class='bbc'><li>[font="calibri;"]In the â€œLibrary Data Setâ€->onFetch event, I have written the following code:[/font]</li></ul>[color=rgb(75,172,198);][font="calibri;"]myArray[idx++] = row["LIBRARY_ID"];[/color][/font]<ul class='bbc'><li>[font="calibri;"]In the â€œLibrary Data Setâ€->beforeClose event, I have written the following code:[/font]</li></ul>[color=rgb(75,172,198);][font="calibri;"]reportContext.setPersistentGlobalVariable("myArray",myArray);[/color][/font] [font="calibri;"]But it I not working. [/font] [font="calibri;"]Could anyone kindly help me in this regard?[/font]

Find more posts tagged with

Comments

micajblock

What is the business requirement you are trying to fulfill? Why do you need to fill a data set with values form another data set?

sarmistha_birt

Hi, Many thanks for responding. The requirement is to display the data from ALL Libraries in one single report. Now in database, the table name for each library is like "TABLE_<LibrayNumber>". So baically I will have to do a UNION of all tables. For example if there are 5 libraries in the database in the LIBRARY_MASTER table, then the report query to display the data would be something like this: SELECT * FROM TABLE_1UNIONSELECT * FROM TABLE_2UNIONSELECT * FROM TABLE_3UNIONSELECT * FROM TABLE_4UNIONSELECT * FROM TABLE_5 So I have created 2 Data Sets. 1. Library Data Set (SELECT LIBRARY_ID FROM LIBRARY_MASTER). I want to populate an array dynamically with all the LIBRARY_ID fetched from database and then want to store the array in the PGV. 2. Result Data Set In the beforeOpen script, I am trying to retrieve the library array from PGV. I have written a for loop to traverse through the library array and here dynamically i am trying to create the UNION query. Hope I am able to explain it clearly. Thanks,Sarmistha

micajblock

I don't think you need a persistent global variable. The issue might be that the first data set never gets executed. If there is no table that uses it, BIRT will not execute the data set. try creating a table (which you can hide) for the first data set). You can use regular variables. Maybe this video of the order of events will help you understand.

https://www.youtube.com/watch?v=FQ9VjByPNWM

sarmistha_birt

Actually the Library dataset is getting executed. I am saying this because the same library data set is being used in the list box that I have for one of the report input parameters.
The library id report input parameter is a list box which fetches the library ids using the library data set and I am able to see all library ids in that drop down.

Pulak Bose

You might want to change the array to an arraylist and check whether it works. Refer to this thread, to get an understanding of the PGV and the related events. <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/20312-set-and-get-persistentglobalvariable/'>http://developer.actuate.com/community/forum/index.php?/topic/20312-set-and-get-persistentglobalvariable/</a>

sarmistha_birt

Hi Pulak,
Could you kindly let me know on which event I should write the code to populate the arraylist.also could you kindly share the syntax.i have tried all options but it is still not working. Kindly help.thanks

sarmistha_birt

I have observed that report context is not accessible in any of the data set events (onfetch,beforeOpen,beforeClose etc.). Could anyone kindly help me in resolving my issue. I want to populate an arraylist dynamically in the onfetch event of a datasst.

Would appreciate your kind help.

Pulak Bose

You can bind the dataset to a table and hide the table. Create your dynamic query in the onCreate of the table row.