nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

parameter selection in option box

404040

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){ 
htmlString = htmlString + "<option value='" + temp + "' selected='selected'>" + temp + "</option>"; 
} 
else{ 
htmlString = htmlString + "<option value='" + temp + "'>" + temp + "</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="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.23" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 4.2.2.v201301221637 Build <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="<a class='bbc_url' href='http://www.eclipse.org/datatools/connectivity/oda/design'>http://www.eclipse.org/datatools/connectivity/oda/design"</a> xmlns:model="<a class='bbc_url' href='http://www.eclipse.org/birt/report/model/adapter/odaModel">'>http://www.eclipse.org/birt/report/model/adapter/odaModel"></a> 
<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&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="<a class='bbc_url' href='http://www.eclipse.org/datatools/connectivity/oda/design'>http://www.eclipse.org/datatools/connectivity/oda/design"</a> xmlns:model="<a class='bbc_url' href='http://www.eclipse.org/birt/report/model/adapter/odaModel">'>http://www.eclipse.org/birt/report/model/adapter/odaModel"></a> 
<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("&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){ 
htmlString = htmlString + "<option value='" + temp + "' selected='selected'>" + temp + "</option>"; 
} 
else{ 
htmlString = htmlString + "<option value='" + temp + "'>" + temp + "</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 : ^_^ ^_^ ^_^ ^_^ ^_^ ^_^ 
 
while i debug in myreport: 
 
 
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 
 
 
when i see in xml source error: 
 
multiple annotations found at this line: 
- org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "temp = row["coutlet"].split(","); htmlString = 
"<select onChange='runReport(this.value);' size=1>"; for(i=0;i<temp.length;i++){ if(params["outletname"] == temp){ htmlString = 
htmlString + "<option value='" + temp + "' selected='selected'>" + temp + "</option>"; } else{ htmlString = htmlString + "<option value='" 
+ temp + "'>" + temp + "</option>"; } } htmlString = htmlString + "</select>"": ReferenceError: "row" is not defined. (<inline>#1) at 
org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1239) at 
org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1184) at 
org.eclipse.birt.report.engine.executor.ReportItemExecutor.evaluate(ReportItemExecutor.java:288) at 
org.eclipse.birt.report.engine.executor.TextItemExecutor.executeHtmlText(TextItemExecutor.java:115) at 
org.eclipse.birt.report.engine.executor.TextItemExecutor.execute(TextItemExecutor.java:70) at 
org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at 
org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46) at 
org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43) at 
org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46) at 
org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34) at 
org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65) at 
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92) at 
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100) at 
org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249) at 
org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:269) at 
org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86) at 
org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325) at 
org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158) at 
org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81) at 
org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58) 
at 
org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java: 
53) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90) at 
org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java: 
47) at 
org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java: 
143) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100) 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.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112) at 
org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) at 
sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at 
java.lang.reflect.Method.invoke(Method.java:616) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at 
org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at 
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at 
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java: 
118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java: 
454) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at 
org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at 
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:755) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java: 
327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at 
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122) at 
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180) at 
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) at 
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128) at 
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60) at 
javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.equinox.http.jetty.internal.HttpServerManager 
$InternalHttpServiceServlet.service(HttpServerManager.java:384) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:598) 
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:486) at 
org.e

Find more posts tagged with

Comments

There are no comments yet