Null pointer exception while accessing dynamically created cell in GRID.

dhanuap2011 · 2015-02-18T01:03:38+00:00

<p>Hi,</p><br/> <p> </p><br/> <p>Before I describe my actual issue, wanna let you know I am looking for a tabbed report where number of tabs are created dynamically in a GRID.</p><br/> <p> </p><br/> <p>I am trying to add cell/column to GRID dynamically through a script (in forLoop)</p><br/> <p>In my grid initially there is…

dhanuap2011

<p>Hi,</p>
<p> </p>
<p>Before I describe my actual issue, wanna let you know I am looking for a tabbed report where number of tabs are created dynamically in a GRID.</p>
<p> </p>
<p>I am trying to add cell/column to GRID dynamically through a script (in forLoop)</p>
<p>In my grid initially there is just 1 row and 1 column (i.e. 1 cell) which is static. </p>
<p>I need to add columns to the GRID that are generated dynamically in for loop.</p>
<p>There will always be just 1 row.</p>
<p>I can add cell, but when I try to add a label to newly created cell in GRID, it throws null pointer exception.</p>
<p> </p>
<p>I have attached my rptdesign file and error below.</p>
<p> </p>
<p>Could you please assist.</p>
<p> </p>
<p> </p>
<p></p>
<div style="background-color:#0044ff;"> </div>
<div style="background-color:#ff0000;"> </div>
<p></p>
<p> </p>

<div>
<div>
<div>

Exception
</div>
<div>

Close
<div> </div>

</div>
</div>

<div>
<div>
<div>

<img src="http://127.0.0.1:55438/viewer/birt/images/Error.gif" alt="Error.gif">

<div> </div>

<div>Show Exception Stack Trace</div>
<div>Hide Exception Stack Trace</div>

<div>

Stack Trace:

<div> </div>

</div>

</div>
<div>
<div>
<div> </div>
<div> </div>
</div>
<div>
<div>
<div>
<div> </div>
<div> </div>
</div>
<div> </div>
<div>
<div> </div>
<div> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>

Parameter
</div>
<div>

Close
<div> </div>

</div>
</div>

<div>
<div>
<div>
<div>

Parameters marked with * are required.

<img src="http://127.0.0.1:55438/viewer/birt/images/parameter.gif" title="" alt="parameter.gif">

ProjectType: *

SMALL_CELLS_CIQ_INDOOR_SCSMALL_CELL_WORKQUEUE_TEST

<img src="http://127.0.0.1:55438/viewer/birt/images/parameter.gif" title="" alt="parameter.gif">

FilterCriteria:

Null ValueBY MARKETBY PLANNED COMPLETION DATEBY PLANNED START DATEBY PRIORITYBY PROJECT NAMEBY REGIONBY MARKETBY PLANNED COMPLETION DATEBY PLANNED START DATEBY PRIORITYBY PROJECT NAMEBY REGION

<img src="http://127.0.0.1:55438/viewer/birt/images/parameter.gif" title="" alt="parameter.gif">

FilterValue:

Null Value

<div style="font-size:12px;color:#000000;background-color:#f7f7f7;"> </div>

</div>
</div>
<div>
<div>
<div> </div>
<div> </div>
</div>
<div>
<div>
<div>
<div> </div>
<div> </div>
</div>
<div> </div>
<div>
<div> </div>
<div> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

<div>
<b>Processing, please wait ... </b>

<img src="http://127.0.0.1:55438/viewer/birt/images/Loading.gif" alt="Loading.gif">

<div>

</div>

</div>
<div> </div>

<div>
<div><span> </span>
<div>

<div>Project Type:</div>

<div>[SMALL_CELLS_CIQ_INDOOR_SC, SMALL_CELL_WORKQUEUE_TEST]</div>

<div>Filtering Criteria:</div>

<div>BY PLANNED COMPLETION DATE</div>

<div>dynamic cell1</div>

<div> </div>

<div>
<div>Feb 18, 2015, 11:14 AM</div>
</div>

