Eclipse Community Forums: BIRT » error javaScript in birt

Home » Archived » BIRT » error javaScript in birt

error javaScript in birt [message #207220]

Tue, 19 December 2006 02:29

Eclipse User

i get the error as below:

The following items have errors:

Table (id = 1340):
+ The data type of script expression result is
org.eclipse.birt.core.data.DataType$AnyType, but one of its value is
"null", which cannot be converted to
org.eclipse.birt.core.data.DataType$AnyType.
data.engine.ScriptResult.WrongDataType ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: The data type of
script expression result is org.eclipse.birt.core.data.DataType$AnyType,
but one of its value is "null", which cannot be converted to
org.eclipse.birt.core.data.DataType$AnyType. at
org.eclipse.birt.data.engine.impl.ComputedColumnHelperInstan ce.process(ComputedColumnHelper.java:241)
at
org.eclipse.birt.data.engine.impl.ComputedColumnHelper.proce ss(ComputedColumnHelper.java:89)
at
org.eclipse.birt.data.engine.executor.cache.RowResultSet.pro cessFetchEvent(RowResultSet.java:132)
at
org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:96)
at
org.eclipse.birt.data.engine.executor.cache.ExpandableRowRes ultSet.next(ExpandableRowResultSet.java:62)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .populateData(SmartCacheHelper.java:268)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .initInstance(SmartCacheHelper.java:243)
at
org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .getResultSetCache(SmartCacheHelper.java:206)
at
org.eclipse.birt.data.engine.executor.cache.SmartCache.<init >(SmartCache.java:65)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.populateOdiResultSet(PassUtil.java:139)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.pass(PassUtil.java:65)
at
org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.doRowSorting(ResultSetProcessUtil.java:173)
at
org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.populateResultSet(ResultSetProcessUtil.java:10 4)
at
org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.doPopulate(ResultSetProcessUtil.java:81)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doPopulation(PassManager.java:204)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doMultiPass(PassManager.java:146)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.pass(PassManager.java:84)
at
org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.populateResultSet(PassManager.java:62)
at
org.eclipse.birt.data.engine.executor.transform.ResultSetPop ulator.populateResultSet(ResultSetPopulator.java:207)
at
org.eclipse.birt.data.engine.executor.transform.CachedResult Set. <init>(CachedResultSet.java:67)
at
org.eclipse.birt.data.engine.executor.DataSourceQuery.execut e(DataSourceQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:330)
at
org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
at
org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
at
org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
at
org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
at
org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
Source) at
org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
Source) at
org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
Source) at
org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:534)

is that anyone can tell me what kind of the error???
thanks

