nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Chart and crosstab filled with date from arrays in PGV

Adam11

Hello,
 
1. It is possilby to create char filled with date from arrays in PGV ? Ihad a crosstab when I used some scripting putting computed date into arrays and after that I wanto make chart based on date from those arrays in PGV. When I look into chart date I can only choose datesat.
 
2. It is possilby to create crosschart filled with date from arrays in PGV ? had a crosstab when I used some scripting putting computed date into arrays and after that I wanto make another crosstab filles with data from arrays in PGV.
 
I use Eclipse BIRT Designer Version 2.6.2. 
Thanks in advance for any help 
Adam

Find more posts tagged with

Comments

GLO_FR

Hi Adam,
 
I have never done that before, but I think that to do it, you have to use a Scripted Data Set.
Get the content of your variable and put it this DS.
Afterward, use this DS directly in your chart.
 
 
*** Edit ****
 
I have tested this method, it works great

Adam11

Thanks for the answer. Do you have some example ?
 
Adam

GLO_FR

Sure, here you are (done with BIRT 2.3.2).
 
I have created my variable in the beforeFactory. It is a simple array with some values.
 
First you have to create a scripted data source and a dataset
After that, in the beforeOpen event of your DS, just get your PGV and put it in an array.
Then, on the fetch event, just read your array and feed your DS.
 
At the end, use your scripted data set the way you want : chart, table.....

Adam11

Thanks a lot for the answer. Could You look at my post from<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/35477-crosstab-overwrite-value-in-cell-using-script-or-put-addtional-row/?view=getlastpost' title="Go to last post: Crosstab - overwrite value in cell using script or put addtional row"> Yesterday, 07:13 AM about overwriting value in crosstable </a>, no one make a reply to it. Thanks in advance.
 
Adam

Adam11

Hello,
 
Unfortunatelly, I have still problem with using your method. Can you help me ?
I copied your datastource and dateset to my report. And use in before Open my table from PGV (there are only numbers)
 and I change valuetype for integer in dateset.
 
Dataset (Before open)
currentRow=0; 
myArray=reportContext.getPersistentGlobalVariable("my_table_from_pgv");
 
Dateset(Fetch)
 
if (currentRow < myArray.length) { 
 row["VALUE1"] = myArray[currentRow]; 
 currentRow++; 
 return true; 
}; 
return false;
 
 
But it doesn;'t work. I have no values in preview. I use console debugging "Packages.java.lang.System.out.println(" with eclipsec and I have strange logs:
(...) Info: Crosstab javascript content registered successfully
Before adding yours dateset I have no such entries. I create my table my_table_from_pgv in such way:
In initialize:
var my_table_from_pgv = new java.util.ArrayList();
and on create cell for crosstab
my_table_from_pgv.add(reportContext.evaluate("measure"));
 
Maybe the problem is I used javacript and You use java ? Please. Any help will be appreciated.
 
Adam

GLO_FR

If your design works without any connection, can you upload it ?

Adam11

I solved my problem. I changed length function to size() in my_array and it works. Thanks a lot for help.
 
Adam,