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; } } }

Filling Grid Dynamically

DEV SAHU

Hi All, 
 
We designed a birt report which have alot of grid boxes which we are filling dynamically. 
The Approach which we have used is 
1. Add the grid to the report. 
2. add the fillGrid methode to onInitialize of Report. In this methode we are creating the text elements dynamically and adding the data to that to that Text and adding this text element to each cell of grid. 
3. onPrepare methode of this grid we are calling fillGrid methode. 
4. on the Binding Property of the grid we have selected the dataset. 
 
Kindly let us know if there is any other approach available for the same. 
 
attached sample rptdesign below. 
<?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="comments">Copyright (c) 2007 <<Your Company Name here>></property> 
<property name="createdBy">Eclipse BIRT Designer Version 4.2.2.v201301221637 Build <4.2.2.v20130206-1509></property> 
<html-property name="description">Creates a blank report with no predefined content.</html-property> 
<property name="units">in</property> 
<method name="initialize"><![CDATA[function fillGrid(count,columnName,grdName) 
{ 
for(i=0;i<count;i++) 
{ 
Text = 
reportContext.getDesignHandle().getElementFactory().newTextItem(null); 
Text.setContentType("HTML"); 
Text.setContent("<CENTER><VALUE-OF>row['" + columnName + "'].toString().substring(0+" + i + ",1+" + i + ")</VALUE-OF></CENTER>"); 
var Grid=reportContext.getDesignHandle().findElement(grdName); 
 
var cell=Grid.getCell(0,1+i); 
 
cell.getContent().add(Text); 
} 
}]]></method> 
<text-property name="displayName">Blank Report</text-property> 
<property name="iconFile">/templates/blank_report.gif</property> 
<property name="layoutPreference">auto layout</property> 
<parameters> 
<scalar-parameter name="parmorders" id="8"> 
<property name="valueType">dynamic</property> 
<property name="dataSetName">parmDataSet</property> 
<expression name="valueExpr">dataSetRow["CUSTOMERNUMBER"]</expression> 
<property name="dataType">string</property> 
<property name="distinct">true</property> 
<property name="paramType">multi-value</property> 
<property name="controlType">list-box</property> 
<property name="mustMatch">true</property> 
<property name="fixedOrder">true</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="6"> 
<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">org.eclipse.birt.report.data.oda.sampledb.Driver</property> 
<property name="odaURL">jdbc:classicmodels:sampledb</property> 
<property name="odaUser">ClassicModels</property> 
</oda-data-source> 
</data-sources> 
<data-sets> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="parmDataSet" id="7"> 
<list-property name="columnHints"> 
<structure> 
<property name="columnName">CUSTOMERNUMBER</property> 
<text-property name="displayName">CUSTOMERNUMBER</text-property> 
</structure> 
</list-property> 
<structure name="cachedMetaData"> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">CUSTOMERNUMBER</property> 
<property name="dataType">integer</property> 
</structure> 
</list-property> 
</structure> 
<property name="dataSource">Data Source</property> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">CUSTOMERNUMBER</property> 
<property name="nativeName">CUSTOMERNUMBER</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">4</property> 
</structure> 
</list-property> 
<xml-property name="queryText"><![CDATA[select customernumber 
from orders]]></xml-property> 
</oda-data-set> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="orderdetails" id="10"> 
<list-property name="columnHints"> 
<structure> 
<property name="columnName">ORDERNUMBER</property> 
<text-property name="displayName">ORDERNUMBER</text-property> 
</structure> 
<structure> 
<property name="columnName">ORDERDATE</property> 
<text-property name="displayName">ORDERDATE</text-property> 
</structure> 
<structure> 
<property name="columnName">REQUIREDDATE</property> 
<text-property name="displayName">REQUIREDDATE</text-property> 
</structure> 
<structure> 
<property name="columnName">SHIPPEDDATE</property> 
<text-property name="displayName">SHIPPEDDATE</text-property> 
</structure> 
<structure> 
<property name="columnName">STATUS</property> 
<text-property name="displayName">STATUS</text-property> 
</structure> 
<structure> 
<property name="columnName">COMMENTS</property> 
<text-property name="displayName">COMMENTS</text-property> 
</structure> 
<structure> 
<property name="columnName">CUSTOMERNUMBER</property> 
<text-property name="displayName">CUSTOMERNUMBER</text-property> 
</structure> 
</list-property> 
<structure name="cachedMetaData"> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">ORDERNUMBER</property> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">ORDERDATE</property> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">REQUIREDDATE</property> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">SHIPPEDDATE</property> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">STATUS</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">6</property> 
<property name="name">COMMENTS</property> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="position">7</property> 
<property name="name">CUSTOMERNUMBER</property> 
<property name="dataType">integer</property> 
</structure> 
</list-property> 
</structure> 
<method name="beforeOpen"><![CDATA[//var parmcount = params["parmorders"].value.length 
//var whereclause = ""; 
//if( parmcount > 0 ){ 
// whereclause = " where customernumber in ( "; 
//} 
//for( i=0; i < parmcount; i++ ){ 
// if( i == 0 ){ 
// whereclause = whereclause + params["parmorders"].value; 
// }else{ 
// whereclause = whereclause + " , " + params["parmorders"].value; 
// } 
//} 
//if( parmcount > 0 ){ 
// this.queryText = this.queryText + whereclause + " ) "; 
//}]]></method> 
<property name="dataSource">Data Source</property> 
<list-property name="resultSet"> 
<structure> 
<property name="position">1</property> 
<property name="name">ORDERNUMBER</property> 
<property name="nativeName">ORDERNUMBER</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">4</property> 
</structure> 
<structure> 
<property name="position">2</property> 
<property name="name">ORDERDATE</property> 
<property name="nativeName">ORDERDATE</property> 
<property name="dataType">date</property> 
<property name="nativeDataType">91</property> 
</structure> 
<structure> 
<property name="position">3</property> 
<property name="name">REQUIREDDATE</property> 
<property name="nativeName">REQUIREDDATE</property> 
<property name="dataType">date</property> 
<property name="nativeDataType">91</property> 
</structure> 
<structure> 
<property name="position">4</property> 
<property name="name">SHIPPEDDATE</property> 
<property name="nativeName">SHIPPEDDATE</property> 
<property name="dataType">date</property> 
<property name="nativeDataType">91</property> 
</structure> 
<structure> 
<property name="position">5</property> 
<property name="name">STATUS</property> 
<property name="nativeName">STATUS</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">6</property> 
<property name="name">COMMENTS</property> 
<property name="nativeName">COMMENTS</property> 
<property name="dataType">string</property> 
<property name="nativeDataType">12</property> 
</structure> 
<structure> 
<property name="position">7</property> 
<property name="name">CUSTOMERNUMBER</property> 
<property name="nativeName">CUSTOMERNUMBER</property> 
<property name="dataType">integer</property> 
<property name="nativeDataType">4</property> 
</structure> 
</list-property> 
<xml-property name="queryText"><![CDATA[select * 
from orders]]></xml-property> 
</oda-data-set> 
</data-sets> 
<styles> 
<style name="crosstab" id="4"> 
<property name="borderBottomColor">#CCCCCC</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
<style name="crosstab-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="detail" id="45"> 
<property name="backgroundColor">#BACAE2</property> 
<property name="fontFamily">"Arial"</property> 
<property name="fontSize">small</property> 
<property name="paddingTop">0px</property> 
<property name="paddingLeft">0px</property> 
<property name="paddingBottom">0px</property> 
<property name="paddingRight">0px</property> 
</style> 
<style name="headerfooter" id="46"> 
<property name="backgroundColor">#004080</property> 
<property name="fontFamily">"Arial"</property> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="color">#FFFFFF</property> 
</style> 
<style name="groupheader" id="47"> 
<property name="backgroundColor">#0080FF</property> 
<property name="fontFamily">"Arial"</property> 
<property name="fontSize">small</property> 
<property name="fontWeight">bold</property> 
<property name="color">#FFFFFF</property> 
</style> 
</styles> 
<page-setup> 
<simple-master-page name="Simple MasterPage" id="2"> 
<property name="topMargin">1in</property> 
<property name="leftMargin">1.25in</property> 
<property name="bottomMargin">1in</property> 
<property name="rightMargin">1.25in</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> 
<table id="204"> 
<property name="dataSet">orderdetails</property> 
<list-property name="visibility"> 
<structure> 
<property name="format">all</property> 
<expression name="valueExpr" type="javascript">true</expression> 
</structure> 
</list-property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">ORDERNUMBER</property> 
<text-property name="displayName">ORDERNUMBER</text-property> 
<expression name="expression" type="javascript">dataSetRow["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">ORDERDATE</property> 
<text-property name="displayName">ORDERDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["ORDERDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">REQUIREDDATE</property> 
<text-property name="displayName">REQUIREDDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["REQUIREDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">SHIPPEDDATE</property> 
<text-property name="displayName">SHIPPEDDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["SHIPPEDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">STATUS</property> 
<text-property name="displayName">STATUS</text-property> 
<expression name="expression" type="javascript">dataSetRow["STATUS"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">COMMENTS</property> 
<text-property name="displayName">COMMENTS</text-property> 
<expression name="expression" type="javascript">dataSetRow["COMMENTS"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">CUSTOMERNUMBER</property> 
<text-property name="displayName">CUSTOMERNUMBER</text-property> 
<expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression> 
<property name="dataType">integer</property> 
</structure> 
</list-property> 
<column id="243"/> 
<column id="244"/> 
<column id="245"/> 
<column id="246"/> 
<column id="247"/> 
<column id="248"/> 
<column id="249"/> 
<header> 
<row id="205"> 
<cell id="206"> 
<label id="207"> 
<text-property name="text">ORDERNUMBER</text-property> 
</label> 
</cell> 
<cell id="208"> 
<label id="209"> 
<text-property name="text">ORDERDATE</text-property> 
</label> 
</cell> 
<cell id="210"> 
<label id="211"> 
<text-property name="text">REQUIREDDATE</text-property> 
</label> 
</cell> 
<cell id="212"> 
<label id="213"> 
<text-property name="text">SHIPPEDDATE</text-property> 
</label> 
</cell> 
<cell id="214"> 
<label id="215"> 
<text-property name="text">STATUS</text-property> 
</label> 
</cell> 
<cell id="216"> 
<label id="217"> 
<text-property name="text">COMMENTS</text-property> 
</label> 
</cell> 
<cell id="218"> 
<label id="219"> 
<text-property name="text">CUSTOMERNUMBER</text-property> 
</label> 
</cell> 
</row> 
</header> 
<detail> 
<row id="220"> 
<cell id="221"> 
<data id="222"> 
<property name="resultSetColumn">ORDERNUMBER</property> 
</data> 
</cell> 
<cell id="223"> 
<data id="224"> 
<property name="resultSetColumn">ORDERDATE</property> 
</data> 
</cell> 
<cell id="225"> 
<data id="226"> 
<property name="resultSetColumn">REQUIREDDATE</property> 
</data> 
</cell> 
<cell id="227"> 
<data id="228"> 
<property name="resultSetColumn">SHIPPEDDATE</property> 
</data> 
</cell> 
<cell id="229"> 
<data id="230"> 
<property name="resultSetColumn">STATUS</property> 
</data> 
</cell> 
<cell id="231"> 
<data id="232"> 
<property name="resultSetColumn">COMMENTS</property> 
</data> 
</cell> 
<cell id="233"> 
<data id="234"> 
<property name="resultSetColumn">CUSTOMERNUMBER</property> 
</data> 
</cell> 
</row> 
</detail> 
<footer> 
<row id="235"> 
<cell id="236"/> 
<cell id="237"/> 
<cell id="238"/> 
<cell id="239"/> 
<cell id="240"/> 
<cell id="241"/> 
<cell id="242"/> 
</row> 
</footer> 
</table> 
<grid id="171"> 
<column id="172"/> 
<column id="173"/> 
<row id="174"> 
<cell id="175"> 
<label id="181"> 
<text-property name="text">Order Status :</text-property> 
</label> 
</cell> 
<cell id="176"> 
<grid name="grdOrdStatus" id="182"> 
<property name="dataSet">orderdetails</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">ORDERNUMBER</property> 
<text-property name="displayName">ORDERNUMBER</text-property> 
<expression name="expression" type="javascript">dataSetRow["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">ORDERDATE</property> 
<text-property name="displayName">ORDERDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["ORDERDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">REQUIREDDATE</property> 
<text-property name="displayName">REQUIREDDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["REQUIREDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">SHIPPEDDATE</property> 
<text-property name="displayName">SHIPPEDDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["SHIPPEDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">STATUS</property> 
<text-property name="displayName">STATUS</text-property> 
<expression name="expression" type="javascript">dataSetRow["STATUS"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">COMMENTS</property> 
<text-property name="displayName">COMMENTS</text-property> 
<expression name="expression" type="javascript">dataSetRow["COMMENTS"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">CUSTOMERNUMBER</property> 
<text-property name="displayName">CUSTOMERNUMBER</text-property> 
<expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression> 
<property name="dataType">integer</property> 
</structure> 
</list-property> 
<method name="onPrepare"><![CDATA[importPackage(Packages.org.eclipse.birt.report.model.elements); 
importPackage (Packages.org.eclipse.birt.report.model.api); 
 
fillGrid(10,"STATUS","grdOrdStatus"); 
]]></method> 
<column id="183"/> 
<column id="184"/> 
<column id="185"/> 
<column id="186"/> 
<column id="187"/> 
<column id="188"/> 
<column id="189"/> 
<column id="190"/> 
<column id="191"/> 
<column id="192"/> 
<row id="193"> 
<property name="height">0.2in</property> 
<cell id="194"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="195"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="196"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="197"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="198"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="199"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="200"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="201"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="202"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="203"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
</row> 
</grid> 
</cell> 
</row> 
<row id="177"> 
<cell id="178"> 
<label id="180"> 
<text-property name="text">Order Number</text-property> 
</label> 
</cell> 
<cell id="179"> 
<grid name="grdOrdNumber" id="250"> 
<property name="dataSet">orderdetails</property> 
<list-property name="boundDataColumns"> 
<structure> 
<property name="name">ORDERNUMBER</property> 
<text-property name="displayName">ORDERNUMBER</text-property> 
<expression name="expression" type="javascript">dataSetRow["ORDERNUMBER"]</expression> 
<property name="dataType">integer</property> 
</structure> 
<structure> 
<property name="name">ORDERDATE</property> 
<text-property name="displayName">ORDERDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["ORDERDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">REQUIREDDATE</property> 
<text-property name="displayName">REQUIREDDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["REQUIREDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">SHIPPEDDATE</property> 
<text-property name="displayName">SHIPPEDDATE</text-property> 
<expression name="expression" type="javascript">dataSetRow["SHIPPEDDATE"]</expression> 
<property name="dataType">date</property> 
</structure> 
<structure> 
<property name="name">STATUS</property> 
<text-property name="displayName">STATUS</text-property> 
<expression name="expression" type="javascript">dataSetRow["STATUS"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">COMMENTS</property> 
<text-property name="displayName">COMMENTS</text-property> 
<expression name="expression" type="javascript">dataSetRow["COMMENTS"]</expression> 
<property name="dataType">string</property> 
</structure> 
<structure> 
<property name="name">CUSTOMERNUMBER</property> 
<text-property name="displayName">CUSTOMERNUMBER</text-property> 
<expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression> 
<property name="dataType">integer</property> 
</structure> 
</list-property> 
<method name="onPrepare"><![CDATA[importPackage(Packages.org.eclipse.birt.report.model.elements); 
importPackage (Packages.org.eclipse.birt.report.model.api); 
 
fillGrid(10,"ORDERNUMBER","grdOrdNumber"); 
]]></method> 
<column id="251"/> 
<column id="252"/> 
<column id="253"/> 
<column id="254"/> 
<column id="255"/> 
<column id="256"/> 
<column id="257"/> 
<column id="258"/> 
<column id="259"/> 
<column id="260"/> 
<row id="261"> 
<property name="height">0.2in</property> 
<cell id="262"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="263"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="264"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="265"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="266"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="267"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="268"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="269"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="270"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
<cell id="271"> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1px</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1px</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1px</property> 
</cell> 
</row> 
</grid> 
</cell> 
</row> 
</grid> 
</body> 
</report>

Find more posts tagged with

Comments

kclark

Can you explain a little more what you're needing to do? The report runs for me but I get the same order number each time. Are you trying to show all orders assoicated with the parameter that is selected?

DEV SAHU

Hi Clark,

We have designed a form(like a form we fill say for opening a bank account)
and the form has nearly 50 such grid to fill.
when we bind dataset to a Grid it the xml of the data source is added to
the xml of the grid. which is making the report big in size (nearly 4 MB).
The report which I have attached is only to show the approch which I have
used for achieving this functionality. I wan't to know the Other possible(better)
approach for filling the grid like I tried in the attached report.