Re: error javaScript in birt [message #207361 is a reply to message #207220]

Tue, 19 December 2006 10:49

Eclipse User

Can you post the script?
You should be able to check for null by just putting in
if( variable ){

}else{
variable = "";
}

Jason

"70" <klhuang@shinyang.com.my> wrote in message
news:b3fdb84fb082db1321b6809762b30405$1@www.eclipse.org...
>i get the error as below:
>
> The following items have errors:
>
> Table (id = 1340): + The data type of script expression result is
> org.eclipse.birt.core.data.DataType$AnyType, but one of its value is
> "null", which cannot be converted to
> org.eclipse.birt.core.data.DataType$AnyType.
> data.engine.ScriptResult.WrongDataType ( 1 time(s) )
> detail : org.eclipse.birt.data.engine.core.DataException: The data type of
> script expression result is org.eclipse.birt.core.data.DataType$AnyType,
> but one of its value is "null", which cannot be converted to
> org.eclipse.birt.core.data.DataType$AnyType. at
> org.eclipse.birt.data.engine.impl.ComputedColumnHelperInstan ce.process(ComputedColumnHelper.java:241)
> at
> org.eclipse.birt.data.engine.impl.ComputedColumnHelper.proce ss(ComputedColumnHelper.java:89)
> at
> org.eclipse.birt.data.engine.executor.cache.RowResultSet.pro cessFetchEvent(RowResultSet.java:132)
> at
> org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:96)
> at
> org.eclipse.birt.data.engine.executor.cache.ExpandableRowRes ultSet.next(ExpandableRowResultSet.java:62)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .populateData(SmartCacheHelper.java:268)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .initInstance(SmartCacheHelper.java:243)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper .getResultSetCache(SmartCacheHelper.java:206)
> at
> org.eclipse.birt.data.engine.executor.cache.SmartCache.<init >(SmartCache.java:65)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.populateOdiResultSet(PassUtil.java:139)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassUti l.pass(PassUtil.java:65)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.doRowSorting(ResultSetProcessUtil.java:173)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.populateResultSet(ResultSetProcessUtil.java:10 4)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.ResultS etProcessUtil.doPopulate(ResultSetProcessUtil.java:81)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doPopulation(PassManager.java:204)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.doMultiPass(PassManager.java:146)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.pass(PassManager.java:84)
> at
> org.eclipse.birt.data.engine.executor.transform.pass.PassMan ager.populateResultSet(PassManager.java:62)
> at
> org.eclipse.birt.data.engine.executor.transform.ResultSetPop ulator.populateResultSet(ResultSetPopulator.java:207)
> at
> org.eclipse.birt.data.engine.executor.transform.CachedResult Set. <init>(CachedResultSet.java:67)
> at
> org.eclipse.birt.data.engine.executor.DataSourceQuery.execut e(DataSourceQuery.java:498)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:330)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:735)
> at
> org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:181)
> at
> org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:137)
> at
> org.eclipse.birt.report.engine.data.dte.DteResultSet.<init>(DteResultSet.java:86)
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:115)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:208)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1640)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:62)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:74)
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:35)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout Children(HTMLPageLM.java:123)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:81)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:80)
> at
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:194)
> at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.BirtRunAndRend erActionHandler.__execute(Unknown
> Source) at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.layout.Engi neFragment.doService(Unknown
> Source) at
> org.eclipse.birt.report.presentation.aggregation.AbstractBas eFragment.service(Unknown
> Source) at
> org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Un known Source)
> at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGe t(Unknown
> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:81)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
> at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Cu stomPrincipalValve.java:39)
> at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:153)
> at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:59)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:856)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:744)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
> at
> org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(Maste rSlaveWorkerThread.java:112)
> at java.lang.Thread.run(Thread.java:534)
>
>
> is that anyone can tell me what kind of the error???
> thanks
>

