Exception while using scripting datasource

Hi, 
 
I have just started to use BIRT and stuck in some issues. 
 
I am trying to use the scripted datasource for a report and the script in the following 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>reportsUtil = new Packages.org.****.rest.util.ReportsUtil();
reportsVO = reportsUtil.getReportVO("ABC");</pre>
 
it works fine with Eclipse but when i run it from Java code,(i am making a REST call to it), it gives the following error... 
 
WARNING: Fail to execute script in function __bm_OPEN(). Source:

" + reportsUtil = new Packages.org.****.rest.util.ReportsUtil(); 
reportsVO = reportsUtil.getReportVO("ABC"); + "

A BIRT exception occurred. See next exception for more information. 
Error evaluating Javascript expression. Script engine error: TypeError: [JavaPackage org.****.rest.util.ReportsUtil] is not a function, it is object. (/report/data-sets/script-data-set[@id="8"]/me 
thod[@name="open"]#1) 
Script source: /report/data-sets/script-data-set[@id="8"]/method[@name="open"], line: 0, text: 
__bm_OPEN() 
org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_OPEN(). Source:

" + reportsUtil = new Packages.org.csmc.rdr.rest.util.ReportsUtil(); 
reportsVO = reportsUtil.getReportVO("ABC"); + "

A BIRT exception occurred. See next exception for more information. 
Error evaluating Javascript expression. Script engine error: TypeError: [JavaPackage org.csmc.rdr.rest.util.ReportsUtil] is not a function, it is object. (/report/data-sets/script-data-set[@id="8"]/me 
thod[@name="open"]#1) 
Script source: /report/data-sets/script-data-set[@id="8"]/method[@name="open"], line: 0, text: 
__bm_OPEN() 
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147) 
 
......... 
......... 
......... 
 
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) 
at java.lang.Thread.run(Thread.java:619) 
Caused by: org.eclipse.birt.data.engine.core.DataException: Data Set script method "Fetch" returned null; expected a Boolean value. 
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:150) 
... 79 more 
Aug 1, 2011 6:34:12 PM org.eclipse.birt.report.engine.layout.pdf.font.FontMappingManagerFactory loadFontMappingConfig 
INFO: load font config in jar:file:/C:/Program%20Files%20(x86)/Apache%20Software%20Foundation/apache-tomcat-6.0.20/shared/lib/org.eclipse.birt.runtime_3.7.0.v20110615-1818.jar!/fontsConfig.xml cost 32 
 
 
This is how i am initializing the BIRT engine 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>public class BIRTEngineFactory {

private static IReportEngine reportEngine = null;

private static Logger logger = Logger.getLogger(BIRTEngineFactory.class);

public static synchronized IReportEngine getReportEngine() {
if (reportEngine == null)
createEngineInstance();
return reportEngine;

}

private static void createEngineInstance() {
EngineConfig engineConfig = new EngineConfig();
//engineConfig.setEngineHome(DEFAULT_BIRT_HOME_PATH);

try {
logger.info("initializing the BIRT engine");
Platform.startup(engineConfig);
logger.info("initializing the BIRT engine");
} catch (BirtException e) {
e.printStackTrace();
throw new UnrecoverableException("Exception while starting engine");
}

IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);

reportEngine = factory.createReportEngine(engineConfig);
/*HashMap contextMap = new HashMap();
contextMap.put(EngineConstants.APPCONTEXT_CLASSLOADER_KEY, ReportsUtil.class.getClassLoader());
reportEngine.getConfig().setAppContext(contextMap);*/
}

public static synchronized void destroyReportEngine() {
if(reportEngine == null) {
return ;
}

reportEngine.destroy();
Platform.shutdown();
reportEngine = null;
}</pre>
 
 
This is how it is being called. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>@GET
@Path("/{reportTemplateId}/report")
public Response generateReport(@PathParam("reportTemplateId") long reportTemplateId) {
logger.info("generateReport()" + reportTemplateId);
String template = getRequestParameter("template");
IReportRunnable design = null;
IRunAndRenderTask task = null;
PDFRenderOption options = null;
try {
//design = engine.openReportDesign("C:/test/reports/saved_subject_design.rptdesign"); //report is needed in this folder
design = engine.openReportDesign("C:/Project/rdrrest/trunk/src/"+template+".rptdesign"); //report is needed in this folder

} catch (Exception e) {
throw new UnrecoverableException("An error occured during the opening of the report file!");
}

task = engine.createRunAndRenderTask(design);
task.setAppContext(engine.getConfig().getAppContext());
//task.setParameterValue("EntityIdListString", params);

//Set parameter values and validate, if the report requires it
//task.setParameterValue("Years", 2.0);
//task.validateParameters();

//options = new HTMLRenderOption();

options = new PDFRenderOption();
ByteArrayOutputStream ostream = new ByteArrayOutputStream();
options.setOutputStream(ostream);
options.setOutputFormat("pdf");
task.setRenderOption(options);
try {
task.run();
} catch (Exception e) {
System.err.println("An error occured while running the report!");
e.printStackTrace();
}

byte[] bytes = ostream.toByteArray();
return Response.ok(bytes, MediaType.APPLICATION_OCTET_STREAM).header("Content-Disposition", "reportDesign" + reportTemplateId).build();
}</pre>
 
 
 
