Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Communications Framework (ECF) » parameter selection in option box
icon10.gif  parameter selection in option box [message #1011214] Tue, 19 February 2013 04:45 Go to next message
4040 4040 is currently offline 4040 4040
Messages: 78
Registered: February 2013
Member
this my xml source i have a error i my report for past two days can u check this and give solution for this .............i want to list out 'ALL' and 'particular' of a outlet name records ....


my dataset is

SELECT O_OUTLET_NAME as 'NAME',OIF_ITEM_CODE as 'code',IM_ITEM_NAME as 'ITEM NAME',OIF_RATE as 'RATE',OIF_QTY*OIF_RATE as 'AMOUNT',OIF_DISCOUNT as 'DISCOUNT',OIF_TAX as 'TAX',OIF_AMOUNT as 'NETAMOUNT'
FROM SS_OUTLET_ITEMWISE_FACT,SS_ITEM_MASTER,SS_OUTLET
WHERE OIF_ITEM_CODE=IM_ITEM_CODE AND
IM_BRAND_ID=1 AND
OIF_OUTLET_ID=O_NEW_OUTLET_ID and
OIF_tRAN_dATE='2012-12-01'
ORDER BY OIF_AMOUNT DESC
LIMIT 10;

on html


<script type="text/javascript">
function runReport(val){
oldLocation = window.location.href;
if(oldLocation.indexOf("&O_OUTLET_NAME") < 0){
window.location = window.location + '&O_OUTLET_NAME=' + val;
}
else{
window.location = oldLocation.substring(0,oldLocation.indexOf("&O_OUTLET_NAME")) + '&O_OUTLET_NAME=' + val;
}
}
</script>

<VALUE-OF format="HTML">temp = row["coutlet"].split(",");
htmlString = "<select onchange='runReport(this.value);' size=1>";
for(i=0;i<temp.length;i++){
if(params["outletname"] == temp[i]){
htmlString = htmlString + "<option value='" + temp[i] + "' selected='selected'>" + temp[i] + "</option>";
}
else{
htmlString = htmlString + "<option value='" + temp[i] + "'>" + temp[i] + "</option>";
}
}
htmlString = htmlString + "</select>"</VALUE-OF>


on befor open

if(params["outletname"] != "All"){
this.queryText = this.queryText + " where O_OUTLET_NAME = ''" + params["outletname"] + "'"+ and;
}














<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.2.2.v201301221637 Build &lt;4.2.2.v20130206-1509></property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">338</property>
</structure>
<structure>
<property name="name">queryTimeOut</property>
<property name="id">338</property>
</structure>
<structure>
<property name="name">rowFetchSize</property>
<property name="id">338</property>
</structure>
</list-property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<parameters>
<scalar-parameter name="outletname" id="339">
<property name="hidden">true</property>
<property name="valueType">static</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<simple-property-list name="defaultValue">
<value type="constant">ALL</value>
</simple-property-list>
<list-property name="selectionList"/>
<property name="paramType">simple</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="64">
<list-property name="privateDriverProperties">
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledMetadataBidiFormatStr</name>
</ex-property>
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>disabledContentBidiFormatStr</name>
</ex-property>
</list-property>
<property name="odaDriverClass">com.mysql.jdbc.Driver</property>
<property name="odaURL">jdbc:mysql://localhost:3306/ss_demo</property>
<property name="odaUser">android_demo</property>
<encrypted-property name="odaPassword" encryptionID="base64">YW5kcm9pZF9kZW0w</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="fullDataSet" id="65">
<list-property name="columnHints">
<structure>
<property name="columnName">O_OUTLET_NAME</property>
<property name="analysis">dimension</property>
<text-property name="displayName">NAME</text-property>
<text-property name="heading">NAME</text-property>
</structure>
<structure>
<property name="columnName">OIF_ITEM_CODE</property>
<property name="analysis">dimension</property>
<text-property name="displayName">code</text-property>
<text-property name="heading">code</text-property>
</structure>
<structure>
<property name="columnName">IM_ITEM_NAME</property>
<property name="analysis">dimension</property>
<text-property name="displayName">ITEM NAME</text-property>
<text-property name="heading">ITEM NAME</text-property>
</structure>
<structure>
<property name="columnName">OIF_RATE</property>
<property name="analysis">measure</property>
<text-property name="displayName">RATE</text-property>
<text-property name="heading">RATE</text-property>
</structure>
<structure>
<property name="columnName">AMOUNT</property>
<property name="analysis">measure</property>
<text-property name="displayName">AMOUNT</text-property>
<text-property name="heading">AMOUNT</text-property>
</structure>
<structure>
<property name="columnName">OIF_DISCOUNT</property>
<property name="analysis">measure</property>
<text-property name="displayName">DISCOUNT</text-property>
<text-property name="heading">DISCOUNT</text-property>
</structure>
<structure>
<property name="columnName">OIF_TAX</property>
<property name="analysis">measure</property>
<text-property name="displayName">TAX</text-property>
<text-property name="heading">TAX</text-property>
</structure>
<structure>
<property name="columnName">OIF_AMOUNT</property>
<property name="analysis">measure</property>
<text-property name="displayName">NETAMOUNT</text-property>
<text-property name="heading">NETAMOUNT</text-property>
</structure>
</list-property>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">O_OUTLET_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">OIF_ITEM_CODE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">IM_ITEM_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">OIF_RATE</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">AMOUNT</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">OIF_DISCOUNT</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">OIF_TAX</property>
<property name="dataType">float</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">OIF_AMOUNT</property>
<property name="dataType">float</property>
</structure>
</list-property>
</structure>
<method name="beforeOpen"><![CDATA[if(params["outletname"] != "All"){
this.queryText = this.queryText + " where O_OUTLET_NAME = ''" + params["outletname"] + "'"+ and;
}]]></method>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">O_OUTLET_NAME</property>
<property name="nativeName">O_OUTLET_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">OIF_ITEM_CODE</property>
<property name="nativeName">OIF_ITEM_CODE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">IM_ITEM_NAME</property>
<property name="nativeName">IM_ITEM_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">OIF_RATE</property>
<property name="nativeName">OIF_RATE</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">AMOUNT</property>
<property name="nativeName">AMOUNT</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">3</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">OIF_DISCOUNT</property>
<property name="nativeName">OIF_DISCOUNT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">OIF_TAX</property>
<property name="nativeName">OIF_TAX</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">OIF_AMOUNT</property>
<property name="nativeName">OIF_AMOUNT</property>
<property name="dataType">float</property>
<property name="nativeDataType">8</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT O_OUTLET_NAME as 'NAME',OIF_ITEM_CODE as 'code',IM_ITEM_NAME as 'ITEM NAME',OIF_RATE as 'RATE',OIF_QTY*OIF_RATE as 'AMOUNT',OIF_DISCOUNT as 'DISCOUNT',OIF_TAX as 'TAX',OIF_AMOUNT as 'NETAMOUNT'
FROM SS_OUTLET_ITEMWISE_FACT,SS_ITEM_MASTER,SS_OUTLET
WHERE OIF_ITEM_CODE=IM_ITEM_CODE AND
IM_BRAND_ID=1 AND
OIF_OUTLET_ID=O_NEW_OUTLET_ID and
OIF_tRAN_dATE='2012-12-01'
ORDER BY OIF_AMOUNT DESC
LIMIT 10;]]></xml-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>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>O_OUTLET_NAME</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>40</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>NAME</design:label>
<design:formattingHints>
<design:displaySize>40</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>OIF_ITEM_CODE</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>code</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>code</design:label>
<design:formattingHints>
<design:displaySize>10</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>IM_ITEM_NAME</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>ITEM NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>ITEM NAME</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>OIF_RATE</design:name>
<design:position>4</design:position>
</design:identifier>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>RATE</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>RATE</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>AMOUNT</design:name>
<design:position>5</design:position>
</design:identifier>
<design:nativeDataTypeCode>3</design:nativeDataTypeCode>
<design:precision>20</design:precision>
<design:scale>6</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>AMOUNT</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>AMOUNT</design:label>
<design:formattingHints>
<design:displaySize>22</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>OIF_DISCOUNT</design:name>
<design:position>6</design:position>
</design:identifier>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>DISCOUNT</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>DISCOUNT</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>OIF_TAX</design:name>
<design:position>7</design:position>
</design:identifier>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>2</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>TAX</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>TAX</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>OIF_AMOUNT</design:name>
<design:position>8</design:position>
</design:identifier>
<design:nativeDataTypeCode>8</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>3</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>NETAMOUNT</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>NETAMOUNT</design:label>
<design:formattingHints>
<design:displaySize>12</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="338">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="computedColumns">
<structure>
<property name="name">coutlet</property>
<property name="dataType">string</property>
<property name="aggregateFunction">CONCATENATE</property>
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value">row["O_OUTLET_NAME"]</expression>
</structure>
<structure>
<property name="name">Separat&amp;or</property>
<expression name="value">","</expression>
</structure>
</list-property>
</structure>
</list-property>
<list-property name="columnHints">
<structure>
<property name="columnName">O_OUTLET_NAME</property>
<property name="analysis">dimension</property>
<text-property name="displayName">O_OUTLET_NAME</text-property>
<text-property name="heading">O_OUTLET_NAME</text-property>
</structure>
</list-property>
<list-property name="parameters"/>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">O_OUTLET_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">coutlet</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">O_OUTLET_NAME</property>
<property name="nativeName">O_OUTLET_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[select distinct O_OUTLET_NAME from SS_OUTLET where O_BRANCH_ID=1
union select 'ALL' as O_OUTLET_NAME from SS_OUTLET where O_BRANCH_ID=1]]></xml-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>2.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>O_OUTLET_NAME</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>40</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>O_OUTLET_NAME</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>O_OUTLET_NAME</design:label>
<design:formattingHints>
<design:displaySize>40</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria/>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" 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>
<style name="crosstab" id="6">
<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>
<text id="285">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<script type="text/javascript">
function runReport(val){
oldLocation = window.location.href;
if(oldLocation.indexOf("&amp;O_OUTLET_NAME") < 0){
window.location = window.location + '&amp;O_OUTLET_NAME=' + val;
}
else{
window.location = oldLocation.substring(0,oldLocation.indexOf("&amp;O_OUTLET_NAME")) + '&amp;O_OUTLET_NAME=' + val;
}
}
</script>

<VALUE-OF format="HTML">temp = row["coutlet"].split(",");
htmlString = "<select onchange='runReport(this.value);' size=1>";
for(i=0;i<temp.length;i++){
if(params["outletname"] == temp[i]){
htmlString = htmlString + "<option value='" + temp[i] + "' selected='selected'>" + temp[i] + "</option>";
}
else{
htmlString = htmlString + "<option value='" + temp[i] + "'>" + temp[i] + "</option>";
}
}
htmlString = htmlString + "</select>"</VALUE-OF>]]></text-property>
</text>
<table id="286">
<property name="dataSet">fullDataSet</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">O_OUTLET_NAME</property>
<text-property name="displayName">NAME</text-property>
<expression name="expression" type="javascript">dataSetRow["O_OUTLET_NAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">OIF_ITEM_CODE</property>
<text-property name="displayName">code</text-property>
<expression name="expression" type="javascript">dataSetRow["OIF_ITEM_CODE"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">IM_ITEM_NAME</property>
<text-property name="displayName">ITEM NAME</text-property>
<expression name="expression" type="javascript">dataSetRow["IM_ITEM_NAME"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">OIF_RATE</property>
<text-property name="displayName">RATE</text-property>
<expression name="expression" type="javascript">dataSetRow["OIF_RATE"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">AMOUNT</property>
<text-property name="displayName">AMOUNT</text-property>
<expression name="expression" type="javascript">dataSetRow["AMOUNT"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">OIF_DISCOUNT</property>
<text-property name="displayName">DISCOUNT</text-property>
<expression name="expression" type="javascript">dataSetRow["OIF_DISCOUNT"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">OIF_TAX</property>
<text-property name="displayName">TAX</text-property>
<expression name="expression" type="javascript">dataSetRow["OIF_TAX"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">OIF_AMOUNT</property>
<text-property name="displayName">NETAMOUNT</text-property>
<expression name="expression" type="javascript">dataSetRow["OIF_AMOUNT"]</expression>
<property name="dataType">float</property>
</structure>
</list-property>
<column id="330"/>
<column id="331"/>
<column id="332"/>
<column id="333"/>
<column id="334"/>
<column id="335"/>
<column id="336"/>
<column id="337"/>
<header>
<row id="287">
<cell id="288">
<label id="289">
<text-property name="text">NAME</text-property>
</label>
</cell>
<cell id="290">
<label id="291">
<text-property name="text">code</text-property>
</label>
</cell>
<cell id="292">
<label id="293">
<text-property name="text">ITEM NAME</text-property>
</label>
</cell>
<cell id="294">
<label id="295">
<text-property name="text">RATE</text-property>
</label>
</cell>
<cell id="296">
<label id="297">
<text-property name="text">AMOUNT</text-property>
</label>
</cell>
<cell id="298">
<label id="299">
<text-property name="text">DISCOUNT</text-property>
</label>
</cell>
<cell id="300">
<label id="301">
<text-property name="text">TAX</text-property>
</label>
</cell>
<cell id="302">
<label id="303">
<text-property name="text">NETAMOUNT</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="304">
<cell id="305">
<data id="306">
<property name="resultSetColumn">O_OUTLET_NAME</property>
</data>
</cell>
<cell id="307">
<data id="308">
<property name="resultSetColumn">OIF_ITEM_CODE</property>
</data>
</cell>
<cell id="309">
<data id="310">
<property name="resultSetColumn">IM_ITEM_NAME</property>
</data>
</cell>
<cell id="311">
<data id="312">
<property name="resultSetColumn">OIF_RATE</property>
</data>
</cell>
<cell id="313">
<data id="314">
<property name="resultSetColumn">AMOUNT</property>
</data>
</cell>
<cell id="315">
<data id="316">
<property name="resultSetColumn">OIF_DISCOUNT</property>
</data>
</cell>
<cell id="317">
<data id="318">
<property name="resultSetColumn">OIF_TAX</property>
</data>
</cell>
<cell id="319">
<data id="320">
<property name="resultSetColumn">OIF_AMOUNT</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="321">
<cell id="322"/>
<cell id="323"/>
<cell id="324"/>
<cell id="325"/>
<cell id="326"/>
<cell id="327"/>
<cell id="328"/>
<cell id="329"/>
</row>
</footer>
</table>
</body>
</report>


my error is :

9 Feb, 2013 10:04:59 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer start
INFO: [Server] client accepted
19 Feb, 2013 10:04:59 AM org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher configEngine
INFO: User class path received:
19 Feb, 2013 10:04:59 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
INFO: [Server] enter request dispatching
19 Feb, 2013 10:05:00 AM org.eclipse.birt.report.engine.api.impl.EngineTask handleFatalExceptions
SEVERE: An error happened while running the report. Cause:
org.eclipse.birt.report.engine.api.EngineException: Failed to initialize emitter.
at org.eclipse.birt.report.engine.emitter.EmitterUtil.getOuputStream(EmitterUtil.java:82)
at org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitter.initialize(HTMLReportEmitter.java:356)
at org.eclipse.birt.report.engine.api.impl.EngineTask.initializeContentEmitter(EngineTask.java:2286)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:118)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:600)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:547)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:461)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:105)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
at org.eclipse.equinox.launcher.Main.main(Main.java:1414)
Caused by: java.io.FileNotFoundException: /itemwise.rptdesign.html (Permission denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:209)
at java.io.FileOutputStream.<init>(FileOutputStream.java:160)
at org.eclipse.birt.report.engine.emitter.EmitterUtil.getOuputStream(EmitterUtil.java:77)
... 22 more
19 Feb, 2013 10:05:00 AM org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher renderReport
SEVERE: Engine exception
org.eclipse.birt.report.engine.api.EngineException: Failed to initialize emitter.
at org.eclipse.birt.report.engine.emitter.EmitterUtil.getOuputStream(EmitterUtil.java:82)
at org.eclipse.birt.report.engine.emitter.html.HTMLReportEmitter.initialize(HTMLReportEmitter.java:356)
at org.eclipse.birt.report.engine.api.impl.EngineTask.initializeContentEmitter(EngineTask.java:2286)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:118)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.createReport(ReportLauncher.java:600)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.renderReport(ReportLauncher.java:547)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.run(ReportLauncher.java:461)
at org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher.main(ReportLauncher.java:105)
at org.eclipse.birt.report.debug.internal.core.ReportDebugger.start(ReportDebugger.java:39)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)
at org.eclipse.equinox.launcher.Main.run(Main.java:1438)
at org.eclipse.equinox.launcher.Main.main(Main.java:1414)
Caused by: java.io.FileNotFoundException: /itemwise.rptdesign.html (Permission denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:209)
at java.io.FileOutputStream.<init>(FileOutputStream.java:160)
at org.eclipse.birt.report.engine.emitter.EmitterUtil.getOuputStream(EmitterUtil.java:77)
... 22 more
19 Feb, 2013 10:05:00 AM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
WARNING: [Server] client disconnected
Re: parameter selection in option box [message #1011580 is a reply to message #1011214] Tue, 19 February 2013 20:59 Go to previous message
Scott Lewis is currently offline Scott Lewis
Messages: 970
Registered: July 2009
Senior Member
Hi Senthil,

This seems to be some xml/db access associated with the BIRT project (business intelligence reporting project). This mailing list is for the ECF project (Eclipse Communication Framework), and I don't recognize anything in your posting that's related to ECF. Have you consulted the BIRT mailing list?

Previous Topic:Preventing Remote Services from timing out
Next Topic:Multiple topics for DistributedEventAdmin
Goto Forum:
  


Current Time: Tue Sep 23 00:32:04 GMT 2014

Powered by FUDForum. Page generated in 0.01714 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software