Re: error javaScript in birt [message #207467 is a reply to message #207361]

Tue, 19 December 2006 19:16

Eclipse User

i only use the simple script at the initialize:

str1 = params["stmt"].value;
str2 = params["stmt1"].value;

strTitle = params["titles"].value;
arrTitle1=strTitle.split(",");

i just pass some parameter in script.

is that mean i can use the report data set item as the "variable" in the
scripting?

Re: error javaScript in birt [message #207483 is a reply to message #207361]

Tue, 19 December 2006 19:19

Eclipse User

i just pass the parameter in the scripting but i do some calculation with
the data item...is that cause the "null" value?

Re: error javaScript in birt [message #207742 is a reply to message #207467]

Wed, 20 December 2006 12:41

Eclipse User

Can you post the whole report, because the error is happening in a table.
There does not appear to be anything wrong with your script.

Jason

"70" <klhuang@shinyang.com.my> wrote in message
news:eddc778908db0b1e67be0f21017a6a37$1@www.eclipse.org...
>i only use the simple script at the initialize:
>
> str1 = params["stmt"].value;
> str2 = params["stmt1"].value;
>
> strTitle = params["titles"].value;
> arrTitle1=strTitle.split(",");
>
> i just pass some parameter in script.
>
> is that mean i can use the report data set item as the "variable" in the
> scripting?
>

Re: error javaScript in birt [message #207897 is a reply to message #207742]

Wed, 20 December 2006 19:22

Eclipse User

my whole report xml source is as below:

<?xml version="1.0" encoding="UTF-8"?>

<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.1.1.v20060922-1058 Build <20060926-0959></property>
<property name="units">in</property>
<property name="comments">Copyright (c) 2006 <<Your Company Name
here>></property>
<method name="initialize"><![CDATA[str1 = params["stmt"].value;

strTitle = params["titles"].value;
arrTitle1=strTitle.split(",");]]></method>
<parameters>
<scalar-parameter name="stmt" id="479">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="titles" id="480">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
id="4">
<property
name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property
name="odaURL">jdbc:mysql://127.0.0.1:3306/ILMS</property>
<property name="odaUser">ilms</property>
<encrypted-property
name="odaPassword">MTIz</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="stock" id="5">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">POINT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CATEGORY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DESCRIPTION</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SUB_CATEGORY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">QTY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">PART_ID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">UNIT_PRICE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">AMOUNT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">QTY_RETURN</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ReturnAmount</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">CREATE_DATE</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">IssUnitPrice</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">IssQty</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">IssQtyRtn</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">IssAmt</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">IssRtnAmt</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">IssPartId</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<method name="beforeOpen"><![CDATA[this.queryText="select
m_point.POINT,sp_inventory.CATEGORY,sp_inventory.DESCRIPTION ,sp_inventory.SUB_CATEGORY,sp_inv_rec_item.QTY,sp_inv_rec_it em.PART_ID,sp_inv_rec_item.UNIT_PRICE,sp_inv_rec_item.AMOUNT ,sp_inv_rec_item.QTY_RETURN,sp_inv_rec_item.QTY_RETURN*sp_in v_rec_item.UNIT_PRICE
as ReturnAmount,sp_inv_rec.CREATE_DATE,sp_inv_iss_item.UNIT_PRI CE as
IssUnitPrice,sp_inv_iss_item.QTY as IssQty,sp_inv_iss_item.QTY_RETURN as
IssQtyRtn,sp_inv_iss_item.AMOUNT as
IssAmt,sp_inv_iss_item.Qty_RETURN*sp_inv_iss_item.UNIT_PRICE as
IssRtnAmt,sp_inv_iss_item.PART_ID as IssPartId "+
params["stmt"];]]></method>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">POINT</property>
<property name="nativeName">POINT</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CATEGORY</property>
<property name="nativeName">CATEGORY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">DESCRIPTION</property>
<property name="nativeName">DESCRIPTION</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">SUB_CATEGORY</property>
<property name="nativeName">SUB_CATEGORY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">QTY</property>
<property name="nativeName">QTY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">PART_ID</property>
<property name="nativeName">PART_ID</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">UNIT_PRICE</property>
<property name="nativeName">UNIT_PRICE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">AMOUNT</property>
<property name="nativeName">AMOUNT</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">QTY_RETURN</property>
<property name="nativeName">QTY_RETURN</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">ReturnAmount</property>
<property name="nativeName">ReturnAmount</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">CREATE_DATE</property>
<property name="nativeName">CREATE_DATE</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">91</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">IssUnitPrice</property>
<property name="nativeName">IssUnitPrice</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">IssQty</property>
<property name="nativeName">IssQty</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">IssQtyRtn</property>
<property name="nativeName">IssQtyRtn</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">15</property>
<property name="name">IssAmt</property>
<property name="nativeName">IssAmt</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">16</property>
<property name="name">IssRtnAmt</property>
<property name="nativeName">IssRtnAmt</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">17</property>
<property name="name">IssPartId</property>
<property name="nativeName">IssPartId</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select
m_point.POINT,
sp_inventory.CATEGORY,
sp_inventory.DESCRIPTION,
sp_inventory.SUB_CATEGORY,
sp_inv_rec_item.QTY,
sp_inv_rec_item.PART_ID,
sp_inv_rec_item.UNIT_PRICE,
sp_inv_rec_item.AMOUNT,
sp_inv_rec_item.QTY_RETURN,
sp_inv_rec_item.QTY_RETURN*sp_inv_rec_item.UNIT_PRICE as ReturnAmount,
sp_inv_rec.CREATE_DATE,
sp_inv_iss_item.UNIT_PRICE as IssUnitPrice,
sp_inv_iss_item.QTY as IssQty,
sp_inv_iss_item.QTY_RETURN as IssQtyRtn,
sp_inv_iss_item.AMOUNT as IssAmt,
sp_inv_iss_item.Qty_RETURN*sp_inv_iss_item.UNIT_PRICE as IssRtnAmt,
sp_inv_iss_item.PART_ID as IssPartId
from m_point,
sp_inventory,
sp_inv_rec,
sp_inv_rec_item,
sp_inv_iss,
sp_inv_iss_item
where m_point.POINT=sp_inv_iss.POINT
and sp_inv_rec.ID=sp_inv_rec_item.INV_REC_ID
and sp_inventory.PART_NO=sp_inv_rec_item.PART_ID
and sp_inventory.PART_NO=sp_inv_iss_item.PART_ID
and sp_inv_iss.ID=sp_inv_iss_item.INV_ISS_ID</property>
<xml-property name="designerValues"><![CDATA[<?xml
version="1.0" encoding="UTF-8"?>
<model:DesignValues
xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>POINT</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>POINT</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CATEGORY</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>CATEGORY</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DESCRIPTION</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>DESCRIPTION</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SUB_CATEGORY</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>SUB_CATEGORY</design:label>
<design:formattingHints>
<design:displaySize>100</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QTY</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>QTY</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PART_ID</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>PART_ID</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>UNIT_PRICE</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>UNIT_PRICE</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>AMOUNT</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>AMOUNT</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QTY_RETURN</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>QTY_RETURN</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ReturnAmount</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>ReturnAmount</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CREATE_DATE</design:name>
<design:position>11</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>CREATE_DATE</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssUnitPrice</design:name>
<design:position>12</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>IssUnitPrice</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssQty</design:name>
<design:position>13</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>IssQty</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssQtyRtn</design:name>
<design:position>14</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>IssQtyRtn</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssAmt</design:name>
<design:position>15</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>IssAmt</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssRtnAmt</design:name>
<design:position>16</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>IssRtnAmt</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssPartId</design:name>
<design:position>17</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>0</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
</design:attributes>
<design:usageHints>
<design:label>IssPartId</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>POINT</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CATEGORY</design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>DESCRIPTION</design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>SUB_CATEGORY</design:name>
<design:position>4</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QTY</design:name>
<design:position>5</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>PART_ID</design:name>
<design:position>6</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>UNIT_PRICE</design:name>
<design:position>7</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>AMOUNT</design:name>
<design:position>8</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>QTY_RETURN</design:name>
<design:position>9</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>ReturnAmount</design:name>
<design:position>10</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CREATE_DATE</design:name>
<design:position>11</design:position>
<design:nativeDataTypeCode>91</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssUnitPrice</design:name>
<design:position>12</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssQty</design:name>
<design:position>13</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssQtyRtn</design:name>
<design:position>14</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssAmt</design:name>
<design:position>15</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssRtnAmt</design:name>
<design:position>16</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>IssPartId</design:name>
<design:position>17</design:position>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
</design:attributes>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="HeaderStyle" id="529">
<property name="fontWeight">bolder</property>
<property name="textUnderline">underline</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">a4</property>
<property name="orientation">landscape</property>
</simple-master-page>
</page-setup>
<body>
<grid id="352">
<property name="fontSize">smaller</property>
<property name="width">100%</property>
<column id="353">
<property name="width">1.2916666667in</property>
</column>
<column id="354">
<property name="width">5.8333333333in</property>
</column>
<column id="355">
<property name="width">1.3645833333in</property>
</column>
<row id="356">
<cell id="357">
<data id="368">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title1</property>
<expression
name="expression">arrTitle1[0]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title1</property>
</data>
<data id="393">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title2</property>
<expression
name="expression">arrTitle1[1]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title2</property>
</data>
<data id="394">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title3</property>
<expression
name="expression">arrTitle1[2]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title3</property>
</data>
<data id="413">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title4</property>
<expression
name="expression">arrTitle1[3]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title4</property>
</data>
<data id="478">
<property name="fontSize">smaller</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">title5</property>
<expression
name="expression">arrTitle1[4]</expression>
<property name="dataType">any</property>
</structure>
</list-property>
<property name="resultSetColumn">title5</property>
</data>
</cell>
<cell id="358">
<text id="297">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<center>
<h3>Shin Yang Sdn Bhd</h3><br>
<h4>Stock Opening And Closing Analysis Testing Report</h4>
</center><br>]]></text-property>
</text>
</cell>
<cell id="359">
<text id="299">
<property name="fontSize">smaller</property>
<property name="textAlign">right</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of
format="dd-MM-yyyy">new Date()</value-of>]]></text-property>
</text>
</cell>
</row>
</grid>
<grid id="746">
<property name="fontSize">x-small</property>
<property name="width">100%</property>
<column id="747">
<property name="width">5cm</property>
</column>
<column id="748">
<property name="width">2cm</property>
<property name="textAlign">center</property>
</column>
<column id="749">
<property name="width">6cm</property>
<property name="textAlign">center</property>
</column>
<column id="750">
<property name="width">6cm</property>
<property name="textAlign">center</property>
</column>
<column id="751">
<property name="width">2cm</property>
<property name="textAlign">center</property>
</column>
<row id="752">
<cell id="753"/>
<cell id="754">
<label id="758">
<property name="textAlign">center</property>
<text-property name="text"><-----OPENING
BALANCE-----></text-property>
</label>
</cell>
<cell id="755">
<label id="759">
<property name="textAlign">center</property>
<text-property
name="text"><------------------RECEIVINGS------------------ ></text-property>
</label>
</cell>
<cell id="756">
<label id="760">
<property name="textAlign">center</property>
<text-property
name="text"><--------------------ISSUINGS-------------------- ></text-property>
</label>
</cell>
<cell id="757">
<label id="761">
<property name="textAlign">center</property>
<text-property name="text"><-----CLOSING
BALANCE-----></text-property>
</label>
</cell>
</row>
</grid>
<table id="2140">
<property name="fontSize">x-small</property>
<property name="width">100%</property>
<property name="dataSet">stock</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CATEGORY</property>
<expression name="expression">dataSetRow["CATEGORY"]+"
- "+dataSetRow["DESCRIPTION"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">DESCRIPTION</property>
<expression
name="expression">dataSetRow["DESCRIPTION"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">SUB_CATEGORY</property>
<expression
name="expression">dataSetRow["SUB_CATEGORY"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">QTY</property>
<expression
name="expression">dataSetRow["QTY"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">PART_ID</property>
<expression
name="expression">dataSetRow["PART_ID"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">UNIT_PRICE</property>
<expression
name="expression">dataSetRow["UNIT_PRICE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">AMOUNT</property>
<expression
name="expression">dataSetRow["AMOUNT"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">QTY_RETURN</property>
<expression
name="expression">dataSetRow["QTY_RETURN"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">UNIT_PRICE_9</property>
<expression
name="expression">dataSetRow["UNIT_PRICE_9"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ReturnAmount</property>
<expression
name="expression">dataSetRow["ReturnAmount"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CREATE_DATE</property>
<expression
name="expression">dataSetRow["CREATE_DATE"]</expression >
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">POINT</property>
<expression
name="expression">dataSetRow["POINT"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">issQty</property>
<expression
name="expression">dataSetRow["issQty"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">issQtyRtn</property>
<expression
name="expression">dataSetRow["issQtyRtn"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">issUnitPrice</property>
<expression
name="expression">dataSetRow["issUnitPrice"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">issAmount</property>
<expression
name="expression">dataSetRow["issAmount"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">issReturnAmt</property>
<expression
name="expression">dataSetRow["issReturnAmt"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">no</property>
<expression
name="expression">Total.runningCount()+"."</expression>
<property name="dataType">any</property>
</structure>
<structure>
<property name="name">totalIssQty</property>
<expression
name="expression">Total.sum(row["IssQty"])</expression>
<property name="dataType">any</property>
<property name="aggregateOn">cateGroup</property>
</structure>
<structure>
<property name="name">sumAmt</property>
<expression
name="expression">Total.sum(dataSetRow["AMOUNT"])</expression >
<property name="dataType">any</property>
</structure>
<structure>
<property name="name"&g

Re: error javaScript in birt [message #208037 is a reply to message #207897]

Thu, 21 December 2006 10:20

Eclipse User

This is a null issue, but I am not certain where it is happening.
You could try putting something like this in for your expressions
if (dataSetRow["COMMENTS"]){

dataSetRow["COMMENTS"]

}else{

"Null Value";

}

Also this code
this.queryText="select

m_point.POINT,sp_inventory.CATEGORY,sp_inventory.DESCRIPTION ,sp_inventory.SUB_CATEGORY,sp_inv_rec_item.QTY,sp_inv_rec_it em.PART_ID,sp_inv_rec_item.UNIT_PRICE,sp_inv_rec_item.AMOUNT ,sp_inv_rec_item.QTY_RETURN,sp_inv_rec_item.QTY_RETURN*sp_in v_rec_item.UNIT_PRICE

as ReturnAmount,sp_inv_rec.CREATE_DATE,sp_inv_iss_item.UNIT_PRI CE as

IssUnitPrice,sp_inv_iss_item.QTY as IssQty,sp_inv_iss_item.QTY_RETURN as

IssQtyRtn,sp_inv_iss_item.AMOUNT as

IssAmt,sp_inv_iss_item.Qty_RETURN*sp_inv_iss_item.UNIT_PRICE as

IssRtnAmt,sp_inv_iss_item.PART_ID as IssPartId "+

params["stmt"];

What are you passing in for stmt? You should verify that you have a space
between IssPartId" + " " + params["stmt";

Jason

"70" <klhuang@shinyang.com.my> wrote in message
news:7fff2be844346c0844bd8a7ac09578bc$1@www.eclipse.org...
> my whole report xml source is as below:
>
> <?xml version="1.0" encoding="UTF-8"?>
> 
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.6"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.1.1.v20060922-1058 Build <20060926-0959></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2006 <<Your Company Name
> here>></property>
> <method name="initialize"><![CDATA[str1 = params["stmt"].value;
>
> strTitle = params["titles"].value;
> arrTitle1=strTitle.split(",");]]></method>
> <parameters>
> <scalar-parameter name="stmt" id="479">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="titles" id="480">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="4">
> <property
> name="odaDriverClass">com.mysql.jdbc.Driver</property>
> <property
> name="odaURL">jdbc:mysql://127.0.0.1:3306/ILMS</property>
> <property name="odaUser">ilms</property>
> <encrypted-property
> name="odaPassword">MTIz</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="stock" id="5">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">POINT</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CATEGORY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">DESCRIPTION</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SUB_CATEGORY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">QTY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">PART_ID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">UNIT_PRICE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">AMOUNT</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">QTY_RETURN</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">ReturnAmount</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">CREATE_DATE</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">IssUnitPrice</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">IssQty</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">IssQtyRtn</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">IssAmt</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">IssRtnAmt</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">IssPartId</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <method name="beforeOpen"><![CDATA[this.queryText="select
> m_point.POINT,sp_inventory.CATEGORY,sp_inventory.DESCRIPTION ,sp_inventory.SUB_CATEGORY,sp_inv_rec_item.QTY,sp_inv_rec_it em.PART_ID,sp_inv_rec_item.UNIT_PRICE,sp_inv_rec_item.AMOUNT ,sp_inv_rec_item.QTY_RETURN,sp_inv_rec_item.QTY_RETURN*sp_in v_rec_item.UNIT_PRICE
> as ReturnAmount,sp_inv_rec.CREATE_DATE,sp_inv_iss_item.UNIT_PRI CE as
> IssUnitPrice,sp_inv_iss_item.QTY as IssQty,sp_inv_iss_item.QTY_RETURN as
> IssQtyRtn,sp_inv_iss_item.AMOUNT as
> IssAmt,sp_inv_iss_item.Qty_RETURN*sp_inv_iss_item.UNIT_PRICE as
> IssRtnAmt,sp_inv_iss_item.PART_ID as IssPartId "+
> params["stmt"];]]></method>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">POINT</property>
> <property name="nativeName">POINT</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CATEGORY</property>
> <property name="nativeName">CATEGORY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">DESCRIPTION</property>
> <property name="nativeName">DESCRIPTION</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">SUB_CATEGORY</property>
> <property name="nativeName">SUB_CATEGORY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">QTY</property>
> <property name="nativeName">QTY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">PART_ID</property>
> <property name="nativeName">PART_ID</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">UNIT_PRICE</property>
> <property name="nativeName">UNIT_PRICE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">AMOUNT</property>
> <property name="nativeName">AMOUNT</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">QTY_RETURN</property>
> <property name="nativeName">QTY_RETURN</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">ReturnAmount</property>
> <property name="nativeName">ReturnAmount</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">CREATE_DATE</property>
> <property name="nativeName">CREATE_DATE</property>
> <property name="dataType">date-time</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">IssUnitPrice</property>
> <property name="nativeName">IssUnitPrice</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">IssQty</property>
> <property name="nativeName">IssQty</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">IssQtyRtn</property>
> <property name="nativeName">IssQtyRtn</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">15</property>
> <property name="name">IssAmt</property>
> <property name="nativeName">IssAmt</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">16</property>
> <property name="name">IssRtnAmt</property>
> <property name="nativeName">IssRtnAmt</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">17</property>
> <property name="name">IssPartId</property>
> <property name="nativeName">IssPartId</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">select
> m_point.POINT,
> sp_inventory.CATEGORY,
> sp_inventory.DESCRIPTION,
> sp_inventory.SUB_CATEGORY,
> sp_inv_rec_item.QTY,
> sp_inv_rec_item.PART_ID,
> sp_inv_rec_item.UNIT_PRICE,
> sp_inv_rec_item.AMOUNT,
> sp_inv_rec_item.QTY_RETURN,
> sp_inv_rec_item.QTY_RETURN*sp_inv_rec_item.UNIT_PRICE as ReturnAmount,
> sp_inv_rec.CREATE_DATE,
> sp_inv_iss_item.UNIT_PRICE as IssUnitPrice,
> sp_inv_iss_item.QTY as IssQty,
> sp_inv_iss_item.QTY_RETURN as IssQtyRtn,
> sp_inv_iss_item.AMOUNT as IssAmt,
> sp_inv_iss_item.Qty_RETURN*sp_inv_iss_item.UNIT_PRICE as IssRtnAmt,
> sp_inv_iss_item.PART_ID as IssPartId
> from m_point,
> sp_inventory,
> sp_inv_rec,
> sp_inv_rec_item,
> sp_inv_iss,
> sp_inv_iss_item
> where m_point.POINT=sp_inv_iss.POINT
> and sp_inv_rec.ID=sp_inv_rec_item.INV_REC_ID
> and sp_inventory.PART_NO=sp_inv_rec_item.PART_ID
> and sp_inventory.PART_NO=sp_inv_iss_item.PART_ID
> and sp_inv_iss.ID=sp_inv_iss_item.INV_ISS_ID</property>
> <xml-property name="designerValues"><![CDATA[<?xml
> version="1.0" encoding="UTF-8"?>
> <model:DesignValues
> xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design"
> xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
> <Version>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>POINT</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>POINT</design:label>
> <design:formattingHints>
> <design:displaySize>100</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CATEGORY</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>CATEGORY</design:label>
> <design:formattingHints>
> <design:displaySize>100</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>DESCRIPTION</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>DESCRIPTION</design:label>
> <design:formattingHints>
> <design:displaySize>100</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>SUB_CATEGORY</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>SUB_CATEGORY</design:label>
> <design:formattingHints>
> <design:displaySize>100</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>QTY</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>QTY</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>PART_ID</design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>PART_ID</design:label>
> <design:formattingHints>
> <design:displaySize>20</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>UNIT_PRICE</design:name>
> <design:position>7</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>UNIT_PRICE</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>AMOUNT</design:name>
> <design:position>8</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>AMOUNT</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>QTY_RETURN</design:name>
> <design:position>9</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>QTY_RETURN</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ReturnAmount</design:name>
> <design:position>10</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>ReturnAmount</design:label>
> <design:formattingHints>
> <design:displaySize>22</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CREATE_DATE</design:name>
> <design:position>11</design:position>
> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>CREATE_DATE</design:label>
> <design:formattingHints>
> <design:displaySize>10</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssUnitPrice</design:name>
> <design:position>12</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>IssUnitPrice</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssQty</design:name>
> <design:position>13</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>IssQty</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssQtyRtn</design:name>
> <design:position>14</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>IssQtyRtn</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssAmt</design:name>
> <design:position>15</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>IssAmt</design:label>
> <design:formattingHints>
> <design:displaySize>12</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssRtnAmt</design:name>
> <design:position>16</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>IssRtnAmt</design:label>
> <design:formattingHints>
> <design:displaySize>22</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssPartId</design:name>
> <design:position>17</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>0</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> </design:attributes>
> <design:usageHints>
> <design:label>IssPartId</design:label>
> <design:formattingHints>
> <design:displaySize>20</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>POINT</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CATEGORY</design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>DESCRIPTION</design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>SUB_CATEGORY</design:name>
> <design:position>4</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>QTY</design:name>
> <design:position>5</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>PART_ID</design:name>
> <design:position>6</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>UNIT_PRICE</design:name>
> <design:position>7</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>AMOUNT</design:name>
> <design:position>8</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>QTY_RETURN</design:name>
> <design:position>9</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>ReturnAmount</design:name>
> <design:position>10</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CREATE_DATE</design:name>
> <design:position>11</design:position>
> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssUnitPrice</design:name>
> <design:position>12</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssQty</design:name>
> <design:position>13</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssQtyRtn</design:name>
> <design:position>14</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssAmt</design:name>
> <design:position>15</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssRtnAmt</design:name>
> <design:position>16</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>IssPartId</design:name>
> <design:position>17</design:position>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> </design:attributes>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="HeaderStyle" id="529">
> <property name="fontWeight">bolder</property>
> <property name="textUnderline">underline</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="type">a4</property>
> <property name="orientation">landscape</property>
> </simple-master-page>
> </page-setup>
> <body>
> <grid id="352">
> <property name="fontSize">smaller</property>
> <property name="width">100%</property>
> <column id="353">
> <property name="width">1.2916666667in</property>
> </column>
> <column id="354">
> <property name="width">5.8333333333in</property>
> </column>
> <column id="355">
> <property name="width">1.3645833333in</property>
> </column>
> <row id="356">
> <cell id="357">
> <data id="368">
> <property name="fontSize">smaller</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">title1</property>
> <expression
> name="expression">arrTitle1[0]</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">title1</property>
> </data>
> <data id="393">
> <property name="fontSize">smaller</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">title2</property>
> <expression
> name="expression">arrTitle1[1]</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">title2</property>
> </data>
> <data id="394">
> <property name="fontSize">smaller</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">title3</property>
> <expression
> name="expression">arrTitle1[2]</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">title3</property>
> </data>
> <data id="413">
> <property name="fontSize">smaller</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">title4</property>
> <expression
> name="expression">arrTitle1[3]</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">title4</property>
> </data>
> <data id="478">
> <property name="fontSize">smaller</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">title5</property>
> <expression
> name="expression">arrTitle1[4]</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property name="resultSetColumn">title5</property>
> </data>
> </cell>
> <cell id="358">
> <text id="297">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<center>
> <h3>Shin Yang Sdn Bhd</h3><br>
> <h4>Stock Opening And Closing Analysis Testing Report</h4>
> </center><br>]]></text-property>
> </text>
> </cell>
> <cell id="359">
> <text id="299">
> <property name="fontSize">smaller</property>
> <property name="textAlign">right</property>
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of
> format="dd-MM-yyyy">new Date()</value-of>]]></text-property>
> </text>
> </cell>
> </row>
> </grid>
> <grid id="746">
> <property name="fontSize">x-small</property>
> <property name="width">100%</property>
> <column id="747">
> <property name="width">5cm</property>
> </column>
> <column id="748">
> <property name="width">2cm</property>
> <property name="textAlign">center</property>
> </column>
> <column id="749">
> <property name="width">6cm</property>
> <property name="textAlign">center</property>
> </column>
> <column id="750">
> <property name="width">6cm</property>
> <property name="textAlign">center</property>
> </column>
> <column id="751">
> <property name="width">2cm</property>
> <property name="textAlign">center</property>
> </column>
> <row id="752">
> <cell id="753"/>
> <cell id="754">
> <label id="758">
> <property name="textAlign">center</property>
> <text-property name="text"><-----OPENING
> BALANCE-----></text-property>
> </label>
> </cell>
> <cell id="755">
> <label id="759">
> <property name="textAlign">center</property>
> <text-property
> name="text"><------------------RECEIVINGS------------------ ></text-property>
> </label>
> </cell>
> <cell id="756">
> <label id="760">
> <property name="textAlign">center</property>
> <text-property
> name="text"><--------------------ISSUINGS-------------------- ></text-property>
> </label>
> </cell>
> <cell id="757">
> <label id="761">
> <property name="textAlign">center</property>
> <text-property name="text"><-----CLOSING
> BALANCE-----></text-property>
> </label>
> </cell>
> </row>
> </grid>
> <table id="2140">
> <property name="fontSize">x-small</property>
> <property name="width">100%</property>
> <property name="dataSet">stock</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CATEGORY</property>
> <expression
> name="expression">dataSetRow["CATEGORY"]+" -
> "+dataSetRow["DESCRIPTION"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">DESCRIPTION</property>
> <expression
> name="expression">dataSetRow["DESCRIPTION"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">SUB_CATEGORY</property>
> <expression
> name="expression">dataSetRow["SUB_CATEGORY"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">QTY</property>
> <expression
> name="expression">dataSetRow["QTY"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">PART_ID</property>
> <expression
> name="expression">dataSetRow["PART_ID"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">UNIT_PRICE</property>
> <expression
> name="expression">dataSetRow["UNIT_PRICE"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">AMOUNT</property>
> <expression
> name="expression">dataSetRow["AMOUNT"]</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="na

Previous Topic:	Dynamic Table Columns
Next Topic:	Pagination question

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 02 05:17:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter