Problem with reading row data to a persistent variable

kkan · 2011-07-11T07:53:32+00:00

HI Am i trying to set a global variable with column value from a dataset. This dataset is an xml file. in "onFetch" event of Dataset I have these statements reportContext.setPersistentGlobalVariable("testglobal", row.getColumnValue("orderCount").toString()) and in…

kkan

HI 
 
Am i trying to set a global variable with column value from a dataset. This dataset is an xml file. 
 
in "onFetch" event of Dataset I have these statements 
 
 
reportContext.setPersistentGlobalVariable("testglobal", row.getColumnValue("orderCount").toString()) 
 
and in a dynamic text object i have this as the expression: 
 
displayname=parseInt(reportContext.getPersistentGlobalVariable("testglobal")); 
 
and I get this error which i do not understand what i am doing worng?!! please someone help: 
 
Thanks in advance 
 
The following items have errors: 
 
 
ReportDesign (id = 1): 
+ There are errors evaluating script " 
reportContext.setPersistentGlobalVariable("testglobal", row.getColumnValue("orderCount").toString()) 
 
 
": 
Fail to execute script in function __bm_onFetch(). Source:

" + 
reportContext.setPersistentGlobalVariable("testglobal", row.getColumnValue("orderCount").toString()) 
 
 
+ "

A BIRT exception occurred. See next exception for more information. 
Error evaluating Javascript expression. Script engine error: Invalid field name: getColumnValue. (/report/data-sets/oda-data-set[@id="229"]/method[@name="onFetch"]#2) 
Script source: /report/data-sets/oda-data-set[@id="229"]/method[@name="onFetch"], line: 0, text: 
__bm_onFetch(). (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.DataSetScriptExecutor.handleOnFetch(DataSetScriptExecutor.java:227) 
at org.eclipse.birt.data.engine.impl.DataSetRuntime.onFetch(DataSetRuntime.java:617) 
at org.eclipse.birt.data.engine.script.OnFetchScriptHelper.process(OnFetchScriptHelper.java:43) 
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.processFetchEvent(RowResultSet.java:152) 
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:113) 
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.initOdaResult(SmartCacheHelper.java:154) 
at org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:79) 
at org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:57) 
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java:99) 
at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62) 
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSetCacheInResultSetPopulator(PassManager.java:317) 
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateDataSet(PassManager.java:279) 
at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:98) 
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:97) 
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1024) 
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:441) 
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.TableItemExecutor.execute(TableItemExecutor.java:62) 
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.GeneratedMethodAccessor62.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.GeneratedMethodAccessor61.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_onFetch(). Source:

" + 
reportContext.setPersistentGlobalVariable("testglobal", row.getColumnValue("orderCount").toString()) 
 
 
+ "

Find more posts tagged with

Comments

mwilliams

Try using:

reportContext.setPersistentGlobalVariable("testglobal", row["orderCount"].toString());

kkan

Hi ,
i have tried that and it still errors with:

ReportDesign (id = 1):
+ There are errors evaluating script "reportContext.setPersistentGlobalVariable("testglobal", row["orderCount"].toString());

":
Fail to execute script in function __bm_onFetch(). Source:

" + reportContext.setPersistentGlobalVariable("testglobal", row["orderCount"].toString());

+ "

A BIRT exception occurred. See next exception for more information.
Error evaluating Javascript expression. Script engine error: Invalid field name: orderCount. (/report/data-sets/oda-data-set[@id="229"]/method[@name="onFetch"]#1)
Script source: /report/data-sets/oda-data-set[@id="229"]/method[@name="onFetch"], line: 0, text:
__bm_onFetch(). (Element ID:1)

mwilliams

Do you have a field called "orderCount" in your dataSet? It seems that it's not recognizing this. Is it a computed column?

kkan

Hi yes I do have a field called orderCount - that is correct it is a computed field..

mwilliams

The computed field may not be available in the onFetch, so this is why you're having the problem. You could drag the orderCount field into your report and set your PersistentGlobalVariable in its onCreate script. You can hide the element so that it doesn't show in your report. Another thing you could do would be to put i = 0 in your initialize script, put i++ in your onFetch script, and set the PGV with the value of i. The final value that is set in the PGV will be the totalCount of the rows in the dataSet. Hope this helps.

kkan

Hi ,
Thanks I shall give it a go.. i am having another problem...actually i have few related to what I want to achieve. i intend to hide the second column i need to to this conditionally based on whether
orderDSCheck ==1

on doing so i want to extend the width of column 1 .. where and how can i do this..

alternatively could I instead of hding this column based on condition..add a column after column 1
give it a header title of "workcode" and link it to a dataset row["workcode"]

how would i achieve either and which is prob best way?

Thanks K

Your help is SO!!! appreciated

mwilliams

In the table's onCreate method, you can resize the first column with:

this.getColumn(0).width = "width string";

If you know whether you're going to need the second column before the beforeFactory method, then you could create the table dynamically. However, if you're not knowing til the dataSet is run, then hiding is probably your best option.

kkan

Ah Thanks - Ok i found on this forum an article link to how to create table dynamically. But how a bout if i create a table in layout view and then depending on my condition i add a column after the first.. now what would be the code the assign the header a label and then add text to it..
And then to the for detail row would i jst need to assign the row data to it ..?

Thanks K

- sorry for all these ques i have much idea on how to things in BIRt as very novice

mwilliams

If you're relying on the value of a variable you set in your dataSet's onFetch, I believe it's too late to add a column or row based on this value.