Home » Archived » BIRT » Sample DB & ReferenceError
| Sample DB & ReferenceError [message #250576] |
Tue, 31 July 2007 17:10  |
Eclipse User |
|
|
|
Originally posted by: xxxx.xxx.com
Hello, I am using Birt 2.2 and noticed couple of things that I have nt
noticed in Birt 2.1.2.
1) When I start the report engine,I can see a sample database is created
in local drive. Is it necessary? If not,how can I avoid that.
2) When I run a report that is developed in 2.1.2, with the 2.2 Birt
engine, from a java application, I am getting an error:
SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam" is not
defined.
(<inline>#1)
at
org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
a:3240)
Why is that?
If any can shed some light on it, that would be really great.
Thanks
|
|
|
| Re: Sample DB & ReferenceError [message #250612 is a reply to message #250576] |
Tue, 31 July 2007 19:53  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Kris,
if you do not want the sample db remove it from the plugins directory
and it will not show up anymore.
For the second issue can you post the report?
Jason
Kris wrote:
> Hello, I am using Birt 2.2 and noticed couple of things that I have nt
> noticed in Birt 2.1.2.
>
> 1) When I start the report engine,I can see a sample database is created
> in local drive. Is it necessary? If not,how can I avoid that.
>
> 2) When I run a report that is developed in 2.1.2, with the 2.2 Birt
> engine, from a java application, I am getting an error:
>
> SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
> org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam" is not
> defined.
> (<inline>#1)
> at
> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
> a:3240)
>
> Why is that?
>
> If any can shed some light on it, that would be really great.
>
> Thanks
|
|
|
| Re: Sample DB & ReferenceError [message #250642 is a reply to message #250612] |
Tue, 31 July 2007 20:31 |
| Eclipse User |
|
|
|
Originally posted by: xxxx.xxx.com
This is a multi-part message in MIME format.
--------------000709000309010201080908
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Thanks Jason., I will try removing that.
For the second problem, I am attaching the report.
Thanks
Jason Weathersby wrote:
> Kris,
>
> if you do not want the sample db remove it from the plugins directory
> and it will not show up anymore.
>
> For the second issue can you post the report?
>
> Jason
>
> Kris wrote:
>> Hello, I am using Birt 2.2 and noticed couple of things that I have nt
>> noticed in Birt 2.1.2.
>>
>> 1) When I start the report engine,I can see a sample database is
>> created in local drive. Is it necessary? If not,how can I avoid that.
>>
>> 2) When I run a report that is developed in 2.1.2, with the 2.2 Birt
>> engine, from a java application, I am getting an error:
>>
>> SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
>> org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam" is
>> not defined.
>> (<inline>#1)
>> at
>> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
>> a:3240)
>>
>> Why is that?
>>
>> If any can shed some light on it, that would be really great.
>>
>> Thanks
--------------000709000309010201080908
Content-Type: text/xml;
name="report.xml"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="report.xml"
<?xml version="1.0" encoding="UTF-8"?>
<!-- Written by Eclipse BIRT 2.0 -->
<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>
<parameters>
<scalar-parameter name="RP_filetype" id="6">
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="allowNull">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">Email Files</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="RP_datestamp" id="7">
<property name="valueType">static</property>
<property name="dataType">dateTime</property>
<property name="concealValue">false</property>
<property name="allowNull">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">2007-05-25T00:00:00.000</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="RP_filecount" id="40">
<property name="valueType">static</property>
<property name="dataType">integer</property>
<property name="allowNull">true</property>
<property name="controlType">text-box</property>
<property name="defaultValue">1</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">oracle.jdbc.OracleDriver</property>
<property name="odaURL">jdbc:oracle:thin:@host:1521:TableDB</property >
<property name="odaUser">Table</property>
<encrypted-property name="odaPassword">QTk2MjE2N</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Data Set" id="5">
<structure name="cachedMetaData"/>
<property name="dataSource">Data Source</property>
<list-property name="parameters">
<structure>
<property name="name">param1</property>
<property name="paramName">RP_filetype</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">0</property>
<property name="position">1</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param2</property>
<property name="paramName">RP_datestamp</property>
<property name="nativeName"></property>
<property name="dataType">dateTime</property>
<property name="nativeDataType">0</property>
<property name="position">2</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">param3</property>
<property name="paramName">RP_filecount</property>
<property name="nativeName"></property>
<property name="dataType">any</property>
<property name="nativeDataType">0</property>
<property name="position">3</property>
<property name="isOptional">true</property>
<property name="allowNull">true</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<property name="queryText">select *
from Table
where filetypename = ? and datestamp < ?
and filecount > ?
order by datestamp</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>0</design:nativeDataTypeCode>
<design:nullability>Nullable</design:nullability>
<design:uiHints/>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>Email Files</design:defaultScalarValue>
<design:optional>true</design:optional>
<design:masksValue>false</design:masksValue>
<design:uiHints>
<design:promptStyle>TextField</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>2</design:position>
<design:nativeDataTypeCode>0</design:nativeDataTypeCode>
<design:nullability>Nullable</design:nullability>
<design:uiHints/>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:defaultScalarValue>2007-05-25T00:00:00.000</design:defaultScalarValue >
<design:optional>true</design:optional>
<design:masksValue>false</design:masksValue>
<design:uiHints>
<design:promptStyle>TextField</design:promptStyle>
</design:uiHints>
</design:elementAttributes>
</design:inputAttributes>
</design:parameterDefinitions>
<design:parameterDefinitions>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:name></design:name>
<design:position>3</design:position>
<design:nativeDataTypeCode>0</design:nativeDataTypeCode>
<design:nullability>Nullable</design:nullability>
<design:uiHints/>
</design:attributes>
<design:inputAttributes>
<design:elementAttributes>
<design:optional>true</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>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="topMargin">0.1458333333in</property>
<property name="leftMargin">0.2291666667in</property>
<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>
<grid id="12">
<property name="height">0.9895833333in</property>
<property name="width">7.0104166667in</property>
<column id="13"/>
<row id="14">
<property name="height">0.5104166667in</property>
<cell id="15"/>
</row>
<row id="16">
<property name="height">0.75in</property>
<cell id="17">
<table id="18">
<property name="width">100%</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">FILETYPENAME</property>
<expression name="expression">dataSetRow["FILETYPENAME"]</expression >
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">DATESTAMP</property>
<expression name="expression">dataSetRow["DATESTAMP"]</expression>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="name">FILECOUNT</property>
<expression name="expression">dataSetRow["FILECOUNT"]</expression>
<property name="dataType">decimal</property>
</structure>
</list-property>
<method name="onCreate"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
dataSetParam["param2"] = param["RP_datestamp"];
dataSetParam["param3"] = param["RP_filecount"];]]></method>
<method name="onRender"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
dataSetParam["param2"] = param["RP_datestamp"];
dataSetParam["param3"] = param["RP_filecount"];]]></method>
<column id="31"/>
<column id="32"/>
<column id="33"/>
<header>
<row id="19">
<cell id="20">
<label id="34">
<text-property name="text">FILETYPENAME</text-property>
</label>
</cell>
<cell id="21">
<label id="36">
<text-property name="text">DATESTAMP</text-property>
</label>
</cell>
<cell id="22">
<label id="38">
<text-property name="text">FILECOUNT</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="23">
<cell id="24">
<data id="35">
<property name="resultSetColumn">FILETYPENAME</property>
</data>
</cell>
<cell id="25">
<data id="37">
<property name="resultSetColumn">DATESTAMP</property>
</data>
</cell>
<cell id="26">
<data id="39">
<property name="resultSetColumn">FILECOUNT</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="27">
<cell id="28"/>
<cell id="29"/>
<cell id="30"/>
</row>
</footer>
</table>
</cell>
</row>
</grid>
</body>
</report>
--------------000709000309010201080908--
|
|
|
| Re: Sample DB & ReferenceError [message #250748 is a reply to message #250642] |
Wed, 01 August 2007 14:29 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Kris
You have these lines in script
dataSetParam["param1"] = param["RP_filetype"];
dataSetParam["param2"] = param["RP_datestamp"];
dataSetParam["param3"] = param["RP_filecount"];
This should not be needed, because you are linking them in the dataset.
If you were changing them based on row values in the table you would use
the binding edior (binding tab on the table element) and select the
dataset parameter binding button.
Jason
Kris wrote:
> Thanks Jason., I will try removing that.
>
> For the second problem, I am attaching the report.
>
> Thanks
>
> Jason Weathersby wrote:
>> Kris,
>>
>> if you do not want the sample db remove it from the plugins directory
>> and it will not show up anymore.
>>
>> For the second issue can you post the report?
>>
>> Jason
>>
>> Kris wrote:
>>> Hello, I am using Birt 2.2 and noticed couple of things that I have
>>> nt noticed in Birt 2.1.2.
>>>
>>> 1) When I start the report engine,I can see a sample database is
>>> created in local drive. Is it necessary? If not,how can I avoid that.
>>>
>>> 2) When I run a report that is developed in 2.1.2, with the 2.2 Birt
>>> engine, from a java application, I am getting an error:
>>>
>>> SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
>>> org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam" is
>>> not defined.
>>> (<inline>#1)
>>> at
>>> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
>>> a:3240)
>>>
>>> Why is that?
>>>
>>> If any can shed some light on it, that would be really great.
>>>
>>> Thanks
>
>
> ------------------------------------------------------------ ------------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- Written by Eclipse BIRT 2.0 -->
> <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>
> <parameters>
> <scalar-parameter name="RP_filetype" id="6">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <property name="allowNull">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">Email Files</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="RP_datestamp" id="7">
> <property name="valueType">static</property>
> <property name="dataType">dateTime</property>
> <property name="concealValue">false</property>
> <property name="allowNull">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">2007-05-25T00:00:00.000</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="RP_filecount" id="40">
> <property name="valueType">static</property>
> <property name="dataType">integer</property>
> <property name="allowNull">true</property>
> <property name="controlType">text-box</property>
> <property name="defaultValue">1</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">oracle.jdbc.OracleDriver</property>
> <property name="odaURL">jdbc:oracle:thin:@host:1521:TableDB</property >
> <property name="odaUser">Table</property>
> <encrypted-property name="odaPassword">QTk2MjE2N</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet " name="Data Set" id="5">
> <structure name="cachedMetaData"/>
> <property name="dataSource">Data Source</property>
> <list-property name="parameters">
> <structure>
> <property name="name">param1</property>
> <property name="paramName">RP_filetype</property>
> <property name="nativeName"></property>
> <property name="dataType">string</property>
> <property name="nativeDataType">0</property>
> <property name="position">1</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param2</property>
> <property name="paramName">RP_datestamp</property>
> <property name="nativeName"></property>
> <property name="dataType">dateTime</property>
> <property name="nativeDataType">0</property>
> <property name="position">2</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">param3</property>
> <property name="paramName">RP_filecount</property>
> <property name="nativeName"></property>
> <property name="dataType">any</property>
> <property name="nativeDataType">0</property>
> <property name="position">3</property>
> <property name="isOptional">true</property>
> <property name="allowNull">true</property>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> </list-property>
> <property name="queryText">select *
> from Table
> where filetypename = ? and datestamp < ?
> and filecount > ?
> order by datestamp</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>0</design:nativeDataTypeCode>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:defaultScalarValue>Email Files</design:defaultScalarValue>
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>2</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:defaultScalarValue>2007-05-25T00:00:00.000</design:defaultScalarValue >
> <design:optional>true</design:optional>
> <design:masksValue>false</design:masksValue>
> <design:uiHints>
> <design:promptStyle>TextField</design:promptStyle>
> </design:uiHints>
> </design:elementAttributes>
> </design:inputAttributes>
> </design:parameterDefinitions>
> <design:parameterDefinitions>
> <design:inOutMode>In</design:inOutMode>
> <design:attributes>
> <design:name></design:name>
> <design:position>3</design:position>
> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints/>
> </design:attributes>
> <design:inputAttributes>
> <design:elementAttributes>
> <design:optional>true</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>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="topMargin">0.1458333333in</property>
> <property name="leftMargin">0.2291666667in</property>
> <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>
> <grid id="12">
> <property name="height">0.9895833333in</property>
> <property name="width">7.0104166667in</property>
> <column id="13"/>
> <row id="14">
> <property name="height">0.5104166667in</property>
> <cell id="15"/>
> </row>
> <row id="16">
> <property name="height">0.75in</property>
> <cell id="17">
> <table id="18">
> <property name="width">100%</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">FILETYPENAME</property>
> <expression name="expression">dataSetRow["FILETYPENAME"]</expression >
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">DATESTAMP</property>
> <expression name="expression">dataSetRow["DATESTAMP"]</expression>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="name">FILECOUNT</property>
> <expression name="expression">dataSetRow["FILECOUNT"]</expression>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <method name="onCreate"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
> dataSetParam["param2"] = param["RP_datestamp"];
> dataSetParam["param3"] = param["RP_filecount"];]]></method>
> <method name="onRender"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
> dataSetParam["param2"] = param["RP_datestamp"];
> dataSetParam["param3"] = param["RP_filecount"];]]></method>
> <column id="31"/>
> <column id="32"/>
> <column id="33"/>
> <header>
> <row id="19">
> <cell id="20">
> <label id="34">
> <text-property name="text">FILETYPENAME</text-property>
> </label>
> </cell>
> <cell id="21">
> <label id="36">
> <text-property name="text">DATESTAMP</text-property>
> </label>
> </cell>
> <cell id="22">
> <label id="38">
> <text-property name="text">FILECOUNT</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="23">
> <cell id="24">
> <data id="35">
> <property name="resultSetColumn">FILETYPENAME</property>
> </data>
> </cell>
> <cell id="25">
> <data id="37">
> <property name="resultSetColumn">DATESTAMP</property>
> </data>
> </cell>
> <cell id="26">
> <data id="39">
> <property name="resultSetColumn">FILECOUNT</property>
> </data>
> </cell>
> </row>
> </detail>
> <footer>
> <row id="27">
> <cell id="28"/>
> <cell id="29"/>
> <cell id="30"/>
> </row>
> </footer>
> </table>
> </cell>
> </row>
> </grid>
> </body>
> </report>
|
|
|
| Re: Sample DB & ReferenceError [message #250750 is a reply to message #250748] |
Wed, 01 August 2007 14:34 |
| Eclipse User |
|
|
|
Originally posted by: xxxx.xxx.com
Thanks Jason.
Just curious; may be this check they might have added new in 2.2 (The
report ran fine with 2.1)
Thanks again for the clarification.
Jason Weathersby wrote:
> Kris
>
> You have these lines in script
>
> dataSetParam["param1"] = param["RP_filetype"];
> dataSetParam["param2"] = param["RP_datestamp"];
> dataSetParam["param3"] = param["RP_filecount"];
>
> This should not be needed, because you are linking them in the dataset.
> If you were changing them based on row values in the table you would use
> the binding edior (binding tab on the table element) and select the
> dataset parameter binding button.
>
> Jason
>
> Kris wrote:
>> Thanks Jason., I will try removing that.
>>
>> For the second problem, I am attaching the report.
>>
>> Thanks
>>
>> Jason Weathersby wrote:
>>> Kris,
>>>
>>> if you do not want the sample db remove it from the plugins directory
>>> and it will not show up anymore.
>>>
>>> For the second issue can you post the report?
>>>
>>> Jason
>>>
>>> Kris wrote:
>>>> Hello, I am using Birt 2.2 and noticed couple of things that I have
>>>> nt noticed in Birt 2.1.2.
>>>>
>>>> 1) When I start the report engine,I can see a sample database is
>>>> created in local drive. Is it necessary? If not,how can I avoid that.
>>>>
>>>> 2) When I run a report that is developed in 2.1.2, with the 2.2 Birt
>>>> engine, from a java application, I am getting an error:
>>>>
>>>> SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
>>>> org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam" is
>>>> not defined.
>>>> (<inline>#1)
>>>> at
>>>> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
>>>> a:3240)
>>>>
>>>> Why is that?
>>>>
>>>> If any can shed some light on it, that would be really great.
>>>>
>>>> Thanks
>>
>>
>> ------------------------------------------------------------ ------------
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <!-- Written by Eclipse BIRT 2.0 -->
>> <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>
>> <parameters>
>> <scalar-parameter name="RP_filetype" id="6">
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <property name="allowNull">true</property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">Email Files</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="RP_datestamp" id="7">
>> <property name="valueType">static</property>
>> <property name="dataType">dateTime</property>
>> <property name="concealValue">false</property>
>> <property name="allowNull">true</property>
>> <property name="controlType">text-box</property>
>> <property
>> name="defaultValue">2007-05-25T00:00:00.000</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="RP_filecount" id="40">
>> <property name="valueType">static</property>
>> <property name="dataType">integer</property>
>> <property name="allowNull">true</property>
>> <property name="controlType">text-box</property>
>> <property name="defaultValue">1</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">oracle.jdbc.OracleDriver</property>
>> <property
>> name="odaURL">jdbc:oracle:thin:@host:1521:TableDB</property >
>> <property name="odaUser">Table</property>
>> <encrypted-property
>> name="odaPassword">QTk2MjE2N</encrypted-property>
>> </oda-data-source>
>> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Data Set" id="5">
>> <structure name="cachedMetaData"/>
>> <property name="dataSource">Data Source</property>
>> <list-property name="parameters">
>> <structure>
>> <property name="name">param1</property>
>> <property name="paramName">RP_filetype</property>
>> <property name="nativeName"></property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">0</property>
>> <property name="position">1</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> <structure>
>> <property name="name">param2</property>
>> <property name="paramName">RP_datestamp</property>
>> <property name="nativeName"></property>
>> <property name="dataType">dateTime</property>
>> <property name="nativeDataType">0</property>
>> <property name="position">2</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> <structure>
>> <property name="name">param3</property>
>> <property name="paramName">RP_filecount</property>
>> <property name="nativeName"></property>
>> <property name="dataType">any</property>
>> <property name="nativeDataType">0</property>
>> <property name="position">3</property>
>> <property name="isOptional">true</property>
>> <property name="allowNull">true</property>
>> <property name="isInput">true</property>
>> <property name="isOutput">false</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select *
>> from Table
>> where filetypename = ? and datestamp < ?
>> and filecount > ?
>> order by datestamp</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>0</design:nativeDataTypeCode>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints/>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>> <design:defaultScalarValue>Email
>> Files</design:defaultScalarValue>
>> <design:optional>true</design:optional>
>> <design:masksValue>false</design:masksValue>
>> <design:uiHints>
>> <design:promptStyle>TextField</design:promptStyle>
>> </design:uiHints>
>> </design:elementAttributes>
>> </design:inputAttributes>
>> </design:parameterDefinitions>
>> <design:parameterDefinitions>
>> <design:inOutMode>In</design:inOutMode>
>> <design:attributes>
>> <design:name></design:name>
>> <design:position>2</design:position>
>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints/>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>>
>> <design:defaultScalarValue>2007-05-25T00:00:00.000</design:defaultScalarValue >
>>
>> <design:optional>true</design:optional>
>> <design:masksValue>false</design:masksValue>
>> <design:uiHints>
>> <design:promptStyle>TextField</design:promptStyle>
>> </design:uiHints>
>> </design:elementAttributes>
>> </design:inputAttributes>
>> </design:parameterDefinitions>
>> <design:parameterDefinitions>
>> <design:inOutMode>In</design:inOutMode>
>> <design:attributes>
>> <design:name></design:name>
>> <design:position>3</design:position>
>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>> <design:nullability>Nullable</design:nullability>
>> <design:uiHints/>
>> </design:attributes>
>> <design:inputAttributes>
>> <design:elementAttributes>
>> <design:optional>true</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>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <property name="topMargin">0.1458333333in</property>
>> <property name="leftMargin">0.2291666667in</property>
>> <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>
>> <grid id="12">
>> <property name="height">0.9895833333in</property>
>> <property name="width">7.0104166667in</property>
>> <column id="13"/>
>> <row id="14">
>> <property name="height">0.5104166667in</property>
>> <cell id="15"/>
>> </row>
>> <row id="16">
>> <property name="height">0.75in</property>
>> <cell id="17">
>> <table id="18">
>> <property name="width">100%</property>
>> <property name="dataSet">Data Set</property>
>> <list-property name="boundDataColumns">
>> <structure>
>> <property
>> name="name">FILETYPENAME</property>
>> <expression
>> name="expression">dataSetRow["FILETYPENAME"]</expression >
>> <property
>> name="dataType">string</property>
>> </structure>
>> <structure>
>> <property
>> name="name">DATESTAMP</property>
>> <expression
>> name="expression">dataSetRow["DATESTAMP"]</expression>
>> <property
>> name="dataType">date-time</property>
>> </structure>
>> <structure>
>> <property
>> name="name">FILECOUNT</property>
>> <expression
>> name="expression">dataSetRow["FILECOUNT"]</expression>
>> <property
>> name="dataType">decimal</property>
>> </structure>
>> </list-property>
>> <method
>> name="onCreate"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>> dataSetParam["param2"] = param["RP_datestamp"];
>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>> <method
>> name="onRender"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>> dataSetParam["param2"] = param["RP_datestamp"];
>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>> <column id="31"/>
>> <column id="32"/>
>> <column id="33"/>
>> <header>
>> <row id="19">
>> <cell id="20">
>> <label id="34">
>> <text-property
>> name="text">FILETYPENAME</text-property>
>> </label>
>> </cell>
>> <cell id="21">
>> <label id="36">
>> <text-property
>> name="text">DATESTAMP</text-property>
>> </label>
>> </cell>
>> <cell id="22">
>> <label id="38">
>> <text-property
>> name="text">FILECOUNT</text-property>
>> </label>
>> </cell>
>> </row>
>> </header>
>> <detail>
>> <row id="23">
>> <cell id="24">
>> <data id="35">
>> <property
>> name="resultSetColumn">FILETYPENAME</property>
>> </data>
>> </cell>
>> <cell id="25">
>> <data id="37">
>> <property
>> name="resultSetColumn">DATESTAMP</property>
>> </data>
>> </cell>
>> <cell id="26">
>> <data id="39">
>> <property
>> name="resultSetColumn">FILECOUNT</property>
>> </data>
>> </cell>
>> </row>
>> </detail>
>> <footer>
>> <row id="27">
>> <cell id="28"/>
>> <cell id="29"/>
>> <cell id="30"/>
>> </row>
>> </footer>
>> </table>
>> </cell>
>> </row>
>> </grid>
>> </body>
>> </report>
|
|
|
| Re: Sample DB & ReferenceError [message #250752 is a reply to message #250750] |
Wed, 01 August 2007 14:41 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Kris,
2.2 added the binding editor I believe.
Jason
Kris wrote:
> Thanks Jason.
>
> Just curious; may be this check they might have added new in 2.2 (The
> report ran fine with 2.1)
>
> Thanks again for the clarification.
>
> Jason Weathersby wrote:
>> Kris
>>
>> You have these lines in script
>>
>> dataSetParam["param1"] = param["RP_filetype"];
>> dataSetParam["param2"] = param["RP_datestamp"];
>> dataSetParam["param3"] = param["RP_filecount"];
>>
>> This should not be needed, because you are linking them in the dataset.
>> If you were changing them based on row values in the table you would
>> use the binding edior (binding tab on the table element) and select
>> the dataset parameter binding button.
>>
>> Jason
>>
>> Kris wrote:
>>> Thanks Jason., I will try removing that.
>>>
>>> For the second problem, I am attaching the report.
>>>
>>> Thanks
>>>
>>> Jason Weathersby wrote:
>>>> Kris,
>>>>
>>>> if you do not want the sample db remove it from the plugins
>>>> directory and it will not show up anymore.
>>>>
>>>> For the second issue can you post the report?
>>>>
>>>> Jason
>>>>
>>>> Kris wrote:
>>>>> Hello, I am using Birt 2.2 and noticed couple of things that I have
>>>>> nt noticed in Birt 2.1.2.
>>>>>
>>>>> 1) When I start the report engine,I can see a sample database is
>>>>> created in local drive. Is it necessary? If not,how can I avoid that.
>>>>>
>>>>> 2) When I run a report that is developed in 2.1.2, with the 2.2
>>>>> Birt engine, from a java application, I am getting an error:
>>>>>
>>>>> SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
>>>>> org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam" is
>>>>> not defined.
>>>>> (<inline>#1)
>>>>> at
>>>>> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
>>>>> a:3240)
>>>>>
>>>>> Why is that?
>>>>>
>>>>> If any can shed some light on it, that would be really great.
>>>>>
>>>>> Thanks
>>>
>>>
>>> ------------------------------------------------------------ ------------
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <!-- Written by Eclipse BIRT 2.0 -->
>>> <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>
>>> <parameters>
>>> <scalar-parameter name="RP_filetype" id="6">
>>> <property name="valueType">static</property>
>>> <property name="dataType">string</property>
>>> <property name="allowNull">true</property>
>>> <property name="controlType">text-box</property>
>>> <property name="defaultValue">Email Files</property>
>>> <structure name="format">
>>> <property name="category">Unformatted</property>
>>> </structure>
>>> </scalar-parameter>
>>> <scalar-parameter name="RP_datestamp" id="7">
>>> <property name="valueType">static</property>
>>> <property name="dataType">dateTime</property>
>>> <property name="concealValue">false</property>
>>> <property name="allowNull">true</property>
>>> <property name="controlType">text-box</property>
>>> <property
>>> name="defaultValue">2007-05-25T00:00:00.000</property>
>>> <structure name="format">
>>> <property name="category">Unformatted</property>
>>> </structure>
>>> </scalar-parameter>
>>> <scalar-parameter name="RP_filecount" id="40">
>>> <property name="valueType">static</property>
>>> <property name="dataType">integer</property>
>>> <property name="allowNull">true</property>
>>> <property name="controlType">text-box</property>
>>> <property name="defaultValue">1</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">oracle.jdbc.OracleDriver</property>
>>> <property
>>> name="odaURL">jdbc:oracle:thin:@host:1521:TableDB</property >
>>> <property name="odaUser">Table</property>
>>> <encrypted-property
>>> name="odaPassword">QTk2MjE2N</encrypted-property>
>>> </oda-data-source>
>>> </data-sources>
>>> <data-sets>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="Data Set" id="5">
>>> <structure name="cachedMetaData"/>
>>> <property name="dataSource">Data Source</property>
>>> <list-property name="parameters">
>>> <structure>
>>> <property name="name">param1</property>
>>> <property name="paramName">RP_filetype</property>
>>> <property name="nativeName"></property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">0</property>
>>> <property name="position">1</property>
>>> <property name="isOptional">true</property>
>>> <property name="allowNull">true</property>
>>> <property name="isInput">true</property>
>>> <property name="isOutput">false</property>
>>> </structure>
>>> <structure>
>>> <property name="name">param2</property>
>>> <property name="paramName">RP_datestamp</property>
>>> <property name="nativeName"></property>
>>> <property name="dataType">dateTime</property>
>>> <property name="nativeDataType">0</property>
>>> <property name="position">2</property>
>>> <property name="isOptional">true</property>
>>> <property name="allowNull">true</property>
>>> <property name="isInput">true</property>
>>> <property name="isOutput">false</property>
>>> </structure>
>>> <structure>
>>> <property name="name">param3</property>
>>> <property name="paramName">RP_filecount</property>
>>> <property name="nativeName"></property>
>>> <property name="dataType">any</property>
>>> <property name="nativeDataType">0</property>
>>> <property name="position">3</property>
>>> <property name="isOptional">true</property>
>>> <property name="allowNull">true</property>
>>> <property name="isInput">true</property>
>>> <property name="isOutput">false</property>
>>> </structure>
>>> </list-property>
>>> <property name="queryText">select *
>>> from Table
>>> where filetypename = ? and datestamp < ?
>>> and filecount > ?
>>> order by datestamp</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>0</design:nativeDataTypeCode>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints/>
>>> </design:attributes>
>>> <design:inputAttributes>
>>> <design:elementAttributes>
>>> <design:defaultScalarValue>Email
>>> Files</design:defaultScalarValue>
>>> <design:optional>true</design:optional>
>>> <design:masksValue>false</design:masksValue>
>>> <design:uiHints>
>>> <design:promptStyle>TextField</design:promptStyle>
>>> </design:uiHints>
>>> </design:elementAttributes>
>>> </design:inputAttributes>
>>> </design:parameterDefinitions>
>>> <design:parameterDefinitions>
>>> <design:inOutMode>In</design:inOutMode>
>>> <design:attributes>
>>> <design:name></design:name>
>>> <design:position>2</design:position>
>>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints/>
>>> </design:attributes>
>>> <design:inputAttributes>
>>> <design:elementAttributes>
>>>
>>> <design:defaultScalarValue>2007-05-25T00:00:00.000</design:defaultScalarValue >
>>>
>>> <design:optional>true</design:optional>
>>> <design:masksValue>false</design:masksValue>
>>> <design:uiHints>
>>> <design:promptStyle>TextField</design:promptStyle>
>>> </design:uiHints>
>>> </design:elementAttributes>
>>> </design:inputAttributes>
>>> </design:parameterDefinitions>
>>> <design:parameterDefinitions>
>>> <design:inOutMode>In</design:inOutMode>
>>> <design:attributes>
>>> <design:name></design:name>
>>> <design:position>3</design:position>
>>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints/>
>>> </design:attributes>
>>> <design:inputAttributes>
>>> <design:elementAttributes>
>>> <design:optional>true</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>
>>> <page-setup>
>>> <simple-master-page name="Simple MasterPage" id="2">
>>> <property name="topMargin">0.1458333333in</property>
>>> <property name="leftMargin">0.2291666667in</property>
>>> <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>
>>> <grid id="12">
>>> <property name="height">0.9895833333in</property>
>>> <property name="width">7.0104166667in</property>
>>> <column id="13"/>
>>> <row id="14">
>>> <property name="height">0.5104166667in</property>
>>> <cell id="15"/>
>>> </row>
>>> <row id="16">
>>> <property name="height">0.75in</property>
>>> <cell id="17">
>>> <table id="18">
>>> <property name="width">100%</property>
>>> <property name="dataSet">Data Set</property>
>>> <list-property name="boundDataColumns">
>>> <structure>
>>> <property
>>> name="name">FILETYPENAME</property>
>>> <expression
>>> name="expression">dataSetRow["FILETYPENAME"]</expression >
>>> <property
>>> name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="name">DATESTAMP</property>
>>> <expression
>>> name="expression">dataSetRow["DATESTAMP"]</expression>
>>> <property
>>> name="dataType">date-time</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="name">FILECOUNT</property>
>>> <expression
>>> name="expression">dataSetRow["FILECOUNT"]</expression>
>>> <property
>>> name="dataType">decimal</property>
>>> </structure>
>>> </list-property>
>>> <method
>>> name="onCreate"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>>> dataSetParam["param2"] = param["RP_datestamp"];
>>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>>> <method
>>> name="onRender"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>>> dataSetParam["param2"] = param["RP_datestamp"];
>>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>>> <column id="31"/>
>>> <column id="32"/>
>>> <column id="33"/>
>>> <header>
>>> <row id="19">
>>> <cell id="20">
>>> <label id="34">
>>> <text-property
>>> name="text">FILETYPENAME</text-property>
>>> </label>
>>> </cell>
>>> <cell id="21">
>>> <label id="36">
>>> <text-property
>>> name="text">DATESTAMP</text-property>
>>> </label>
>>> </cell>
>>> <cell id="22">
>>> <label id="38">
>>> <text-property
>>> name="text">FILECOUNT</text-property>
>>> </label>
>>> </cell>
>>> </row>
>>> </header>
>>> <detail>
>>> <row id="23">
>>> <cell id="24">
>>> <data id="35">
>>> <property
>>> name="resultSetColumn">FILETYPENAME</property>
>>> </data>
>>> </cell>
>>> <cell id="25">
>>> <data id="37">
>>> <property
>>> name="resultSetColumn">DATESTAMP</property>
>>> </data>
>>> </cell>
>>> <cell id="26">
>>> <data id="39">
>>> <property
>>> name="resultSetColumn">FILECOUNT</property>
>>> </data>
>>> </cell>
>>> </row>
>>> </detail>
>>> <footer>
>>> <row id="27">
>>> <cell id="28"/>
>>> <cell id="29"/>
>>> <cell id="30"/>
>>> </row>
>>> </footer>
>>> </table>
>>> </cell>
>>> </row>
>>> </grid>
>>> </body>
>>> </report>
|
|
|
| Re: Sample DB & ReferenceError [message #250844 is a reply to message #250750] |
Wed, 01 August 2007 21:55 |
| Eclipse User |
|
|
|
Originally posted by: xxxx.xxx.com
Jason, on more thing I noticed while browsing through the log files is
that, the new 2.2 Engine throws an error as follows when trying to a report.
SEVERE: Message:The class
[org.eclipse.birt.report.engine.api.script.EngineScrip
tableClassInfo] can not be instantiated. Error
code:FAILED_TO_CREATE_INSTANCE
Could you please tell me what is going on?
Thanks
Kris wrote:
> Thanks Jason.
>
> Just curious; may be this check they might have added new in 2.2 (The
> report ran fine with 2.1)
>
> Thanks again for the clarification.
>
> Jason Weathersby wrote:
>> Kris
>>
>> You have these lines in script
>>
>> dataSetParam["param1"] = param["RP_filetype"];
>> dataSetParam["param2"] = param["RP_datestamp"];
>> dataSetParam["param3"] = param["RP_filecount"];
>>
>> This should not be needed, because you are linking them in the dataset.
>> If you were changing them based on row values in the table you would
>> use the binding edior (binding tab on the table element) and select
>> the dataset parameter binding button.
>>
>> Jason
>>
>> Kris wrote:
>>> Thanks Jason., I will try removing that.
>>>
>>> For the second problem, I am attaching the report.
>>>
>>> Thanks
>>>
>>> Jason Weathersby wrote:
>>>> Kris,
>>>>
>>>> if you do not want the sample db remove it from the plugins
>>>> directory and it will not show up anymore.
>>>>
>>>> For the second issue can you post the report?
>>>>
>>>> Jason
>>>>
>>>> Kris wrote:
>>>>> Hello, I am using Birt 2.2 and noticed couple of things that I have
>>>>> nt noticed in Birt 2.1.2.
>>>>>
>>>>> 1) When I start the report engine,I can see a sample database is
>>>>> created in local drive. Is it necessary? If not,how can I avoid that.
>>>>>
>>>>> 2) When I run a report that is developed in 2.1.2, with the 2.2
>>>>> Birt engine, from a java application, I am getting an error:
>>>>>
>>>>> SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
>>>>> org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam" is
>>>>> not defined.
>>>>> (<inline>#1)
>>>>> at
>>>>> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
>>>>> a:3240)
>>>>>
>>>>> Why is that?
>>>>>
>>>>> If any can shed some light on it, that would be really great.
>>>>>
>>>>> Thanks
>>>
>>>
>>> ------------------------------------------------------------ ------------
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <!-- Written by Eclipse BIRT 2.0 -->
>>> <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>
>>> <parameters>
>>> <scalar-parameter name="RP_filetype" id="6">
>>> <property name="valueType">static</property>
>>> <property name="dataType">string</property>
>>> <property name="allowNull">true</property>
>>> <property name="controlType">text-box</property>
>>> <property name="defaultValue">Email Files</property>
>>> <structure name="format">
>>> <property name="category">Unformatted</property>
>>> </structure>
>>> </scalar-parameter>
>>> <scalar-parameter name="RP_datestamp" id="7">
>>> <property name="valueType">static</property>
>>> <property name="dataType">dateTime</property>
>>> <property name="concealValue">false</property>
>>> <property name="allowNull">true</property>
>>> <property name="controlType">text-box</property>
>>> <property
>>> name="defaultValue">2007-05-25T00:00:00.000</property>
>>> <structure name="format">
>>> <property name="category">Unformatted</property>
>>> </structure>
>>> </scalar-parameter>
>>> <scalar-parameter name="RP_filecount" id="40">
>>> <property name="valueType">static</property>
>>> <property name="dataType">integer</property>
>>> <property name="allowNull">true</property>
>>> <property name="controlType">text-box</property>
>>> <property name="defaultValue">1</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">oracle.jdbc.OracleDriver</property>
>>> <property
>>> name="odaURL">jdbc:oracle:thin:@host:1521:TableDB</property >
>>> <property name="odaUser">Table</property>
>>> <encrypted-property
>>> name="odaPassword">QTk2MjE2N</encrypted-property>
>>> </oda-data-source>
>>> </data-sources>
>>> <data-sets>
>>> <oda-data-set
>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>> name="Data Set" id="5">
>>> <structure name="cachedMetaData"/>
>>> <property name="dataSource">Data Source</property>
>>> <list-property name="parameters">
>>> <structure>
>>> <property name="name">param1</property>
>>> <property name="paramName">RP_filetype</property>
>>> <property name="nativeName"></property>
>>> <property name="dataType">string</property>
>>> <property name="nativeDataType">0</property>
>>> <property name="position">1</property>
>>> <property name="isOptional">true</property>
>>> <property name="allowNull">true</property>
>>> <property name="isInput">true</property>
>>> <property name="isOutput">false</property>
>>> </structure>
>>> <structure>
>>> <property name="name">param2</property>
>>> <property name="paramName">RP_datestamp</property>
>>> <property name="nativeName"></property>
>>> <property name="dataType">dateTime</property>
>>> <property name="nativeDataType">0</property>
>>> <property name="position">2</property>
>>> <property name="isOptional">true</property>
>>> <property name="allowNull">true</property>
>>> <property name="isInput">true</property>
>>> <property name="isOutput">false</property>
>>> </structure>
>>> <structure>
>>> <property name="name">param3</property>
>>> <property name="paramName">RP_filecount</property>
>>> <property name="nativeName"></property>
>>> <property name="dataType">any</property>
>>> <property name="nativeDataType">0</property>
>>> <property name="position">3</property>
>>> <property name="isOptional">true</property>
>>> <property name="allowNull">true</property>
>>> <property name="isInput">true</property>
>>> <property name="isOutput">false</property>
>>> </structure>
>>> </list-property>
>>> <property name="queryText">select *
>>> from Table
>>> where filetypename = ? and datestamp < ?
>>> and filecount > ?
>>> order by datestamp</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>0</design:nativeDataTypeCode>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints/>
>>> </design:attributes>
>>> <design:inputAttributes>
>>> <design:elementAttributes>
>>> <design:defaultScalarValue>Email
>>> Files</design:defaultScalarValue>
>>> <design:optional>true</design:optional>
>>> <design:masksValue>false</design:masksValue>
>>> <design:uiHints>
>>> <design:promptStyle>TextField</design:promptStyle>
>>> </design:uiHints>
>>> </design:elementAttributes>
>>> </design:inputAttributes>
>>> </design:parameterDefinitions>
>>> <design:parameterDefinitions>
>>> <design:inOutMode>In</design:inOutMode>
>>> <design:attributes>
>>> <design:name></design:name>
>>> <design:position>2</design:position>
>>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints/>
>>> </design:attributes>
>>> <design:inputAttributes>
>>> <design:elementAttributes>
>>>
>>> <design:defaultScalarValue>2007-05-25T00:00:00.000</design:defaultScalarValue >
>>>
>>> <design:optional>true</design:optional>
>>> <design:masksValue>false</design:masksValue>
>>> <design:uiHints>
>>> <design:promptStyle>TextField</design:promptStyle>
>>> </design:uiHints>
>>> </design:elementAttributes>
>>> </design:inputAttributes>
>>> </design:parameterDefinitions>
>>> <design:parameterDefinitions>
>>> <design:inOutMode>In</design:inOutMode>
>>> <design:attributes>
>>> <design:name></design:name>
>>> <design:position>3</design:position>
>>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>>> <design:nullability>Nullable</design:nullability>
>>> <design:uiHints/>
>>> </design:attributes>
>>> <design:inputAttributes>
>>> <design:elementAttributes>
>>> <design:optional>true</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>
>>> <page-setup>
>>> <simple-master-page name="Simple MasterPage" id="2">
>>> <property name="topMargin">0.1458333333in</property>
>>> <property name="leftMargin">0.2291666667in</property>
>>> <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>
>>> <grid id="12">
>>> <property name="height">0.9895833333in</property>
>>> <property name="width">7.0104166667in</property>
>>> <column id="13"/>
>>> <row id="14">
>>> <property name="height">0.5104166667in</property>
>>> <cell id="15"/>
>>> </row>
>>> <row id="16">
>>> <property name="height">0.75in</property>
>>> <cell id="17">
>>> <table id="18">
>>> <property name="width">100%</property>
>>> <property name="dataSet">Data Set</property>
>>> <list-property name="boundDataColumns">
>>> <structure>
>>> <property
>>> name="name">FILETYPENAME</property>
>>> <expression
>>> name="expression">dataSetRow["FILETYPENAME"]</expression >
>>> <property
>>> name="dataType">string</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="name">DATESTAMP</property>
>>> <expression
>>> name="expression">dataSetRow["DATESTAMP"]</expression>
>>> <property
>>> name="dataType">date-time</property>
>>> </structure>
>>> <structure>
>>> <property
>>> name="name">FILECOUNT</property>
>>> <expression
>>> name="expression">dataSetRow["FILECOUNT"]</expression>
>>> <property
>>> name="dataType">decimal</property>
>>> </structure>
>>> </list-property>
>>> <method
>>> name="onCreate"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>>> dataSetParam["param2"] = param["RP_datestamp"];
>>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>>> <method
>>> name="onRender"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>>> dataSetParam["param2"] = param["RP_datestamp"];
>>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>>> <column id="31"/>
>>> <column id="32"/>
>>> <column id="33"/>
>>> <header>
>>> <row id="19">
>>> <cell id="20">
>>> <label id="34">
>>> <text-property
>>> name="text">FILETYPENAME</text-property>
>>> </label>
>>> </cell>
>>> <cell id="21">
>>> <label id="36">
>>> <text-property
>>> name="text">DATESTAMP</text-property>
>>> </label>
>>> </cell>
>>> <cell id="22">
>>> <label id="38">
>>> <text-property
>>> name="text">FILECOUNT</text-property>
>>> </label>
>>> </cell>
>>> </row>
>>> </header>
>>> <detail>
>>> <row id="23">
>>> <cell id="24">
>>> <data id="35">
>>> <property
>>> name="resultSetColumn">FILETYPENAME</property>
>>> </data>
>>> </cell>
>>> <cell id="25">
>>> <data id="37">
>>> <property
>>> name="resultSetColumn">DATESTAMP</property>
>>> </data>
>>> </cell>
>>> <cell id="26">
>>> <data id="39">
>>> <property
>>> name="resultSetColumn">FILECOUNT</property>
>>> </data>
>>> </cell>
>>> </row>
>>> </detail>
>>> <footer>
>>> <row id="27">
>>> <cell id="28"/>
>>> <cell id="29"/>
>>> <cell id="30"/>
>>> </row>
>>> </footer>
>>> </table>
>>> </cell>
>>> </row>
>>> </grid>
>>> </body>
>>> </report>
|
|
|
| Re: Sample DB & ReferenceError [message #250867 is a reply to message #250844] |
Thu, 02 August 2007 03:27 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Kris,
I have not seen this error can you log it.
Jason
Kris wrote:
> Jason, on more thing I noticed while browsing through the log files is
> that, the new 2.2 Engine throws an error as follows when trying to a
> report.
>
> SEVERE: Message:The class
> [org.eclipse.birt.report.engine.api.script.EngineScrip
> tableClassInfo] can not be instantiated. Error
> code:FAILED_TO_CREATE_INSTANCE
>
> Could you please tell me what is going on?
>
> Thanks
>
>
> Kris wrote:
>> Thanks Jason.
>>
>> Just curious; may be this check they might have added new in 2.2 (The
>> report ran fine with 2.1)
>>
>> Thanks again for the clarification.
>>
>> Jason Weathersby wrote:
>>> Kris
>>>
>>> You have these lines in script
>>>
>>> dataSetParam["param1"] = param["RP_filetype"];
>>> dataSetParam["param2"] = param["RP_datestamp"];
>>> dataSetParam["param3"] = param["RP_filecount"];
>>>
>>> This should not be needed, because you are linking them in the dataset.
>>> If you were changing them based on row values in the table you would
>>> use the binding edior (binding tab on the table element) and select
>>> the dataset parameter binding button.
>>>
>>> Jason
>>>
>>> Kris wrote:
>>>> Thanks Jason., I will try removing that.
>>>>
>>>> For the second problem, I am attaching the report.
>>>>
>>>> Thanks
>>>>
>>>> Jason Weathersby wrote:
>>>>> Kris,
>>>>>
>>>>> if you do not want the sample db remove it from the plugins
>>>>> directory and it will not show up anymore.
>>>>>
>>>>> For the second issue can you post the report?
>>>>>
>>>>> Jason
>>>>>
>>>>> Kris wrote:
>>>>>> Hello, I am using Birt 2.2 and noticed couple of things that I
>>>>>> have nt noticed in Birt 2.1.2.
>>>>>>
>>>>>> 1) When I start the report engine,I can see a sample database is
>>>>>> created in local drive. Is it necessary? If not,how can I avoid
>>>>>> that.
>>>>>>
>>>>>> 2) When I run a report that is developed in 2.1.2, with the 2.2
>>>>>> Birt engine, from a java application, I am getting an error:
>>>>>>
>>>>>> SEVERE: ReferenceError: "dataSetParam" is not defined. (<inline>#1)
>>>>>> org.mozilla.javascript.EcmaError: ReferenceError: "dataSetParam"
>>>>>> is not defined.
>>>>>> (<inline>#1)
>>>>>> at
>>>>>> org.mozilla.javascript.ScriptRuntime.constructError(ScriptRu ntime.jav
>>>>>> a:3240)
>>>>>>
>>>>>> Why is that?
>>>>>>
>>>>>> If any can shed some light on it, that would be really great.
>>>>>>
>>>>>> Thanks
>>>>
>>>>
>>>> ------------------------------------------------------------ ------------
>>>>
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <!-- Written by Eclipse BIRT 2.0 -->
>>>> <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>
>>>> <parameters>
>>>> <scalar-parameter name="RP_filetype" id="6">
>>>> <property name="valueType">static</property>
>>>> <property name="dataType">string</property>
>>>> <property name="allowNull">true</property>
>>>> <property name="controlType">text-box</property>
>>>> <property name="defaultValue">Email Files</property>
>>>> <structure name="format">
>>>> <property name="category">Unformatted</property>
>>>> </structure>
>>>> </scalar-parameter>
>>>> <scalar-parameter name="RP_datestamp" id="7">
>>>> <property name="valueType">static</property>
>>>> <property name="dataType">dateTime</property>
>>>> <property name="concealValue">false</property>
>>>> <property name="allowNull">true</property>
>>>> <property name="controlType">text-box</property>
>>>> <property
>>>> name="defaultValue">2007-05-25T00:00:00.000</property>
>>>> <structure name="format">
>>>> <property name="category">Unformatted</property>
>>>> </structure>
>>>> </scalar-parameter>
>>>> <scalar-parameter name="RP_filecount" id="40">
>>>> <property name="valueType">static</property>
>>>> <property name="dataType">integer</property>
>>>> <property name="allowNull">true</property>
>>>> <property name="controlType">text-box</property>
>>>> <property name="defaultValue">1</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">oracle.jdbc.OracleDriver</property>
>>>> <property
>>>> name="odaURL">jdbc:oracle:thin:@host:1521:TableDB</property >
>>>> <property name="odaUser">Table</property>
>>>> <encrypted-property
>>>> name="odaPassword">QTk2MjE2N</encrypted-property>
>>>> </oda-data-source>
>>>> </data-sources>
>>>> <data-sets>
>>>> <oda-data-set
>>>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>>>> name="Data Set" id="5">
>>>> <structure name="cachedMetaData"/>
>>>> <property name="dataSource">Data Source</property>
>>>> <list-property name="parameters">
>>>> <structure>
>>>> <property name="name">param1</property>
>>>> <property name="paramName">RP_filetype</property>
>>>> <property name="nativeName"></property>
>>>> <property name="dataType">string</property>
>>>> <property name="nativeDataType">0</property>
>>>> <property name="position">1</property>
>>>> <property name="isOptional">true</property>
>>>> <property name="allowNull">true</property>
>>>> <property name="isInput">true</property>
>>>> <property name="isOutput">false</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="name">param2</property>
>>>> <property name="paramName">RP_datestamp</property>
>>>> <property name="nativeName"></property>
>>>> <property name="dataType">dateTime</property>
>>>> <property name="nativeDataType">0</property>
>>>> <property name="position">2</property>
>>>> <property name="isOptional">true</property>
>>>> <property name="allowNull">true</property>
>>>> <property name="isInput">true</property>
>>>> <property name="isOutput">false</property>
>>>> </structure>
>>>> <structure>
>>>> <property name="name">param3</property>
>>>> <property name="paramName">RP_filecount</property>
>>>> <property name="nativeName"></property>
>>>> <property name="dataType">any</property>
>>>> <property name="nativeDataType">0</property>
>>>> <property name="position">3</property>
>>>> <property name="isOptional">true</property>
>>>> <property name="allowNull">true</property>
>>>> <property name="isInput">true</property>
>>>> <property name="isOutput">false</property>
>>>> </structure>
>>>> </list-property>
>>>> <property name="queryText">select *
>>>> from Table
>>>> where filetypename = ? and datestamp < ?
>>>> and filecount > ?
>>>> order by datestamp</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>0</design:nativeDataTypeCode>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints/>
>>>> </design:attributes>
>>>> <design:inputAttributes>
>>>> <design:elementAttributes>
>>>> <design:defaultScalarValue>Email
>>>> Files</design:defaultScalarValue>
>>>> <design:optional>true</design:optional>
>>>> <design:masksValue>false</design:masksValue>
>>>> <design:uiHints>
>>>> <design:promptStyle>TextField</design:promptStyle>
>>>> </design:uiHints>
>>>> </design:elementAttributes>
>>>> </design:inputAttributes>
>>>> </design:parameterDefinitions>
>>>> <design:parameterDefinitions>
>>>> <design:inOutMode>In</design:inOutMode>
>>>> <design:attributes>
>>>> <design:name></design:name>
>>>> <design:position>2</design:position>
>>>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints/>
>>>> </design:attributes>
>>>> <design:inputAttributes>
>>>> <design:elementAttributes>
>>>>
>>>> <design:defaultScalarValue>2007-05-25T00:00:00.000</design:defaultScalarValue >
>>>>
>>>> <design:optional>true</design:optional>
>>>> <design:masksValue>false</design:masksValue>
>>>> <design:uiHints>
>>>> <design:promptStyle>TextField</design:promptStyle>
>>>> </design:uiHints>
>>>> </design:elementAttributes>
>>>> </design:inputAttributes>
>>>> </design:parameterDefinitions>
>>>> <design:parameterDefinitions>
>>>> <design:inOutMode>In</design:inOutMode>
>>>> <design:attributes>
>>>> <design:name></design:name>
>>>> <design:position>3</design:position>
>>>> <design:nativeDataTypeCode>0</design:nativeDataTypeCode>
>>>> <design:nullability>Nullable</design:nullability>
>>>> <design:uiHints/>
>>>> </design:attributes>
>>>> <design:inputAttributes>
>>>> <design:elementAttributes>
>>>> <design:optional>true</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>
>>>> <page-setup>
>>>> <simple-master-page name="Simple MasterPage" id="2">
>>>> <property name="topMargin">0.1458333333in</property>
>>>> <property name="leftMargin">0.2291666667in</property>
>>>> <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>
>>>> <grid id="12">
>>>> <property name="height">0.9895833333in</property>
>>>> <property name="width">7.0104166667in</property>
>>>> <column id="13"/>
>>>> <row id="14">
>>>> <property name="height">0.5104166667in</property>
>>>> <cell id="15"/>
>>>> </row>
>>>> <row id="16">
>>>> <property name="height">0.75in</property>
>>>> <cell id="17">
>>>> <table id="18">
>>>> <property name="width">100%</property>
>>>> <property name="dataSet">Data Set</property>
>>>> <list-property name="boundDataColumns">
>>>> <structure>
>>>> <property
>>>> name="name">FILETYPENAME</property>
>>>> <expression
>>>> name="expression">dataSetRow["FILETYPENAME"]</expression >
>>>> <property
>>>> name="dataType">string</property>
>>>> </structure>
>>>> <structure>
>>>> <property
>>>> name="name">DATESTAMP</property>
>>>> <expression
>>>> name="expression">dataSetRow["DATESTAMP"]</expression>
>>>> <property
>>>> name="dataType">date-time</property>
>>>> </structure>
>>>> <structure>
>>>> <property
>>>> name="name">FILECOUNT</property>
>>>> <expression
>>>> name="expression">dataSetRow["FILECOUNT"]</expression>
>>>> <property
>>>> name="dataType">decimal</property>
>>>> </structure>
>>>> </list-property>
>>>> <method
>>>> name="onCreate"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>>>> dataSetParam["param2"] = param["RP_datestamp"];
>>>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>>>> <method
>>>> name="onRender"><![CDATA[dataSetParam["param1"] = param["RP_filetype"];
>>>> dataSetParam["param2"] = param["RP_datestamp"];
>>>> dataSetParam["param3"] = param["RP_filecount"];]]></method>
>>>> <column id="31"/>
>>>> <column id="32"/>
>>>> <column id="33"/>
>>>> <header>
>>>> <row id="19">
>>>> <cell id="20">
>>>> <label id="34">
>>>> <text-property
>>>> name="text">FILETYPENAME</text-property>
>>>> </label>
>>>> </cell>
>>>> <cell id="21">
>>>> <label id="36">
>>>> <text-property
>>>> name="text">DATESTAMP</text-property>
>>>> </label>
>>>> </cell>
>>>> <cell id="22">
>>>> <label id="38">
>>>> <text-property
>>>> name="text">FILECOUNT</text-property>
>>>> </label>
>>>> </cell>
>>>> </row>
>>>> </header>
>>>> <detail>
>>>> <row id="23">
>>>> <cell id="24">
>>>> <data id="35">
>>>> <property
>>>> name="resultSetColumn">FILETYPENAME</property>
>>>> </data>
>>>> </cell>
>>>> <cell id="25">
>>>> <data id="37">
>>>> <property
>>>> name="resultSetColumn">DATESTAMP</property>
>>>> </data>
>>>> </cell>
>>>> <cell id="26">
>>>> <data id="39">
>>>> <property
>>>> name="resultSetColumn">FILECOUNT</property>
>>>> </data>
>>>> </cell>
>>>> </row>
>>>> </detail>
>>>> <footer>
>>>> <row id="27">
>>>> <cell id="28"/>
>>>> <cell id="29"/>
>>>> <cell id="30"/>
>>>> </row>
>>>> </footer>
>>>> </table>
>>>> </cell>
>>>> </row>
>>>> </grid>
>>>> </body>
>>>> </report>
|
|
|
Goto Forum:
Current Time: Sat Nov 09 06:56:31 GMT 2024
Powered by FUDForum. Page generated in 0.04199 seconds |
] 
Search
Help
Register
Login
Home
