Home » Archived » BIRT » Problem to set data/element into cells created by adding column dynamically in two-dimensional table
| Problem to set data/element into cells created by adding column dynamically in two-dimensional table [message #537707] |
Thu, 03 June 2010 12:38  |
 prodigy201 
Messages: 10
Registered: March 2010 |
Junior Member |
|
|
Hi,
I've created a two-dimensional table in birt.
Now, using BIRT report engine api, through my java code, I am adding one column in my table (say country column) at the end of the table, and hence want to insert data into these newly created cells (these cells created because of adding this column column dynamically)
Suppose, I want to add data/element in these newly created cells, I am unable to do so, its not working for two-dimensional table. If I try to add column and then add labels in the cells for simple table, it works.
Below is my code snippet and format of my table I've created.
public class MyDynamicTable extends ReportEventAdapter
{
public void beforeFactory(IReportDesign report, IReportContext reportContext)
{
try{
ElementFactory elementFactory = reportContext.getReportRunnable().getDesignHandle().getElementFactory();
TableHandle dynamicTable = (TableHandle) reportContext.getDesignHandle().findElement("topCntry"); //table name is "topCntry"
dynamicTable.insertColumn(5, 1);
RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
RowHandle myNewPercent = (RowHandle) dynamicTable.getDetail().get(1);
RowHandle myNewHits = (RowHandle) dynamicTable.getDetail().get(2);
CellHandle firstCell = (CellHandle) myNewCntry.getCells().get(5);
CellHandle secondCell = (CellHandle) myNewPercent.getCells().get(5);
CellHandle thirdCell = (CellHandle) myNewHits.getCells().get(5);
//create new labels
LabelHandle label1 = elementFactory.newLabel("Cell1");
label1.setText("D Cell");
LabelHandle label2 = elementFactory.newLabel("Cell2");
label2.setText("E Cell");
LabelHandle label3 = elementFactory.newLabel("Cell3");
label3.setText("F Cell");
firstCell.getContent().add(label1);
secondCell.getContent().add(label2);
thirdCell.getContent().add(label3);
} catch(Exception e){
e.printStackTrace();
}
}
}
Two-dimensional Table format -
My table name is "topCntry"
Sr No. User id Parameter Country-1 Country-2
------------------------------------------------------------------------
Country USA UK
1 abcde Percentage 45% 59.6%
Hits 45 59
------------------------------------------------------------------------
Help is highly appreciated.
Thank you,
prodigy201
|
|
|
| Re: Problem to set data/element into cells created by adding column dynamically in two-dimensional t [message #537779 is a reply to message #537707] |
Thu, 03 June 2010 15:25  |
|
Not sure this is what you are asking, but if you want to add a data item
you need to make sure a column binding exist for it on the table first:
PropertyHandle computedSet = table.getColumnBindings( );
ComputedColumn cs1;
cs1 = StructureFactory.createComputedColumn();
cs1.setName("CustomerName");
cs1.setExpression("dataSetRow[\"CUSTOMERNAME\"]");
computedSet.addItem(cs1);
RowHandle tabledetail = (RowHandle) table.getDetail( ).get( 0 );
cell = (CellHandle) tabledetail.getCells( ).get( 0 );
DataItemHandle data = designFactory.newDataItem( "data1" );
data.setResultSetColumn("CustomerName");
cell.getContent( ).add( data );
Jason
On 6/3/2010 8:38 AM, prodigy201 wrote:
> Hi,
> I've created a two-dimensional table in birt.
>
> Now, using BIRT report engine api, through my java code, I am adding one
> column in my table (say country column) at the end of the table, and
> hence want to insert data into these newly created cells (these cells
> created because of adding this column column dynamically)
>
> Suppose, I want to add data/element in these newly created cells, I am
> unable to do so, its not working for two-dimensional table. If I try to
> add column and then add labels in the cells for simple table, it works.
>
> Below is my code snippet and format of my table I've created.
>
> public class MyDynamicTable extends ReportEventAdapter
> {
> public void beforeFactory(IReportDesign report, IReportContext
> reportContext)
> {
> try{
> ElementFactory elementFactory =
> reportContext.getReportRunnable().getDesignHandle().getEleme ntFactory();
> TableHandle dynamicTable = (TableHandle)
> reportContext.getDesignHandle().findElement("topCntry"); //table name is
> "topCntry"
>
> dynamicTable.insertColumn(5, 1);
>
> RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
> RowHandle myNewPercent = (RowHandle) dynamicTable.getDetail().get(1);
> RowHandle myNewHits = (RowHandle) dynamicTable.getDetail().get(2);
>
>
> CellHandle firstCell = (CellHandle) myNewCntry.getCells().get(5);
> CellHandle secondCell = (CellHandle) myNewPercent.getCells().get(5);
> CellHandle thirdCell = (CellHandle) myNewHits.getCells().get(5);
>
> //create new labels
> LabelHandle label1 = elementFactory.newLabel("Cell1");
> label1.setText("D Cell");
> LabelHandle label2 = elementFactory.newLabel("Cell2");
> label2.setText("E Cell");
> LabelHandle label3 = elementFactory.newLabel("Cell3");
> label3.setText("F Cell");
>
> firstCell.getContent().add(label1);
> secondCell.getContent().add(label2);
> thirdCell.getContent().add(label3);
> } catch(Exception e){
> e.printStackTrace();
> }
> }
> }
>
>
> Two-dimensional Table format -
>
> My table name is "topCntry"
>
>
>
> Sr No. User id Parameter Country-1 Country-2
> ------------------------------------------------------------ ------------
> Country USA UK
> 1 abcde Percentage 45% 59.6%
> Hits 45 59
> ------------------------------------------------------------ ------------
>
>
>
> Help is highly appreciated.
>
> Thank you,
> prodigy201
|
|
|
| Re: Problem to set data/element into cells created by adding column dynamically in two-dimensional t [message #537894 is a reply to message #537707] |
Fri, 04 June 2010 06:34 |
prodigy201
Messages: 10
Registered: March 2010 |
Junior Member |
|
|
Hi Jason,
Well, you've taken DATA and I've taken LABEL instead of DATA in cell in my new column. So it doesn't actually makes a difference what you want to insert in cell.
My worry is how to add DATA/LABEL/ANY ELEMENT in the every cell of the same column where row is same. I mean to say, as I've shown table format in my thread previously, (displaying two-dimensional table format again at the end of this reply) where you will find I want to fill 3 cells for new dynamically added column say country-3, in these 3 cells I want to add country name, percentage and hits for this country-3. That is, for same "Sr.No" say 1, for same "User ID" say "abcde", I want to fill data for newly added column for country-3, as I've initially done for country-1 to country-2 that was done by designing rptdesign file using table. And I am working for adding new column dynamically on this already created table.
I am just able to insert only for country name that is first cell, but am UNsuccessful to add for percentage and hits for the same, those fall in cell2 and cell3.
I hope you got my query. And I am sure you will be helpful for this, as I'm referring your book only. "Integrating and Extending BIRT" 
Table format - ("Parameter" column's data is static. i.e "Country", "Percentage", "Hits" are static labels)
Sr No. User id Parameter Country-1 Country-2
------------------------------------------------------------------------
Country USA UK
1 abcde Percentage 45% 59.6%
Hits 45 59
------------------------------------------------------------------------
P.S. - I request you to go through my code again that I've posted earlier in my thread, so you'll surely come to know what I am actually trying to do.
Thank you,
prodigy201
------------------------------------------------------------ -----------------------------------
Not sure this is what you are asking, but if you want to add a data item
you need to make sure a column binding exist for it on the table first:
PropertyHandle computedSet = table.getColumnBindings( );
ComputedColumn cs1;
cs1 = StructureFactory.createComputedColumn();
cs1.setName("CustomerName");
cs1.setExpression("dataSetRow[\"CUSTOMERNAME\"]");
computedSet.addItem(cs1);
RowHandle tabledetail = (RowHandle) table.getDetail( ).get( 0 );
cell = (CellHandle) tabledetail.getCells( ).get( 0 );
DataItemHandle data = designFactory.newDataItem( "data1" );
data.setResultSetColumn("CustomerName");
cell.getContent( ).add( data );
Jason
On 6/3/2010 8:38 AM, prodigy201 wrote:
> Hi,
> I've created a two-dimensional table in birt.
>
> Now, using BIRT report engine api, through my java code, I am adding one
> column in my table (say country column) at the end of the table, and
> hence want to insert data into these newly created cells (these cells
> created because of adding this column column dynamically)
>
> Suppose, I want to add data/element in these newly created cells, I am
> unable to do so, its not working for two-dimensional table. If I try to
> add column and then add labels in the cells for simple table, it works.
>
> Below is my code snippet and format of my table I've created.
>
> public class MyDynamicTable extends ReportEventAdapter
> {
> public void beforeFactory(IReportDesign report, IReportContext
> reportContext)
> {
> try{
> ElementFactory elementFactory =
> reportContext.getReportRunnable().getDesignHandle().getEleme ntFactory();
> TableHandle dynamicTable = (TableHandle)
> reportContext.getDesignHandle().findElement("topCntry"); //table name is
> "topCntry"
>
> dynamicTable.insertColumn(5, 1);
>
> RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
> RowHandle myNewPercent = (RowHandle) dynamicTable.getDetail().get(1);
> RowHandle myNewHits = (RowHandle) dynamicTable.getDetail().get(2);
>
>
> CellHandle firstCell = (CellHandle) myNewCntry.getCells().get(5);
> CellHandle secondCell = (CellHandle) myNewPercent.getCells().get(5);
> CellHandle thirdCell = (CellHandle) myNewHits.getCells().get(5);
>
> //create new labels
> LabelHandle label1 = elementFactory.newLabel("Cell1");
> label1.setText("D Cell");
> LabelHandle label2 = elementFactory.newLabel("Cell2");
> label2.setText("E Cell");
> LabelHandle label3 = elementFactory.newLabel("Cell3");
> label3.setText("F Cell");
>
> firstCell.getContent().add(label1);
> secondCell.getContent().add(label2);
> thirdCell.getContent().add(label3);
> } catch(Exception e){
> e.printStackTrace();
> }
> }
> }
>
>
> Two-dimensional Table format -
>
> My table name is "topCntry"
>
>
>
> Sr No. User id Parameter Country-1 Country-2
> ------------------------------------------------------------ ------------
> Country USA UK
> 1 abcde Percentage 45% 59.6%
> Hits 45 59
> ------------------------------------------------------------ ------------
>
>
>
> Help is highly appreciated.
>
> Thank you,
> prodigy201
[Updated on: Fri, 04 June 2010 06:47] Report message to a moderator |
|
|
| Re: Problem to set data/element into cells created by adding column dynamically in two-dimensional t [message #538030 is a reply to message #537894] |
Fri, 04 June 2010 14:21 |
|
Can you post the report design?
this code implies that you have 3 detail rows. Is this correct or do
you have one detail, a header, and a footer?
RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
RowHandle myNewPercent = (RowHandle) dynamicTable.getDetail().get(1);
RowHandle myNewHits = (RowHandle) dynamicTable.getDetail().get(2);
Jason
On 6/4/2010 2:34 AM, prodigy201 wrote:
> RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
> RowHandle myNewPercent = (RowHandle) dynamicTable.getDetail().get(1);
> RowHandle myNewHits = (RowHandle) dynamicTable.getDetail().get(2);
|
|
|
| Re: Problem to set data/element into cells created by adding column dynamically in two-dimensional t [message #538588 is a reply to message #538030] |
Tue, 08 June 2010 07:09 |
prodigy201
Messages: 10
Registered: March 2010 |
Junior Member |
|
|
Hi Jason,
Please go through the XML (rptdesign) for my report given below.
And yeah, you are right, my report has 3 sub-rows in 1 main row. You will find in my reprt design, I've used classicmodels for DB source and DATA SET just for now to bind it to my table. (Its just for binding Dataset to table, It has nothing to do with my report though, as my actual dataset is surely going to be different).
Moreover, you'll observe the actual format of report and will get idea of data I want to represent. Instead of DATA ELEMENT, I've taken LABELS (just for now) in every cell. (Every cell will be filled with DATA ELEMENT only later). The third column "Parameters" will get repeated everytime with its "static labels" - "Country", "No. of Applications", "Accepted Applications".
I want to add 3 columns - Country-3 to Country-5 dynamically in this table, and hence the data in every cell dynamically. But, as per my JAVA code(given below), its only adding DATA/LABEL for "Country" only and NOT FOR "No. of Applications", "Accepted Applications". Now, I hope you understood what I want to do.
RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
RowHandle myNewApplis = (RowHandle) dynamicTable.getDetail().get(1);
RowHandle myNewSelectdApplis = (RowHandle) dynamicTable.getDetail().get(2);
Following is XML for rptdesign. -
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903 Build <2.5.1.v20090917-1447></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="408">
<text-property name="displayName"></text-property>
<property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
<property name="odaURL">jdbc:classicmodels:sampledb</property>
<property name="odaUser">ClassicModels</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="409">
<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 CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:name>CUSTOMERNUMBER</design:name>
<design:position>1</design:position>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>10</design:precision>
<design:scale>0</design:scale>
<design:nullability>Nullable</design:nullability>
<design:uiHints>
<design:displayName>CUSTOMERNUMBER</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>CUSTOMERNUMBER</design:label>
<design:formattingHints>
<design:displaySize>11</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>
]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="rowSetting" id="192">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="textAlign">center</property>
<property name="verticalAlign">middle</property>
</style>
<style name="colSetting" id="193">
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="textAlign">center</property>
<property name="verticalAlign">middle</property>
</style>
<style name="gridRowStyle" id="203">
<structure name="numberFormat">
<property name="category">General Number</property>
<property name="pattern">General Number</property>
</structure>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<table id="270">
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="marginTop">30pt</property>
<property name="marginLeft">15pt</property>
<property name="marginBottom">30pt</property>
<property name="width">7.647058823529412in</property>
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">CUSTOMERNUMBER</property>
<expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression>
<property name="dataType">integer</property>
</structure>
</list-property>
<column id="326">
<property name="width">0.5529411764705883in</property>
<property name="style">colSetting</property>
</column>
<column id="327">
<property name="width">0.9176470588235294in</property>
<property name="style">colSetting</property>
</column>
<column id="328">
<property name="width">0.9176470588235294in</property>
<property name="style">colSetting</property>
</column>
<column id="329">
<property name="width">0.8117647058823529in</property>
<property name="style">colSetting</property>
</column>
<column id="330">
<property name="width">0.8117647058823529in</property>
<property name="style">colSetting</property>
</column>
<header>
<row id="271">
<cell id="272">
<property name="fontWeight">bold</property>
<label id="336">
<property name="fontSize">9pt</property>
<property name="textAlign">center</property>
<text-property name="text">Sr.No</text-property>
</label>
</cell>
<cell id="273">
<label id="337">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">User ID</text-property>
</label>
</cell>
<cell id="274">
<label id="338">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Parameter</text-property>
</label>
</cell>
<cell id="275">
<label id="339">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Country-1</text-property>
</label>
</cell>
<cell id="276">
<label id="340">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Country-2</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="282">
<property name="height">0.2235294117647059in</property>
<property name="style">rowSetting</property>
<cell id="283">
<property name="colSpan">1</property>
<property name="rowSpan">3</property>
<property name="scope">rowgroup</property>
<property name="style">colSetting</property>
<property name="showIfBlank">false</property>
<label id="407">
<text-property name="text">1</text-property>
</label>
</cell>
<cell id="284">
<property name="colSpan">1</property>
<property name="rowSpan">3</property>
<property name="textAlign">center</property>
<label id="405">
<text-property name="text">abcde</text-property>
</label>
</cell>
<cell id="285">
<label id="351">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Country</text-property>
</label>
</cell>
<cell id="286">
<property name="fontSize">9pt</property>
<property name="textAlign">center</property>
<label id="410">
<text-property name="text">UK</text-property>
</label>
</cell>
<cell id="287">
<label id="411">
<property name="fontSize">medium</property>
<text-property name="text">USA</text-property>
</label>
</cell>
</row>
<row id="293">
<property name="height">0.24705882352941178in</property>
<property name="style">rowSetting</property>
<cell id="296">
<label id="352">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">No. of Applications</text-property>
</label>
</cell>
<cell id="297">
<label id="412">
<text-property name="text">112</text-property>
</label>
</cell>
<cell id="298">
<label id="413">
<text-property name="text">75</text-property>
</label>
</cell>
</row>
<row id="304">
<property name="height">0.2235294117647059in</property>
<property name="style">rowSetting</property>
<cell id="307">
<label id="353">
<property name="fontSize">9pt</property>
<property name="fontWeight">bold</property>
<property name="textAlign">center</property>
<text-property name="text">Accepted Applications</text-property>
</label>
</cell>
<cell id="308">
<label id="414">
<text-property name="text">52</text-property>
</label>
</cell>
<cell id="309">
<label id="415">
<text-property name="text">29</text-property>
</label>
</cell>
</row>
</detail>
</table>
</body>
</report>
Thank you,
prodigy201
[Updated on: Tue, 08 June 2010 10:00] Report message to a moderator |
|
|
| Re: Problem to set data/element into cells created by adding column dynamically in two-dimensional t [message #538730 is a reply to message #538588] |
Tue, 08 June 2010 13:50 |
|
The whole report did not come through. Could you email it to me at
jasonweathersby at windstream dot net?
BTW once you get the handle to the proper row:
RowHandle myNewCntry = (RowHandle)
dynamicTable.getDetail().get(0);
RowHandle myNewPercent = (RowHandle)
dynamicTable.getDetail().get(1);
RowHandle myNewHits = (RowHandle)
dynamicTable.getDetail().get(2);
This should be returning a specific column. Ie
//column 1
CellHandle firstCell = (CellHandle) myNewCntry.getCells().get(0);
//column 2
CellHandle firstCell = (CellHandle) myNewCntry.getCells().get(1);
Jason
On 6/8/2010 3:09 AM, prodigy201 wrote:
> Hi Jason,
>
> Please go through the XML (rptdesign) for my report given below.
> And yeah, you are right, my report has 3 sub-rows in 1 main row. You
> will find in my reprt design, I've used classicmodels for DB source and
> DATA SET just for now to bind it to my table. (Its just for binding
> Dataset to table, It has nothing to do with my report though, as my
> actual dataset is surely going to be different).
>
> Moreover, you'll observe the actual format of report and will get idea
> of data I want to represent. Instead of DATA ELEMENT, I've taken LABELS
> (just for now) in every cell. (Every cell will be filled with DATA
> ELEMENT only later). The third column "Parameters" will get repeated
> everytime with its "static labels" - "Country", "No. of Applications",
> "Accepted Applications".
> I want to add 3 columns - Country-3 to Country-5 dynamically in this
> table, and hence the data in every cell dynamically. But, as per my JAVA
> code(given below), its only adding DATA/LABEL for "Country" only and NOT
> FOR "No. of Applications", "Accepted Applications". Now, I hope you
> understood what I want to do.
>
> RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
> RowHandle myNewApplis = (RowHandle) dynamicTable.getDetail().get(1);
> RowHandle myNewSelectdApplis = (RowHandle) dynamicTable.getDetail().get(2);
>
>
> Following is XML for rptdesign. -
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page><?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="270">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="marginTop">30pt</property>
> <property name="marginLeft">15pt</property>
> <property name="marginBottom">30pt</property>
> <property name="width">7.647058823529412in</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="326">
> <property name="width">0.5529411764705883in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="327">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="328">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="329">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="330">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <header>
> <row id="271">
> <cell id="272">
> <property name="fontWeight">bold</property>
> <label id="336">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <text-property name="text">Sr.No</text-property>
> </label>
> </cell>
> <cell id="273">
> <label id="337">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">User ID</text-property>
> </label>
> </cell>
> <cell id="274">
> <label id="338">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Parameter</text-property>
> </label>
> </cell>
> <cell id="275">
> <label id="339">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-1</text-property>
> </label>
> </cell>
> <cell id="276">
> <label id="340">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-2</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="282">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="283">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="scope">rowgroup</property>
> <property name="style">colSetting</property>
> <property name="showIfBlank">false</property>
> <label id="407">
> <text-property name="text">1</text-property>
> </label>
> </cell>
> <cell id="284">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="textAlign">center</property>
> <label id="405">
> <text-property name="text">abcde</text-property>
> </label>
> </cell>
> <cell id="285">
> <label id="351">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country</text-property>
> </label>
> </cell>
> <cell id="286">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <label id="410">
> <text-property name="text">UK</text-property>
> </label>
> </cell>
> <cell id="287">
> <label id="411">
> <property name="fontSize">medium</property>
> <text-property name="text">USA</text-property>
> </label>
> </cell>
> </row>
> <row id="293">
> <property name="height">0.24705882352941178in</property>
> <property name="style">rowSetting</property>
> <cell id="296">
> <label id="352">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">No. of Applications</text-property>
> </label>
> </cell>
> <cell id="297"><?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="270">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="marginTop">30pt</property>
> <property name="marginLeft">15pt</property>
> <property name="marginBottom">30pt</property>
> <property name="width">7.647058823529412in</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="326">
> <property name="width">0.5529411764705883in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="327">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="328">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="329">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="330">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <header>
> <row id="271">
> <cell id="272">
> <property name="fontWeight">bold</property>
> <label id="336">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <text-property name="text">Sr.No</text-property>
> </label>
> </cell>
> <cell id="273">
> <label id="337">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">User ID</text-property>
> </label>
> </cell>
> <cell id="274">
> <label id="338">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Parameter</text-property>
> </label>
> </cell>
> <cell id="275">
> <label id="339">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-1</text-property>
> </label>
> </cell>
> <cell id="276">
> <label id="340">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-2</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="282">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="283">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="scope">rowgroup</property>
> <property name="style">colSetting</property>
> <property name="showIfBlank">false</property>
> <label id="407">
> <text-property name="text">1</text-property>
> </label>
> </cell>
> <cell id="284">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="textAlign">center</property>
> <label id="405">
> <text-property name="text">abcde</text-property>
> </label>
> </cell>
> <cell id="285">
> <label id="351">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country</text-property>
> </label>
> </cell>
> <cell id="286">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <label id="410">
> <text-property name="text">UK</text-property>
> </label>
> </cell>
> <cell id="287">
> <label id="411">
> <property name="fontSize">medium</property>
> <text-property name="text">USA</text-property>
> </label>
> </cell>
> </row>
> <row id="293">
> <property name="height">0.24705882352941178in</property>
> <property name="style">rowSetting</property>
> <cell id="296">
> <label id="352"><?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="270">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="marginTop">30pt</property>
> <property name="marginLeft">15pt</property>
> <property name="marginBottom">30pt</property>
> <property name="width">7.647058823529412in</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="326">
> <property name="width">0.5529411764705883in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="327">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="328">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="329">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="330">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <header>
> <row id="271">
> <cell id="272">
> <property name="fontWeight">bold</property>
> <label id="336">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <text-property name="text">Sr.No</text-property>
> </label>
> </cell>
> <cell id="273">
> <label id="337">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">User ID</text-property>
> </label>
> </cell>
> <cell id="274">
> <label id="338">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Parameter</text-property>
> </label>
> </cell>
> <cell id="275">
> <label id="339">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-1</text-property>
> </label>
> </cell>
> <cell id="276">
> <label id="340">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-2</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="282">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="283">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="scope">rowgroup</property>
> <property name="style">colSetting</property>
> <property name="showIfBlank">false</property>
> <label id="407">
> <text-property name="text">1</text-property>
> </label>
> </cell>
> <cell id="284">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="textAlign">center</property>
> <label id="405">
> <text-property name="text">abcde</text-property>
> </label>
> </cell>
> <cell id="285">
> <label id="351">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country</text-property>
> </label>
> </cell>
> <cell id="286">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <label id="410">
> <text-property name="text">UK</text-property>
> </label>
> </cell>
> <cell id="287">
> <label id="411">
> <property name="fontSize">medium</property>
> <text-property name="text">USA</text-property>
> </label>
> </cell>
> </row>
> <row id="293">
> <property name="height">0.24705882352941178in</property>
> <property name="style">rowSetting</property>
> <cell id="296">
> <label id="352">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">No. of Applications</text-property>
> </label>
> </cell>
> <cell id="297">
> <label id="412">
> <text-property name="text">112</text-property>
> </label>
> </cell>
> <cell id="298">
> <label id="413">
> <text-property name="text">75</text-property>
> </label>
> </cell>
> </row>
> <row id="304">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="307">
> <label id="353">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Accepted Applications</text-property>
> </label>
> </cell>
> <cell id="308">
> <label id="414">
> <text-property name="text">52</text-property>
> </label>
> </cell>
> <cell id="309">
> <label id="415">
> <text-property name="text">29</text-property>
> </label>
> </cell>
> </row>
> </detail>
> </table>
> </body>
> </report>
>
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">No. of Applications</text-property>
> </label>
> </cell>
> <cell id="297">
> <label id="412">
> <text-property name="text">112</text-property>
> </label>
> </cell>
> <cell id="298">
> <label id="413">
> <text-property name="text">75</text-property>
> </label>
> </cell>
> </row>
> <row id="304">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="307">
> <label id="353">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
|
|
|
| Re: Problem to set data/element into cells created by adding column dynamically in two-dimensional t [message #539410 is a reply to message #538588] |
Thu, 10 June 2010 15:47 |
|
I sent you an email with example code. You merged the rows for columns
1 and 2 for all three detail rows. So row one will have two more cells
than row 2 and 3.
Jason
On 6/8/2010 3:09 AM, prodigy201 wrote:
> Hi Jason,
>
> Please go through the XML (rptdesign) for my report given below.
> And yeah, you are right, my report has 3 sub-rows in 1 main row. You
> will find in my reprt design, I've used classicmodels for DB source and
> DATA SET just for now to bind it to my table. (Its just for binding
> Dataset to table, It has nothing to do with my report though, as my
> actual dataset is surely going to be different).
>
> Moreover, you'll observe the actual format of report and will get idea
> of data I want to represent. Instead of DATA ELEMENT, I've taken LABELS
> (just for now) in every cell. (Every cell will be filled with DATA
> ELEMENT only later). The third column "Parameters" will get repeated
> everytime with its "static labels" - "Country", "No. of Applications",
> "Accepted Applications".
> I want to add 3 columns - Country-3 to Country-5 dynamically in this
> table, and hence the data in every cell dynamically. But, as per my JAVA
> code(given below), its only adding DATA/LABEL for "Country" only and NOT
> FOR "No. of Applications", "Accepted Applications". Now, I hope you
> understood what I want to do.
>
> RowHandle myNewCntry = (RowHandle) dynamicTable.getDetail().get(0);
> RowHandle myNewApplis = (RowHandle) dynamicTable.getDetail().get(1);
> RowHandle myNewSelectdApplis = (RowHandle) dynamicTable.getDetail().get(2);
>
>
> Following is XML for rptdesign. -
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page><?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="270">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="marginTop">30pt</property>
> <property name="marginLeft">15pt</property>
> <property name="marginBottom">30pt</property>
> <property name="width">7.647058823529412in</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="326">
> <property name="width">0.5529411764705883in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="327">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="328">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="329">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="330">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <header>
> <row id="271">
> <cell id="272">
> <property name="fontWeight">bold</property>
> <label id="336">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <text-property name="text">Sr.No</text-property>
> </label>
> </cell>
> <cell id="273">
> <label id="337">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">User ID</text-property>
> </label>
> </cell>
> <cell id="274">
> <label id="338">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Parameter</text-property>
> </label>
> </cell>
> <cell id="275">
> <label id="339">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-1</text-property>
> </label>
> </cell>
> <cell id="276">
> <label id="340">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-2</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="282">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="283">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="scope">rowgroup</property>
> <property name="style">colSetting</property>
> <property name="showIfBlank">false</property>
> <label id="407">
> <text-property name="text">1</text-property>
> </label>
> </cell>
> <cell id="284">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="textAlign">center</property>
> <label id="405">
> <text-property name="text">abcde</text-property>
> </label>
> </cell>
> <cell id="285">
> <label id="351">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country</text-property>
> </label>
> </cell>
> <cell id="286">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <label id="410">
> <text-property name="text">UK</text-property>
> </label>
> </cell>
> <cell id="287">
> <label id="411">
> <property name="fontSize">medium</property>
> <text-property name="text">USA</text-property>
> </label>
> </cell>
> </row>
> <row id="293">
> <property name="height">0.24705882352941178in</property>
> <property name="style">rowSetting</property>
> <cell id="296">
> <label id="352">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">No. of Applications</text-property>
> </label>
> </cell>
> <cell id="297"><?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="270">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="marginTop">30pt</property>
> <property name="marginLeft">15pt</property>
> <property name="marginBottom">30pt</property>
> <property name="width">7.647058823529412in</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="326">
> <property name="width">0.5529411764705883in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="327">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="328">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="329">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="330">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <header>
> <row id="271">
> <cell id="272">
> <property name="fontWeight">bold</property>
> <label id="336">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <text-property name="text">Sr.No</text-property>
> </label>
> </cell>
> <cell id="273">
> <label id="337">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">User ID</text-property>
> </label>
> </cell>
> <cell id="274">
> <label id="338">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Parameter</text-property>
> </label>
> </cell>
> <cell id="275">
> <label id="339">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-1</text-property>
> </label>
> </cell>
> <cell id="276">
> <label id="340">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-2</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="282">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="283">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="scope">rowgroup</property>
> <property name="style">colSetting</property>
> <property name="showIfBlank">false</property>
> <label id="407">
> <text-property name="text">1</text-property>
> </label>
> </cell>
> <cell id="284">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="textAlign">center</property>
> <label id="405">
> <text-property name="text">abcde</text-property>
> </label>
> </cell>
> <cell id="285">
> <label id="351">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country</text-property>
> </label>
> </cell>
> <cell id="286">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <label id="410">
> <text-property name="text">UK</text-property>
> </label>
> </cell>
> <cell id="287">
> <label id="411">
> <property name="fontSize">medium</property>
> <text-property name="text">USA</text-property>
> </label>
> </cell>
> </row>
> <row id="293">
> <property name="height">0.24705882352941178in</property>
> <property name="style">rowSetting</property>
> <cell id="296">
> <label id="352"><?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090917-1447></property>
> <property name="units">in</property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <property name="bidiLayoutOrientation">ltr</property>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="Data Source" id="408">
> <text-property name="displayName"></text-property>
> <property
> name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver </property>
>
> <property name="odaURL">jdbc:classicmodels:sampledb</property>
> <property name="odaUser">ClassicModels</property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Data Set" id="409">
> <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
> CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER
> from CLASSICMODELS.CUSTOMERS]]></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>1.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:name>CUSTOMERNUMBER</design:name>
> <design:position>1</design:position>
> <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
> <design:precision>10</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>Nullable</design:nullability>
> <design:uiHints>
> <design:displayName>CUSTOMERNUMBER</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>CUSTOMERNUMBER</design:label>
> <design:formattingHints>
> <design:displaySize>11</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> </design:resultSetColumns>
> </design:resultSetDefinitions>
> </design:ResultSets>
> </model:DesignValues>
> ]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="rowSetting" id="192">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="colSetting" id="193">
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="textAlign">center</property>
> <property name="verticalAlign">middle</property>
> </style>
> <style name="gridRowStyle" id="203">
> <structure name="numberFormat">
> <property name="category">General Number</property>
> <property name="pattern">General Number</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <page-footer>
> <text id="3">
> <property name="contentType">html</property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <table id="270">
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="marginTop">30pt</property>
> <property name="marginLeft">15pt</property>
> <property name="marginBottom">30pt</property>
> <property name="width">7.647058823529412in</property>
> <property name="dataSet">Data Set</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">CUSTOMERNUMBER</property>
> <expression name="expression">dataSetRow["CUSTOMERNUMBER"]</expression >
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> <column id="326">
> <property name="width">0.5529411764705883in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="327">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="328">
> <property name="width">0.9176470588235294in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="329">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <column id="330">
> <property name="width">0.8117647058823529in</property>
> <property name="style">colSetting</property>
> </column>
> <header>
> <row id="271">
> <cell id="272">
> <property name="fontWeight">bold</property>
> <label id="336">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <text-property name="text">Sr.No</text-property>
> </label>
> </cell>
> <cell id="273">
> <label id="337">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">User ID</text-property>
> </label>
> </cell>
> <cell id="274">
> <label id="338">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Parameter</text-property>
> </label>
> </cell>
> <cell id="275">
> <label id="339">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-1</text-property>
> </label>
> </cell>
> <cell id="276">
> <label id="340">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country-2</text-property>
> </label>
> </cell>
> </row>
> </header>
> <detail>
> <row id="282">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="283">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="scope">rowgroup</property>
> <property name="style">colSetting</property>
> <property name="showIfBlank">false</property>
> <label id="407">
> <text-property name="text">1</text-property>
> </label>
> </cell>
> <cell id="284">
> <property name="colSpan">1</property>
> <property name="rowSpan">3</property>
> <property name="textAlign">center</property>
> <label id="405">
> <text-property name="text">abcde</text-property>
> </label>
> </cell>
> <cell id="285">
> <label id="351">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Country</text-property>
> </label>
> </cell>
> <cell id="286">
> <property name="fontSize">9pt</property>
> <property name="textAlign">center</property>
> <label id="410">
> <text-property name="text">UK</text-property>
> </label>
> </cell>
> <cell id="287">
> <label id="411">
> <property name="fontSize">medium</property>
> <text-property name="text">USA</text-property>
> </label>
> </cell>
> </row>
> <row id="293">
> <property name="height">0.24705882352941178in</property>
> <property name="style">rowSetting</property>
> <cell id="296">
> <label id="352">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">No. of Applications</text-property>
> </label>
> </cell>
> <cell id="297">
> <label id="412">
> <text-property name="text">112</text-property>
> </label>
> </cell>
> <cell id="298">
> <label id="413">
> <text-property name="text">75</text-property>
> </label>
> </cell>
> </row>
> <row id="304">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="307">
> <label id="353">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">Accepted Applications</text-property>
> </label>
> </cell>
> <cell id="308">
> <label id="414">
> <text-property name="text">52</text-property>
> </label>
> </cell>
> <cell id="309">
> <label id="415">
> <text-property name="text">29</text-property>
> </label>
> </cell>
> </row>
> </detail>
> </table>
> </body>
> </report>
>
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
> <property name="textAlign">center</property>
> <text-property name="text">No. of Applications</text-property>
> </label>
> </cell>
> <cell id="297">
> <label id="412">
> <text-property name="text">112</text-property>
> </label>
> </cell>
> <cell id="298">
> <label id="413">
> <text-property name="text">75</text-property>
> </label>
> </cell>
> </row>
> <row id="304">
> <property name="height">0.2235294117647059in</property>
> <property name="style">rowSetting</property>
> <cell id="307">
> <label id="353">
> <property name="fontSize">9pt</property>
> <property name="fontWeight">bold</property>
|
|
|
Goto Forum:
Current Time: Tue Apr 23 08:12:30 GMT 2024
Powered by FUDForum. Page generated in 0.05927 seconds |
] 
Search
Help
Register
Login
Home
