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; } } }

Dataset results to be used in report script

nikodem38

Hi,

I want to use the result of a dataset to create a grid
I put the results of the dataset in an array and pass it to a global variable which is initialized in the 'initialize' script tab of the report:
mylist=new Array();
reportContext.setGlobalVariable("alist",mylist);

Now I need to use this global variable in order to create a grid, values of the variable being part of the grid cells.

For that, in the 'beforeFactory' script tab of the report, I wrote:
dslist=reportContext.getGlobalVariable('alist');

But dslist is empty

Please help

Find more posts tagged with

Comments

kclark

Why don't you just make a table on your report and drag the data you need from the dataset to it? Is there something specific you are trying to do that you need scripting for?

nikodem38

<blockquote class='ipsBlockquote' data-author="'kclark'" data-cid="110153" data-time="1349374819" data-date="04 October 2012 - 11:20 AM">
Why don't you just make a table on your report and drag the data you need from the dataset to it? Is there something specific you are trying to do that you need scripting for? </blockquote>
 
The grid I want to create is a calendar with months as columns and days as rows. 
the result of the dataset gives a column of names and a column of dates. 
I want to put these names in the correct grid cells depending on the dates values. 
 
In the report script tab, I try to execute the query of the dataset to get the results. 
 
here is the code for executing the dataset: 
var myconfig=reportContext.getReportRunnable().getReportEngine().getConfig(); 
var des=DataRequestSession.newSession(myconfig,new DataSessionContext(1)); var dsrc=reportContext.getDesignHandle().findDataSource("MPW3DB"); 
var dset=reportContext.getDesignHandle().findDataSet("TEST"); 
des.defineDataSource(des.getModelAdaptor().adaptDataSource(dsrc)); 
des.defineDataSet(des.getModelAdaptor().adaptDataSet(dset)); 
 
queryDefinition=new QueryDefinition(); 
queryDefinition.setDataSetName("TEST"); 
 
var pq=des.prepare(queryDefinition); 
var qr=pq.execute(null); 
var ri=qr.getResultIterator(); 
var rsmd=ri.getResultMetaData(); 
var countrow=-1; 
var listmp=new Array(); 
while (ri.next()) { 
countrow++; 
listmp[countrow]=ri.getValue(rsmd.getColumnName(1)); 
} 
ri.close(); 
qr.close(); 
des.shutdown(); 
 
 
When I execute it, I get the following error message: 
"Wrapped org.eclipse.birt.data.engine.core.DataException: In generation or presentation, report archive can not be null."