| DateTime value "{0}" is invalid [message #361434] |
Mon, 31 March 2008 08:40  |
Eclipse User |
|
|
|
Hello,
I'am using BIRT 2.2.2 and postgres 8.3.
I have a dataset over a table with a date column.
I create a datacube with a group linked to this column with 2 Date
levels year and month.
I create a crossTab linked to this datacube.
When I preview the report with an empty dataset (no results), a birt
exception occurred.
nota: this report works perfectly on BIRT 2.2
Is it a bug ? a know bug ? does workround exist ?
thanks in advance
Manu
exception trace:
DateTime value "{0}" is invalid. ( 2 time(s) )
detail : org.eclipse.birt.report.data.adapter.api.AdapterException:
DateTime value "{0}" is invalid. at
org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.prepare(DataRequestSessionImpl.java:483)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.doPrep areQuery(DteDataEngine.java:100)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.p repare(AbstractDataEngine.java:138)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:94)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportExecutor.execute(WrappedReportExecutor.java:59)
at
org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplciateReportExecutor.execute(SuppressDuplciateReportExec utor.java:51)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportExecutor.execute(WrappedReportExecutor.java:59)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:138)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:68)
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.BirtGetPageAll ActionHandler.__execute(Unknown
Source) at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
Source) at
org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(Unknown
Source) at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(Unknown
Source) at
org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleGetPageAll(Unknown
Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(Unknown
Source) at
org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(Unknown
Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)
at
org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider.java:186)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323)
at
org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at
org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at
org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService .java:453)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 ) at
org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:699)
at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(Unknown
Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown Source)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:213)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)
|
|
|
|
| Re: DateTime value "{0}" is invalid [message #361760 is a reply to message #361562] |
Mon, 14 April 2008 23:48  |
Eclipse User |
|
|
|
Hi, This is a known bug and has been fixed in 2.3RC0.
Thanks.
Lin
"md" <manuel.davinha@nqicorp.com> wrote in message
news:ftd7qo$s7$1@build.eclipse.org...
> Hello,
>
> I join a report with "Classic Models Inc" datasource to explain my
> problem.
>
>
> thanks
> Manu
>
>
>>
>> Hello,
>>
>> I'am using BIRT 2.2.2 and postgres 8.3.
>>
>> I have a dataset over a table with a date column.
>> I create a datacube with a group linked to this column with 2 Date
>> levels year and month.
>>
>> I create a crossTab linked to this datacube.
>>
>> When I preview the report with an empty dataset (no results), a birt
>> exception occurred.
>>
>>
>> nota: this report works perfectly on BIRT 2.2
>>
>> Is it a bug ? a know bug ? does workround exist ?
>>
>>
>> thanks in advance
>> Manu
>>
>>
>> exception trace:
>>
>>
>>
>> DateTime value "{0}" is invalid. ( 2 time(s) )
>> detail : org.eclipse.birt.report.data.adapter.api.AdapterException:
>> DateTime value "{0}" is invalid. at
>> org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.prepare(DataRequestSessionImpl.java:483)
>> at
>> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doPrep areQuery(DteDataEngine.java:100)
>> at
>> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.p repare(AbstractDataEngine.java:138)
>> at
>> org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:94)
>> at
>> org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportExecutor.execute(WrappedReportExecutor.java:59)
>> at
>> org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplciateReportExecutor.execute(SuppressDuplciateReportExec utor.java:51)
>> at
>> org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportExecutor.execute(WrappedReportExecutor.java:59)
>> at
>> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:138)
>> at
>> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:68)
>> 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.BirtGetPageAll ActionHandler.__execute(Unknown
>> Source) at
>> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(Unknown
>> Source) at
>> org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(Unknown
>> Source) at
>> org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(Unknown
>> Source) at
>> org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleGetPageAll(Unknown
>> Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
>> java.lang.reflect.Method.invoke(Unknown Source) at
>> org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(Unknown
>> Source) at
>> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(Unknown
>> Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
>> java.lang.reflect.Method.invoke(Unknown Source) at
>> org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)
>> at
>> org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider.java:186)
>> at
>> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323)
>> at
>> org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.java:32)
>> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at
>> org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at
>> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService .java:453)
>> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 ) at
>> org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:699)
>> at
>> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(Unknown
>> Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>> at
>> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:247)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
>> at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown Source)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:213)
>> at
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:193)
>> at
>> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:256)
>> at
>> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
>> at
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
>> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
>> at
>> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
>> at
>> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
>> at
>> org.apache.catalina.valves.CertificatesValve.invoke(Certific atesValve.java:246)
>> at
>> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
>> at
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
>> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
>> at
>> org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2422)
>> at
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:180)
>> at
>> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
>> at
>> org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:171)
>> at
>> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
>> at
>> org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(E clipseErrorReportValve.java:153)
>> at
>> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:641)
>> at
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
>> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
>> at
>> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:174)
>> at
>> org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:643)
>> at
>> org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:480)
>> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:995)
>> at
>> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:199)
>> at
>> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:828)
>> at
>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:700)
>> at
>> org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:584)
>> at
>> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
>> at java.lang.Thread.run(Unknown Source)
>>
>
>
------------------------------------------------------------ --------------------
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.2.2.r222_v20071226 Build <2.2.2.v20080227-1131></property>
> <property name="units">in</property>
> <property name="comments">Copyright (c) 2007 <<Your Company Name
> here>></property>
> <html-property name="description">Creates a blank report with no
> predefined content.</html-property>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <parameters>
> <scalar-parameter name="date" id="12">
> <property name="valueType">static</property>
> <property name="dataType">date</property>
> <property name="paramType">simple</property>
> <property name="concealValue">false</property>
> <property name="isRequired">false</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">2006-01-01</property>
> <property name="distinct">true</property>
> <structure name="format">
> <property name="category">Short Date</property>
> <property name="pattern">Short Date</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="6">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="dsOrders" id="7">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">ORDERNUMBER</property>
> <property name="displayName">ORDERNUMBER</property>
> </structure>
> <structure>
> <property name="columnName">PRODUCTCODE</property>
> <property name="displayName">PRODUCTCODE</property>
> </structure>
> <structure>
> <property name="columnName">QUANTITYORDERED</property>
> <property name="displayName">QUANTITYORDERED</property>
> </structure>
> <structure>
> <property name="columnName">PRICEEACH</property>
> <property name="displayName">PRICEEACH</property>
> </structure>
> <structure>
> <property name="columnName">ORDERLINENUMBER</property>
> <property name="displayName">ORDERLINENUMBER</property>
> </structure>
> <structure>
> <property name="columnName">ORDERTOTAL</property>
> <property name="displayName">ORDERTOTAL</property>
> </structure>
> <structure>
> <property name="columnName">ORDERDATE</property>
> <property name="displayName">ORDERDATE</property>
> </structure>
> <structure>
> <property name="columnName">STATUS</property>
> <property name="displayName">STATUS</property>
> </structure>
> <structure>
> <property name="columnName">CUSTOMERNUMBER</property>
> <property name="displayName">CUSTOMERNUMBER</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">ORDERTOTAL</property>
> <property name="dataType">float</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ORDERDATE</property>
> <property name="dataType">date</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">STATUS</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">date</property>
> <property name="paramName">date</property>
> <property name="nativeName"></property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> <property name="position">1</property>
> <property name="isOptional">false</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> </list-property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">ORDERNUMBER</property>
> <property name="nativeName">ORDERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">PRODUCTCODE</property>
> <property name="nativeName">PRODUCTCODE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">QUANTITYORDERED</property>
> <property name="nativeName">QUANTITYORDERED</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PRICEEACH</property>
> <property name="nativeName">PRICEEACH</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">ORDERLINENUMBER</property>
> <property name="nativeName">ORDERLINENUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">5</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">ORDERTOTAL</property>
> <property name="nativeName">ORDERTOTAL</property>
> <property name="dataType">float</property>
> <property name="nativeDataType">8</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ORDERDATE</property>
> <property name="nativeName">ORDERDATE</property>
> <property name="dataType">date</property>
> <property name="nativeDataType">91</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">STATUS</property>
> <property name="nativeName">STATUS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">CUSTOMERNUMBER</property>
> <property name="nativeName">CUSTOMERNUMBER</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">4</property>
> </structure>
> </list-property>
> <property name="queryText">select
> CLASSICMODELS.ORDERDETAILS.ORDERNUMBER,
> CLASSICMODELS.ORDERDETAILS.PRODUCTCODE,
> CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED,
> CLASSICMODELS.ORDERDETAILS.PRICEEACH,
> CLASSICMODELS.ORDERDETAILS.ORDERLINENUMBER,
> CLASSICMODELS.ORDERDETAILS.QUANTITYORDERED *
> CLASSICMODELS.ORDERDETAILS.PRICEEACH as orderTotal,
> CLASSICMODELS.ORDERS.ORDERDATE,
> CLASSICMODELS.ORDERS.STATUS,
> CLASSICMODELS.ORDERS.CUSTOMERNUMBER
> from
> CLASSICMODELS.ORDERS,
> CLASSICMODELS.ORDERDETAILS
> where
> CLASSICMODELS.ORDERS.ORDERNUMBER=CLASSICMODELS.ORDERDETAILS. ORDERNUMBER
> and CLASSICMODELS.ORDERS.ORDERDATE > ?
>
>
> </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:DataSetParameters>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>91</design:nativeDataTypeCode>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:defaultScalarValue>2005-01-01</design:defaultScalarValue >
> <design:optional>false</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> </design:DataSetParameters>
> </model:DesignValues>]]></xml-property>
> </oda-data-set>
> </data-sets>
> <cubes>
> <tabular-cube name="Data Cube" id="8">
> <property name="dimensions">
> <tabular-dimension name="rowGroup" id="9">
> <property name="isTimeType">true</property>
> <property
> name="defaultHierarchy">NewTabularHierarchy</property>
> <property name="hierarchies">
> <tabular-hierarchy name="NewTabularHierarchy"
> id="10">
> <property name="levels">
> <tabular-level name="year" id="11">
> <property
> name="dataType">integer</property>
> <property
> name="dateTimeLevelType">year</property>
> <list-property name="attributes">
> <structure>
> <property
> name="name">DateTime</property>
> <property
> name="dataType">date-time</property>
> </structure>
> </list-property>
> <property
> name="columnName">ORDERDATE</property>
> </tabular-level>
> </property>
> </tabular-hierarchy>
> </property>
> </tabular-dimension>
> </property>
> <property name="dataSet">dsOrders</property>
> </tabular-cube>
> </cubes>
> <styles>
> <style name="crosstab-cell" id="4">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<value-of>new
> Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <extended-item extensionName="Crosstab" id="13">
> <property name="rows">
> <extended-item extensionName="CrosstabView" id="14">
> <property name="views">
> <extended-item extensionName="DimensionView"
> id="15">
> <property name="dimension">rowGroup</property>
> <property name="levels">
> <extended-item extensionName="LevelView"
> name="NewLevel View" id="16">
> <property
> name="level">rowGroup/year</property>
> <property name="member">
> <extended-item
> extensionName="CrosstabCell" id="17">
> <property name="content">
> <data name="year" id="18">
> <property
> name="resultSetColumn">year</property>
> </data>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> </extended-item>
> </property>
> <property name="cube">Data Cube</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">year</property>
> <expression
> name="expression">dimension["rowGroup"]["year"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </extended-item>
> </body>
> </report>
>
|
|
|
Powered by
FUDForum. Page generated in 0.17891 seconds