<div style="color:#FF0000;">
<div>The following items have errors:</div>
<br><div>
<div>ReportDesign (id = 1):</div>
<div><span>+ </span>There are errors evaluating script "<br>
importPackage(Packages.org.eclipse.birt.report.model.elements);<br><br>
var grid = reportContext.getDesignHandle().findElement("TabGrid");<br><br>
elementFactory = reportContext.getDesignHandle().getElementFactory();<br><br>
for(i = 1; i <=3 ; i++) {<br>
var gc = elementFactory.newTableColumn().getElement();<br>
grid.getElement().add( gc , GridItem.COLUMN_SLOT );<br><br>
var label = elementFactory.newLabel("dynamic cell" + i);<br>
label.setText("dynamic cell" + i);<br>
grid.getCell(0,i).getContent().add(label);<br><br>
}<br>
":<br>
TypeError: Cannot call method "getContent" of null (/report/method[@name="beforeFactory"]#14) birt.core.JavascriptCommonError ( 1 time(s) )<br>
detail : org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "<br>
importPackage(Packages.org.eclipse.birt.report.model.elements);<br><br>
var grid = reportContext.getDesignHandle().findElement("TabGrid");<br><br>
elementFactory = reportContext.getDesignHandle().getElementFactory();<br><br>
for(i = 1; i <=3 ; i++) {<br>
var gc = elementFactory.newTableColumn().getElement();<br>
grid.getElement().add( gc , GridItem.COLUMN_SLOT );<br><br>
var label = elementFactory.newLabel("dynamic cell" + i);<br>
label.setText("dynamic cell" + i);<br>
grid.getCell(0,i).getContent().add(label);<br><br>
}<br>
":<br>
TypeError: Cannot call method "getContent" of null (/report/method[@name="beforeFactory"]#14)<br>
    at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249)<br>
    at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleBeforeFactory(ReportScriptExecutor.java:122)<br>
    at org.eclipse.birt.report.engine.api.impl.EngineTask.startFactory(EngineTask.java:2027)<br>
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:101)<br>
    at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)<br>
    at org.eclipse.birt.report.service.ReportEngineService.runAndRenderReport(ReportEngineService.java:937)<br>
    at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(BirtViewerReportService.java:973)<br>
    at org.eclipse.birt.report.service.actionhandler.BirtGetPageAllActionHandler.__execute(BirtGetPageAllActionHandler.java:131)<br>
    at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)<br>
    at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)<br>
    at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)<br>
    at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPageAll(BirtDocumentProcessor.java:183)<br>
    at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)<br>
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br>
    at java.lang.reflect.Method.invoke(Unknown Source)<br>
    at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)<br>
    at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)<br>
    at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)<br>
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)<br>
    at java.lang.reflect.Method.invoke(Unknown Source)<br>
    at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)<br>
    at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)<br>
    at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)<br>
    at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)<br>
    at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)<br>
    at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)<br>
    at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)<br>
    at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)<br>
    at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)<br>
    at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)<br>
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)<br>
    at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br>
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)<br>
    at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)<br>
    at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)<br>
    at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)<br>
    at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)<br>
    at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)<br>
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)<br>
    at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:386)<br>
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)<br>
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:457)<br>
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)<br>
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1075)<br>
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:384)<br>
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)<br>
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1009)<br>
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)<br>
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)<br>
    at org.eclipse.jetty.server.Server.handle(Server.java:368)<br>
    at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)<br>
    at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)<br>
    at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)<br>
    at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)<br>
    at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)<br>
    at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)<br>
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)<br>
    at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)<br>
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)<br>
    at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)<br>
    at java.lang.Thread.run(Unknown Source)<br>
Caused by: org.eclipse.birt.core.exception.CoreException: There are errors evaluating script "<br>
importPackage(Packages.org.eclipse.birt.report.model.elements);<br><br>
var grid = reportContext.getDesignHandle().findElement("TabGrid");<br><br>
elementFactory = reportContext.getDesignHandle().getElementFactory();<br><br>
for(i = 1; i <=3 ; i++) {<br>
var gc = elementFactory.newTableColumn().getElement();<br>
grid.getElement().add( gc , GridItem.COLUMN_SLOT );<br><br>
var label = elementFactory.newLabel("dynamic cell" + i);<br>
label.setText("dynamic cell" + i);<br>
grid.getCell(0,i).getContent().add(label);<br><br>
}<br>
":<br>
TypeError: Cannot call method "getContent" of null (/report/method[@name="beforeFactory"]#14)<br>
    at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:295)<br>
    at org.eclipse.birt.core.script.ScriptContext.evaluate(ScriptContext.java:154)<br>
    at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:789)<br>
    at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:718)<br>
    at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScriptInternal(ScriptExecutor.java:118)<br>
    at org.eclipse.birt.report.engine.script.internal.ScriptExecutor.handleScript(ScriptExecutor.java:105)<br>
    at org.eclipse.birt.report.engine.script.internal.ReportScriptExecutor.handleBeforeFactory(ReportScriptExecutor.java:114)<br>
    ... 59 more<br>
Caused by: org.mozilla.javascript.EcmaError: TypeError: Cannot call method "getContent" of null (/report/method[@name="beforeFactory"]#14)<br>
    at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3654)<br>
    at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3632)<br>
    at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3660)<br>
    at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3679)<br>
    at org.mozilla.javascript.ScriptRuntime.undefCallError(ScriptRuntime.java:3698)<br>
    at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThisHelper(ScriptRuntime.java:2221)<br>
    at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis(ScriptRuntime.java:2214)<br>
    at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:117)<br>
    at org.mozilla.javascript.gen.c4984._c0(/report/method[@name="beforeFactory"]:14)<br>
    at org.mozilla.javascript.gen.c4984.call(/report/method[@name="beforeFactory"])<br>
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398)<br>
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065)<br>
    at org.mozilla.javascript.gen.c4984.call(/report/method[@name="beforeFactory"])<br>
    at org.mozilla.javascript.gen.c4984.exec(/report/method[@name="beforeFactory"])<br>
    at org.eclipse.birt.report.engine.javascript.JavascriptEngine.evaluate(JavascriptEngine.java:290)<br>
    ... 65 more<br><br>
                    </div>
</div>
</div>
</div>
</div>
</div>

<p> </p>

Find more posts tagged with

Comments

Matthew L.

<p>Looking over the existing design, it seems that you are adding a table column element to the grid element which the engine rejects, which causes the cell your applying the label to nonexistent and throws the null pointer exception.</p>
<p> </p>
<p>Looking over the API I could not find an insertColumn() call in the GridHandle like the one in the TableHandle. However I came up with an alternative method by copying an existing column and pasting it back into the GridHandle element.</p>
<p> </p>
<p>Below is a sample of this workaround. I've also included a way to build the grid from scratch as another alternative.</p>
<p>Also see attached example.</p>
<pre class="_prettyXprint _lang-js">
//

//Dynamically adding a column to an existing grid.
//

elementFactory = reportContext.getDesignHandle().getElementFactory(); //ElementFactory
gridHandle = reportContext.getDesignHandle().findElement("MyGrid"); //GridHandle

var max = 3; //Number of columns
for(i = 1; i <=max ; i++) {
if(i<max) //Skip making last column since first one already existed
gridHandle.insertAndPasteColumn(gridHandle.copyColumn(/*base1*/ i), /*base0*/ i); //Copy ColumnBandData column (column 1) and paste into position 2.

var label = elementFactory.newLabel("Label"); //create label
label.setText("Dynamic Cell_" + i); //Set label text
gridHandle.getCell(0 /*row*/, i /*column*/).getContent().add(label); //Add label to grid cell
}
//

</pre>
<pre class="_prettyXprint _lang-js">
//

//Creating a new grid from scratch
//

var max = 3; //Number of columns
elementFactory = reportContext.getDesignHandle().getElementFactory(); //ElementFactory
elementFactory.newGridItem("NewGrid", max, 1) //newGridItem(java.lang.String name, int columnNum, int rowNum)
for(i = 1; i <=max ; i++) {
var label = elementFactory.newLabel("Label"); //create label
label.setText("Dynamic Cell_" + i); //Set label text
gridHandle.getCell(0 /*row*/, i /*column*/).getContent().add(label); //Add label to grid cell
}
//

</pre>

dhanuap2011

<p>Thanks a lot Matthew! It worked.</p>
<p>It further lead me to another query.</p>
<p> </p>
<p>My requirement here is:</p>
<p>I am receiving an input from cascaded parameter which gives me array of string.</p>
<p>Dynamically, I am creating One column in grid for each string in array.</p>
<p>So in above code snippet we have var max = 3; as hardcoded....which in my case becomes (In beforeFactory):</p>
<p><span style="text-align:center;">var projList = reportContext.getParameterValue("ProjectType");</span></p>
<p>var max = projList.length; </p>
<p>This works perfectly fine.</p>
<p> </p>
<p> </p>
<p>In each of the cell I am adding a textbox with hyperlink to a javascript with content = <span style="color:rgb(51,51,51);font-family:'Source Sans Pro', Arial;"><astyle="text-align:center;"href="javascript:changeTab('Tab1');">Tab1</a></span></p>
<p><span style="color:rgb(51,51,51);font-family:'Source Sans Pro', Arial;">This script changes the color of the tab clicked to highlight it.</span></p>
<p> </p>
<p>Basically I am following below:</p>
<p><a data-ipb='nomediaparse' href='http://blogs.actuate.com/creating-a-tabbed-html-report-design/'>http://blogs.actuate.com/creating-a-tabbed-html-report-design/</a></p>
<p> </p>
<p>Now this changeTab script (as mentioned in above site) is in the Text Item with type = HTML.</p>
<p>In this script, I need to access the above cascaded parameter so that I can have String in array to appear as hyperlink text (in stead of Tab1 hardcoded above in hyperlink).</p>
<p> </p>
<p>I tried below options and none of them worked:</p>
<p> </p>
<p>var myArray = <VALUE-OF>params["ProjectType"].value</VALUE-OF></p>
<p>var myArray = <VALUE-OF>reportContext.getParameterValue("ProjectType");</VALUE-OF></p>
<p> </p>
<p>Please guide. PFA.</p>
<p> </p>
<p> </p>

Matthew L.

<p>I think the reason it wasn't working for you is because the Cascading Parameter Group comes back as an object instead of an array.</p>
<p>In the attached example, I use the .slice() command to split the parameter value object into an array and use that in the text element.</p>
<p>Below is the code used in the attached example:</p>
<pre class="_prettyXprint _lang-js">
//

importPackage(Packages.org.eclipse.birt.report.model.api.elements); //For DesignChoiceConstants

elementFactory = reportContext.getDesignHandle().getElementFactory(); //ElementFactory
gridHandle = reportContext.getDesignHandle().findElement("MyGrid"); //GridHandle

var parameterArray = reportContext.getParameterValue("City").slice(); //Convert parameter object to an array

var max = parameterArray.length; //Number of columns
for(i = 1; i <=max ; i++) {
if(i<max) //Skip making last column since first one already existed
gridHandle.insertAndPasteColumn(gridHandle.copyColumn(/*base1*/ i), /*base0*/ i); //Copy ColumnBandData column (column 1) and paste into position 2.

var text = elementFactory.newTextItem("Tab_" + i);
text.setContentType( DesignChoiceConstants.TEXT_CONTENT_TYPE_HTML );
text.setContent("<a style=\"text-align:center;\" href=\"javascript:changeTab('Tab_"+ i +"');\">" + parameterArray[i-1] + "_" + i +"</a>");
text.setBookmark("\"Tab_" + i + "\"");
gridHandle.getCell(0 /*row*/, i /*column*/).getContent().add(text); //Add label to grid cell
}
//

</pre>

dhanuap2011

<p>Hi Matthew, thanks for the reply!</p>
<p>Apologies as I put my query wrongly.</p>
<p>Please ignore my statement <strong>"</strong><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"><strong>In this script, I need to access the above cascaded parameter so that I can have String in array to appear as hyperlink text (in stead of Tab1 hardcoded above in hyperlink)."</strong> in above post.<br>
Actually, beforeFactory script is working fine.</span></p>
<p><span>reportContext</span><span style="color:rgb(102,102,0);">.</span><span>getParameterValue</span><span style="color:rgb(102,102,0);">(</span><span style="color:rgb(0,136,0);">"City"</span><span style="color:rgb(102,102,0);">) is working fine in beforeFactory.</span></p>
<p> </p>
<p><span style="color:rgb(102,102,0);">The issue is in the script which I put in TextItem. Name of the script is "changeTab" where I am setting the color of clicked textbox (which was dynamically added to grid in beforeFactory) to white and color of other dynamic textboxes to grey.</span></p>
<p> </p>
<p><span style="color:rgb(102,102,0);">Here I need access to cascaded parameter.</span></p>
<p> </p>
<p><span style="color:rgb(102,102,0);">In this script, I tried auto generated expression</span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">var myArray = <VALUE-OF>params["ProjectType"].value</VALUE-OF></span></p>
<p><span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">also, below expression</span></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">var myArray = <VALUE-OF>reportContext.getParameterValue("ProjectType");</VALUE-OF></p>
<p style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">But it did not work.</p>

Matthew L.

<p>I see what your saying now.</p>
<p>Inside a Text Item element you use the <VALUE-OF> tags to pull the values just like you have with the following line:</p>
<p>var myArray = <VALUE-OF>params["ProjectType"].value</VALUE-OF></p>
<p> </p>
<p>However, there is an extra step that is needed because your inside <script> tags, which is enclose the <VALUE-OF> string in double quotes.</p>
<p>So per the line of code above, it would look like the following:</p>
<p><script></p>
<p> var myArray = "<VALUE-OF>params["ProjectType"].value</VALUE-OF>";</p>
<p></script></p>

dhanuap2011

<p>Excellent! You are a saviour.</p>
<p>It worked. Thanks a lot!</p>
<p> </p>
<p>May I further ask you one more query

</p>
<p> </p>
<p>In my report there will be a table binded to 1 dataset which has some SQL query.</p>
<p> </p>
<p>This SQL accepts just 1 parameter (initially some default parameter is used).</p>
<p> </p>
<p>My requirement now is on the click of textBox(Which is a hyperlink) in grid cell (created dynamically), text on this textbox/hyperlink say 'Tab1' should be passed as a parameter to this SQl/dataset.</p>
<p> </p>
<p>Execute SQL again and update the table based on new result.</p>
<p> </p>
<p>Is it possible.</p>
<p> </p>
<p>How do I achieve this. Where should I put the script. And do you have any example script.</p>

Matthew L.

<p>It might be possible to rerun the query from a hyperlink and update a table with the new data returned, however I have never tried that.</p>
<p> </p>
<p>The recommended way would be to query the database once, then use the tabs to either filter the table data, or have multiple tables (one for each tab) dynamically generated based on the query results and use the tabs to show or hide the relevant table.</p>
<p> </p>
<p>While the elements are not dynamically generated, the attached example demonstrates query the database once then use the hide/show element option for the tab selection, which is the recommended way to accomplish the end result.</p>

dhanuap2011

Thanks for all your help so far. I am still facing issues in dynamic creation of dataset and table for which i have started a new thread.my script code for table creation looks correct but not working. Anyways, seeking your help in new thread. Thanks a ton!

dhanuap2011

<p>Hi Mathew,</p>
<p> </p>
<p>Could you please provide me with dynamic table creation script working example(rptdesign) or point out what is wrong with my below script:</p>
<p>Below script does not show any table in the report. It does not even throw any exception. This code is put in beforeFactory.</p>
<p> </p>
<p> </p>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage( Packages.org.eclipse.birt.report.model.api );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.java.lang);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.java.util);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.org.eclipse.birt.data.engine.api);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.org.eclipse.birt.report.model.api);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.org.eclipse.birt.data.engine.api.querydefn);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.org.eclipse.birt.data.engine.core);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.org.eclipse.birt.core.data);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.org.eclipse.birt.report.model.elements);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage(Packages.org.eclipse.birt.report.model.api.elements);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">importPackage( Packages.org.eclipse.birt.report.model.api );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">/*************Create table dynamically***********/</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">//var dsrc = reportContext.getDesignHandle().getDesign().findDataSource("DataSource");</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">
<div style="margin:0px;">//var dsrc = reportContext.getDesignHandle().findDataSource("DataSource");</div>
<div style="margin:0px;"> </div>
<div style="margin:0px;"> </div>
</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">var dsrc = elementFactory.newOdaDataSource( "DataSource1", "org.eclipse.birt.report.data.oda.jdbc" );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">dsrc.setProperty( "odaURL", "jdbc:oracle:thin:@ihost288:1521:ASCS" );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">dsrc.setProperty( "odaDriverClass", "oracle.jdbc.driver.OracleDriver");</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">dsrc.setProperty( "odaUser","user1" );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">dsrc.setProperty( "odaPassword", "pass1" );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">reportContext.getDesignHandle().getDataSources().add( dsrc );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">var dset = reportContext.getDesignHandle().findDataSet("DataSet1");</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">
<div style="margin:0px;">var projList = reportContext.getParameterValue("ProjectType");</div>
<div style="margin:0px;"> </div>
<div style="margin:0px;"> </div>
</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">for(iNum = 1; iNum <=projList.length ; iNum++) {</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">var odaDataSet = elementFactory.newOdaDataSet( "TestDataSet" + iNum , "org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet");</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">odaDataSet.setDataSource( dsrc.getName( ) );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">odaDataSet.setQueryText( dset.getQueryText().replace("****",projList[iNum-1])); </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">reportContext.getDesignHandle().getDataSets( ).add( odaDataSet );</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">//Table created</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">dynamicTable = elementFactory.newTableItem("Table"+iNum);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">dynamicTable.setWidth("100%");</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">dynamicTable.setDataSet(odaDataSet);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;"> </div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">reportContext.getDesignHandle().getBody().add(dynamicTable);</div>
<div style="margin:0px;color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">}</div>

Matthew L.

<p>As per your question about the code, see my response via this post:</p>
<p><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/36066-dynamic-creation-of-tables-in-birt/?p=133880'>http://developer.actuate.com/community/forum/index.php?/topic/36066-dynamic-creation-of-tables-in-birt/?p=133880</a></p>
<p> </p>
<p>Also I created an example that dynamically creates grid tabs and a table for each tab, which allows you to select the tab to display the referenced table.</p>
<p>Hopefully this working example will be a helpful reference to accomplish the result you are looking for.</p>
<p> </p>
<p>Let me know if you have questions or get stuck.</p>

dhanuap2011

<p>Thanks Matthew. It worked!.</p>