Can someone help me out please in it.. 
 
Thanks a lot. 
 
Tuco

Find more posts tagged with

Comments

mwilliams

It's having an issue with the ReportsUtil() call. Does calling this in your java editor work? BIRT is telling you that it's not a function that it's just an object. There is also an issue in your fetch script where BIRT is expecting a boolean value. This may be caused by the first error though. What is ReportsUtil() supposed to do?

Tuco

Thanks Michael, 
 
Here's what my ReportsUtil looks like. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>public class ReportsUtil {

public ReportVO getReportVO(String string) {
ReportVO reportVO = new ReportVO();

// some how use the string to populate the map
reportVO.addPropValue("identity.FirstName", "Tuco");

return reportVO;
}
}
</pre>
 
 
Here's the code in fetch script 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>dataSetRow["FirstName"] = reportsVO.getPropValue("identity.FirstName");
return true;</pre>
 
 
I managed to get over the error but now the task does run but it does not produce any output..and the pdf is not generated. 
 
It seems that the thread is just stuck after the "task.run()" and does not come out of it, nor does it raise any exception. 
 
What could be the problem? 
 
Thanks a lot. 
 
Tuco

mwilliams

Is that the entire fetch script? If so, you'll never get your results because the fetch won't end. You need to return false to end. You'll have determined the length of your object in your open script and you'll iterate through it in your fetch script, returning true each time there's another value and returning false when you reach the object size.

Tuco

Thanks mwilliams,

Thanks a lot, that should be it..

I am not displaying a list of items, i am instead returning a HashMap from the Java code which will have property Values, and that should be called only once.

Thanks

Tuco

mwilliams

You will call the java once in the open to create your hash map. You'll find the size of the hashmap in the open as well. You'll then iterate through it returning true for each row. When you reach the size of the hashmap in your iteration, you'll then return false. Try that and let me know.

Tuco

Hi mwilliams.

I am somewhat confused.

My report does not contain any rows but contains dynamic text, and where i need to get some variable.

Ex, The report will be

"Person {FirstName} {LastName} lives in this place.....etc etc"

So, what my map returned from the Java code is the map of FirstName Vs Tuco, LastName Vs LastName.....etc etc...

do i still need to set the parameters like i am setting like "dataSetRow["FirstName"] = map.get(identity.FirstName)" or i am doing something wrong like this.

Does datasetRow["FirstName"] works for each row?(because i don't have to show a row based report, its just a free form text with some variables, which the Map will contain).

Thanks a lot for the help...

Tuco

mwilliams

Ok. Even with a single row, you'll grab all the values from the "person"....firstname, lastname, etc with something like:

open:
//connect to java to bring in hash map object
totalrows = 1; //since you're saying you have only one row.
currentRow = 0;

fetch;
if (currentRow < totalrows){
row["firstname"] = reportsVO.getPropValue("identity.FirstName");
etc.
currentRow++;
return (true); //this will return true to define the row
}
else{
return (false); //this will return false to end fetch
}

Tuco

Thanks mwilliams, 
 
That did solve the problem and i am not getting the error but i am not sure how to display the data. 
 
I have to show a dynamic text in the report but unfortunately all the tutorials on the internet are related to row data. 
 
Like you described Here's what is in my open script of the dataset 
open of dataset : 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>util = new Packages.org.***rest.util.ReportsUtil();
reportsVO = util.getReportVO("ABC");

totalrows = 1;
currentrow = 0;
</pre>
 
 
And in the fetch of dataset. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>if(currentrow < totalrows) {
dataSetRow["FirstName"] = reportsVO.getPropValue("identity.FirstName");
dataSetRow["LastName"] = reportsVO.getPropValue("identity.LastName");

currentrow++;
} else {
return (false);
}</pre>
 
As a starting point, I am trying to print the firstName and LastName on the report. 
How do i get the reference to firstName and lastName on the layout of the report. 
I am trying to go to the layout and add a dynamic text? Do i need to add a dynamic text? How do i get reference to the firstName and lastName? 
 
Or If you could point me to a tutorial for such a non row based report, that would be great... 
 
Thanks a zillion... 
 
Tuco.

Tuco

Hi Michael, 
 
I need to display the firstName and lastName on the free form report like. 
 
Report should look like 
 
Name: Tuco Ramirez Some Other Info in the same line.... 
Some Other dynamic Info.... 
..... 
.... 
 
I tried adding a new dynamic element but it gives the following error from Eclipse only when i add the dynamic element. If i remove the dynamic element, it does not give error, but does not show the name of the report. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>The following items have errors:

ReportDesign (id = 1):
+ There are errors evaluating script "if(currentrow < totalrows) {
dataSetRow["FirstName"] = reportsVO.getPropValue("identity.FirstName");
dataSetRow["LastName"] = reportsVO.getPropValue("identity.LastName");

currentrow++;
} else {
return (false);
}":
Fail to execute script in function __bm_FETCH(). Source:

" + if(currentrow < totalrows) {
dataSetRow["FirstName"] = reportsVO.getPropValue("identity.FirstName");
dataSetRow["LastName"] = reportsVO.getPropValue("identity.LastName");

currentrow++;
} else {
return (false);
} + "

A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: ReferenceError: "currentrow" is not defined. (/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"]#1)
Script source: /report/data-sets/script-data-set[@id="8"]/method[@name="fetch"], line: 0, text:
__bm_FETCH(). (Element ID:1)
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:99)
at org.eclipse.birt.report.engine.script.internal.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:246)
at org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:140)
at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataSet.fetch(PreparedScriptDSQuery.java:260)
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:105)
at org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:316)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285)
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246)
at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:73)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:110)
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.doSinglePass(PassManager.java:211)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:94)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:125)
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)
at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:198)
at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:195)
at org.eclipse.birt.data.engine.executor.CandidateQuery.execute(CandidateQuery.java:106)
at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor.executeOdiQuery(PreparedScriptDSQuery.java:226)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1495)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:173)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1897)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.DynamicTextItemExecutor.execute(DynamicTextItemExecutor.java:77)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:929)
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)
at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.eclipse.birt.data.engine.core.DataException: Fail to execute script in function __bm_FETCH(). Source:

A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: ReferenceError: "currentrow" is not defined. (/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"]#1)
Script source: /report/data-sets/script-data-set[@id="8"]/method[@name="fetch"], line: 0, text:
__bm_FETCH()
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)
at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)
... 86 more
Caused by: org.eclipse.birt.data.engine.core.DataException: A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: ReferenceError: "currentrow" is not defined. (/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"]#1)
Script source: /report/data-sets/script-data-set[@id="8"]/method[@name="fetch"], line: 0, text:
__bm_FETCH()
at org.eclipse.birt.data.engine.core.DataException.wrap(DataException.java:123)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1005)
at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:138)
... 87 more
Caused by: org.eclipse.birt.core.exception.CoreException: Error evaluating Javascript expression. Script engine error: ReferenceError: "currentrow" is not defined. (/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"]#1)
Script source: /report/data-sets/script-data-set[@id="8"]/method[@name="fetch"], line: 0, text:
__bm_FETCH()
at org.eclipse.birt.core.script.JavascriptEvalUtil.wrapRhinoException(JavascriptEvalUtil.java:303)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:102)
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateScript(JavascriptEvalUtil.java:134)
at org.eclipse.birt.data.engine.script.ScriptEvalUtil.evaluateJSAsExpr(ScriptEvalUtil.java:1001)
... 88 more
Caused by: org.mozilla.javascript.EcmaError: ReferenceError: "currentrow" is not defined. (/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"]#1)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3654)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3632)
at org.mozilla.javascript.ScriptRuntime.notFoundError(ScriptRuntime.java:3717)
at org.mozilla.javascript.ScriptRuntime.nameOrFunction(ScriptRuntime.java:1758)
at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1697)
at org.mozilla.javascript.gen.c81._c1(/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"]:1)
at org.mozilla.javascript.gen.c81.call(/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"])
at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:108)
at org.mozilla.javascript.gen.c10._c0(/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"]:0)
at org.mozilla.javascript.gen.c10.call(/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"])
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)
at org.mozilla.javascript.gen.c10.call(/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"])
at org.mozilla.javascript.gen.c10.exec(/report/data-sets/script-data-set[@id="8"]/method[@name="fetch"])
at org.eclipse.birt.core.script.JavascriptEvalUtil.evaluateRawScript(JavascriptEvalUtil.java:95)
... 90 more

+ Data Set script method "Fetch" returned null; expected a Boolean value. (Element ID:1)</pre>
 
 
Here is what i have done. 
 
Subject_report.rptdesign file. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'><?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602 Build <3.7.0.v20110607-1526></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<data-sources>
<script-data-source name="mydatasource" id="7"/>
</data-sources>
<data-sets>
<script-data-set name="mydataset" id="8">
<list-property name="resultSetHints">
<structure>
<property name="position">0</property>
<property name="name">FirstName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">1</property>
<property name="name">LastName</property>
<property name="dataType">string</property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">FirstName</property>
<text-property name="displayName">FirstName</text-property>
</structure>
<structure>
<property name="columnName">LastName</property>
<text-property name="displayName">LastName</text-property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">FirstName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LastName</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">mydatasource</property>
<method name="open"><![CDATA[util = new Packages.test.ReportsUtil();
reportsVO = util.getReportVO("ABC");

]]></method>
<method name="fetch"><![CDATA[if(currentrow < totalrows) {
dataSetRow["FirstName"] = reportsVO.getPropValue("identity.FirstName");
dataSetRow["LastName"] = reportsVO.getPropValue("identity.LastName");

currentrow++;
} else {
return (false);
}]]></method>
</script-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<text-data id="13">
<property name="dataSet">mydataset</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">FirstName</property>
<text-property name="displayName">FirstName</text-property>
<expression name="expression" type="javascript">dataSetRow["FirstName"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">LastName</property>
<text-property name="displayName">LastName</text-property>
<expression name="expression" type="javascript">dataSetRow["LastName"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<expression name="valueExpr">row["FirstName"]</expression>
<property name="contentType">html</property>
</text-data>
</body>
</report>
</pre>
 
ReportsUtil.java 
<pre class='_prettyXprint _lang-auto _linenums:0'>package test;

public class ReportsUtil {

public ReportVO getReportVO(String string) {
ReportVO reportVO = new ReportVO();

reportVO.addPropValue("identity.FirstName", "Tuco");
reportVO.addPropValue("identity.LastName", "Ramirez");

return reportVO;
}
}
</pre>
 
ReportVO.java 
<pre class='_prettyXprint _lang-auto _linenums:0'>package test;

import java.util.HashMap;
import java.util.Map;

public class ReportVO {

private Map<String, Object> propValuesMap = new HashMap<String, Object>();

public Map<String, Object> getPropValuesMap() {
return propValuesMap;
}

public void setPropValuesMap(Map<String, Object> propValuesMap) {
this.propValuesMap = propValuesMap;
}

public void addPropValue(String propName, Object value) {
propValuesMap.put(propName, value);
}

public Object getPropValue(String propName) {
return propValuesMap.get(propName);
}
}
</pre>
 
Can you please help me out? 
 
Thanks a lot. 
 
Tuco

Tuco

Can anyone help me out here please?

Thank you.

mwilliams

Sorry for the delay, I was off yesterday to attend a funeral. If you choose "preview results" in your dataSet, do you see the data as expected?

Tuco

I am sorry for you loss, Michael,

No i cannot see the data in "preview results".

mwilliams

So, there is still an issue with the dataSet then. It looks like you're not defining "currentrow" in your dataSet's open script. That's the first error. Make sure you define currentrow as 0 and totalRows as 1, since you only have one row.

Tuco

Hi Michael, 
 
I add the following to the open script. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
util = new Packages.test.ReportsUtil();
reportsVO = util.getReportVO("ABC");

currentrow = 0;
datasetRow = 1;</pre>
 
 
But still i don't see anything in the preview results. 
 
I am not sure whether we have only one row in the dataset. This is because the final report could be 
 
 
" The Patient {FirstName} {LastName} ...........some static text.................. 
..............with phone No {phoneNumber} ...................some other static or dynamic info................ 
" 
 
So, the dataset returns a HashMap which contains FirstName, LastName, phoneNumber and other fields as keys and their values as corresponding values. 
 
However, the Java code returning the dataset(HashMap is this case) containing the keyValue pair of FirstName, LastName, phoneNo etc. 
 
So, although row["FirstName"] will be valid for the first row, it will not be valid for the second or any other row because the report requires "FirstName" only in the first row. So, i am not sure what should be written in the fetch script. 
 
Probably we could have all the firstName, LastName, phoneNo as parameters and fetch the Map dataset only once, and set the above FirstName, LastName parameters in the fetch script instead of setting the row["FirstName"], row["LastName"] etc. Is there a way to set the value of parameters in the fetch script? 
 
 
Thanks a lot. 
 
Tuco

Tuco

Hi Michael, 
 
It looks like i was missing the return true in the fetch script. 
 
After that it seems to work great.. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>if(currentrow < totalrows) {
dataSetRow["FirstName"] = reportsVO.getPropValue("identity.FirstName");
dataSetRow["LastName"] = reportsVO.getPropValue("identity.LastName");

currentrow++;
return (true);
} else {
return (false);
}</pre>
 
 
Thanks a ton!!!

mwilliams

Great. Glad to help. Let us know whenever you have questions!