Eclipse Community Forums: ServerTools (WTP) » Problem with the Export Data options from the BIRT

Help

Home

Home » Language IDEs » ServerTools (WTP) » Problem with the Export Data options from the BIRT - toolbar

Show: Today's Messages :: Show Polls :: Message Navigator

Problem with the Export Data options from the BIRT - toolbar [message #210673]

Thu, 20 March 2008 16:48

Eclipse User

Originally posted by: seemakhopade.hsbc.co.in

Hello,

I need help for the following issue as soon as possible, as our appl users
are facing lot many problems.

When I click on the 'Export Data' option from the BIRT-Web Viewer's
toolbar,
It displays some unwanted columns in 'Available Column' list.

Name of the unwanted columns are like.. Total_Column_5, Total_column_6...

Here is the XML Source of My report design:

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.14"
id="1">
<property name="createdBy">Eclipse BIRT Designer Version
2.2.0.v20070620 Build <2.2.0.v20070626-1003></property>
<property name="units">in</property>
<text-property name="title"></text-property>
<property name="comments">Copyright (c) 2007 <<Your Company Name
here>></property>
<html-property name="description">Creates a blank report with no
predefined content.</html-property>
<text-property name="displayName">Blank Report</text-property>
<property name="iconFile">/templates/blank_report.gif</property>
<list-property name="cssStyleSheets">
<structure>
<property name="fileName"></property>
</structure>
</list-property>
<parameters>
<scalar-parameter name="ReportFilters" id="1582">
<property name="valueType">static</property>
<property name="dataType">string</property>
<text-property name="promptText">Select Report
Filter</text-property>
<property name="controlType">list-box</property>
<property name="mustMatch">true</property>
<property name="fixedOrder">false</property>
<property name="defaultValue">All Non Zeros</property>
<property name="distinct">false</property>
<property name="sortBy">label</property>
<property name="sortDirection">asc</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
<list-property name="selectionList">
<structure>
<property name="value">Exceptions Only</property>
<property name="label">Exceptions Only</property>
</structure>
<structure>
<property name="value">All Non Zeros</property>
<property name="label">All Records</property>
</structure>
</list-property>
</scalar-parameter>
<cascading-parameter-group name="AsAtDateCurrency" id="2082">
<property name="promptText">Select As At Date and then
Currency</property>
<property name="dataSetMode">multiple</property>
<parameters>
<scalar-parameter name="As At Date" id="2083">
<property name="valueType">dynamic</property>
<property name="dataType">string</property>
<text-property name="promptText">Select As At
Date</text-property>
<property name="isRequired">true</property>
<property name="controlType">list-box</property>
<property name="dataSetName">AsAtDate</property>
<expression
name="valueExpr">row["AS_AT_DATE"]</expression>
<expression
name="labelExpr">row["AS_AT_DATE"]</expression>
<property name="defaultValue"></property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Currency" id="2084">
<property name="valueType">dynamic</property>
<text-property name="promptText">Select
Currency</text-property>
<property name="isRequired">true</property>
<property name="controlType">list-box</property>
<property name="dataSetName">ccy Currency</property>
<expression
name="valueExpr">row["CURRENCY"]</expression>
<expression
name="labelExpr">row["CURRENCY"]</expression>
<property name="defaultValue">All</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
</cascading-parameter-group>
<cascading-parameter-group name="BusinessAreaPLGrouping" id="250">
<property name="promptText">Select Business Area and PL
Grouping and then Cost Centre</property>
<property name="dataSetMode">multiple</property>
<parameters>
<scalar-parameter name="Business Area" id="251">
<property name="valueType">dynamic</property>
<property name="dataType">string</property>
<text-property name="promptText">Select Business
Area</text-property>
<property name="isRequired">true</property>
<property name="controlType">list-box</property>
<property name="dataSetName">business_area</property>
<expression
name="valueExpr">row["BUSINESS_AREA"]</expression>
<expression
name="labelExpr">row["BUSINESS_AREA"]</expression>
<property name="defaultValue"></property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Sophis Business" id="252">
<property name="valueType">dynamic</property>
<text-property name="promptText">Select PL
Grouping</text-property>
<property name="isRequired">true</property>
<property name="controlType">list-box</property>
<property name="dataSetName">PL Grouping</property>
<expression
name="valueExpr">row["SOPHIS_BUSINESS"]</expression>
<expression
name="labelExpr">row["SOPHIS_BUSINESS"]</expression>
<property name="defaultValue">All</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="Cost Center" id="1580">
<property name="valueType">dynamic</property>
<text-property name="promptText">Select Cost
Centre</text-property>
<property name="isRequired">true</property>
<property name="controlType">list-box</property>
<property name="dataSetName">Cost Center</property>
<expression
name="valueExpr">row["COST_CENTRE"]</expression>
<expression
name="labelExpr">row["COST_CENTRE"]</expression>
<property name="defaultValue">All</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
</cascading-parameter-group>
</parameters>
<data-sources>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Rec" id="1576">
<property name="odaDriverClass"></property>
<property name="odaURL"></property>
<property name="odaUser"></property>
<encrypted-property name="odaPassword">/encrypted-property>
</oda-data-source>
<oda-data-source
extensionID="org.eclipse.birt.report.data.oda.jdbc" name="RecUAT"
id="2039">
<property name="odaDriverClass"></property>
<property name="odaURL"></property>
<property name="odaUser"></property>
<encrypted-property name="odaPassword"></encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="FO_BO_GL" id="1481">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COST_CENTRE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CCY</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ACCOUNT</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ACCOUNT_NAME</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">FO_MTM_SUM</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">BO_MTM_SUM</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">GL_MTM_SUM</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">FOBO_MTM_DIFF</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">BOGL_MTM_DIFF</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">FOGL_MTM_DIFF</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">RecUAT</property>
<method name="beforeOpen"><![CDATA[this.queryText =
this.queryText + " where AS_AT_DATE = '"+params['As At Date']+"' ";

if(params['Currency'] != 'All'){
this.queryText = this.queryText + " and CCY = '"+params['Currency'] +
"' ";
}

//user wanna see all the cost centers present in STATIC_BOOK_MAPPING
if(params['Cost Center'] == "All"){

this.queryText = this.queryText +
" and COST_CENTRE in ( "+
" (select COST_CENTRE "+
" from STATIC_BOOK_MAPPING "+
" where BUSINESS_AREA = '"+params['Business Area'] + "' ";

//if user want to see cost center irrespective of pl grouping
//then do not include PL grouping in where clause else need to
//include pl grouping in where clause
if(params['Sophis Business'] != "All"){
this.queryText = this.queryText + " and SOPHIS_BUSINESS =
'"+params['Sophis Business'] + "' ";
}

this.queryText = this.queryText + " ) UNION (SELECT distinct TREATS_CC
as COST_CENTRE "+
" FROM STATIC_BOOK_MAPPING where business_area = '"+params['Business
Area'] + "' ";

if(params['Sophis Business'] != "All"){
this.queryText = this.queryText + " and SOPHIS_BUSINESS =
'"+params['Sophis Business'] + "' ";
}

this.queryText = this.queryText + " )) ";//end of in

} else {//user has selected only one cost code
this.queryText = this.queryText + " and COST_CENTRE = '"+params['Cost
Center'] + "' ";
}

if(params['ReportFilters'] == "Exceptions Only"){
//report fliter = exceptions only
this.queryText = this.queryText +
" AND (round(FOBO_MTM_DIFF,2) != 0"+
" OR round(BOGL_MTM_DIFF,2) != 0"+
" OR round(FOGL_MTM_DIFF,2) != 0 )";
} else if(params['ReportFilters'] == "All Non Zeros"){
//all records = all non zeros change on 19Mar2008
//report fliter = All Non Zeros
this.queryText = this.queryText +
" AND (round(FO_MTM_SUM,2) != 0"+
" OR round(BO_MTM_SUM,2) != 0"+
" OR round(GL_MTM_SUM,2) != 0 )";
}]]></method>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COST_CENTRE</property>
<property name="nativeName">COST_CENTRE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">CCY</property>
<property name="nativeName">CCY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">ACCOUNT</property>
<property name="nativeName">ACCOUNT</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">ACCOUNT_NAME</property>
<property name="nativeName">ACCOUNT_NAME</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">FO_MTM_SUM</property>
<property name="nativeName">FO_MTM_SUM</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">BO_MTM_SUM</property>
<property name="nativeName">BO_MTM_SUM</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">GL_MTM_SUM</property>
<property name="nativeName">GL_MTM_SUM</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">FOBO_MTM_DIFF</property>
<property name="nativeName">FOBO_MTM_DIFF</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">BOGL_MTM_DIFF</property>
<property name="nativeName">BOGL_MTM_DIFF</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">FOGL_MTM_DIFF</property>
<property name="nativeName">FOGL_MTM_DIFF</property>
<property name="dataType">decimal</property>
<property name="nativeDataType">2</property>
</structure>
</list-property>
<property name="queryText">select
COST_CENTRE,
CCY,
ACCOUNT,
ACCOUNT_NAME,
round(FO_MTM_SUM,2) FO_MTM_SUM,
round(BO_MTM_SUM,2) BO_MTM_SUM,
round(GL_MTM_SUM,2) GL_MTM_SUM,
round(FOBO_MTM_DIFF,2) FOBO_MTM_DIFF,
round(BOGL_MTM_DIFF,2) BOGL_MTM_DIFF,
round(FOGL_MTM_DIFF,2) FOGL_MTM_DIFF
from REC_FO_BO_GL </property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="business_area" id="237">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">BUSINESS_AREA</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Rec</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">BUSINESS_AREA</property>
<property name="nativeName">BUSINESS_AREA</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select distinct
PLR.STATIC_BOOK_MAPPING.BUSINESS_AREA
from PLR.STATIC_BOOK_MAPPING
order by PLR.STATIC_BOOK_MAPPING.BUSINESS_AREA</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="PL Grouping" id="243">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">SOPHIS_BUSINESS</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Rec</property>
<method name="beforeOpen"><![CDATA[if(params['Business Area']
!= ""){
this.queryText = this.queryText + " where BUSINESS_AREA =
'"+params['Business Area'] + "' ";
}

this.queryText = this.queryText + " order by SOPHIS_BUSINESS";]]></method>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">SOPHIS_BUSINESS</property>
<property name="nativeName">SOPHIS_BUSINESS</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select distinct
SOPHIS_BUSINESS
from STATIC_BOOK_MAPPING</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="Cost Center" id="254">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COST_CENTRE</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Rec</property>
<method name="beforeOpen"><![CDATA[if(params['Business Area']
!= ""){
this.queryText = this.queryText + " where BUSINESS_AREA =
'"+params['Business Area'] + "' ";
}

//cost centres are retrieved from the table static_book_mapping
//and its depends on the busines area and pl grouping selected
//business area is a mandatory whereas use may select all from the pl
grouping
//in that case we need to ignore pl grouping in where clause
if(params['Sophis Business'] != "All"){
this.queryText = this.queryText + " and SOPHIS_BUSINESS =
'"+params['Sophis Business'] + "' ";
}

this.queryText = this.queryText + " union SELECT distinct TREATS_CC as
COST_CENTRE "+
"FROM STATIC_BOOK_MAPPING ";

if(params['Business Area'] != ""){
this.queryText = this.queryText + " where BUSINESS_AREA =
'"+params['Business Area'] + "' ";
}

//cost centres are retrieved from the table static_book_mapping
//and its depends on the busines area and pl grouping selected
//business area is a mandatory whereas use may select all from the pl
grouping
//in that case we need to ignore pl grouping in where clause
if(params['Sophis Business'] != "All"){
this.queryText = this.queryText + " and SOPHIS_BUSINESS =
'"+params['Sophis Business'] + "' ";
}

//this.queryText = this.queryText + " order by COST_CENTRE";]]></method>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">COST_CENTRE</property>
<property name="nativeName">COST_CENTRE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select distinct COST_CENTRE
from
STATIC_BOOK_MAPPING
</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="AsAtDate" id="1641">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">AS_AT_DATE</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">AS_AT_DATE1</property>
<property name="dataType">date-time</property>
</structure>
</list-property>
</structure>
<property name="dataSource">RecUAT</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">AS_AT_DATE</property>
<property name="nativeName">AS_AT_DATE</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">AS_AT_DATE1</property>
<property name="nativeName">AS_AT_DATE1</property>
<property name="dataType">date-time</property>
<property name="nativeDataType">93</property>
</structure>
</list-property>
<property name="queryText">select distinct
(TO_CHAR(as_at_date , 'dd MON yyyy') )
as_at_date, as_at_date as_at_date1
from REC_FO_BO_GL
order by as_at_date1 desc</property>
</oda-data-set>
<oda-data-set
extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
name="ccy Currency" id="2041">
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CURRENCY</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">RecUAT</property>
<method name="beforeOpen"><![CDATA[if(params['As At Date'] !=
""){
this.queryText = this.queryText + " where AS_AT_DATE = '"+params['As At
Date'] + "' ";
}

this.queryText = this.queryText + " order by CCY";]]></method>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">CURRENCY</property>
<property name="nativeName">CURRENCY</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<property name="queryText">select distinct( CCY) as currency
from REC_FO_BO_GL </property>
</oda-data-set>
</data-sets>
<styles>
<style name="crosstab" id="4">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="type">custom</property>
<property name="height">20cm</property>
<property name="width">40cm</property>
<page-footer>
<text id="3">
<property name="fontSize">8pt</property>
<property name="textAlign">left</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[Print Date :
<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<text id="1003">
<property name="style">REPORT-TITLE</property>
<property name="fontFamily">"Verdana"</property>
<property name="fontSize">10pt</property>
<property name="fontWeight">bold</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomWidth">thin</property>
<property name="marginTop">0pt</property>
<property name="marginBottom">10pt</property>
<property name="textAlign">left</property>
<property name="textIndent">0em</property>
<property name="verticalAlign">top</property>
<property name="contentType">auto</property>
<text-property name="content"><![CDATA[FO-BO-GL Reconciliation
Market Value Report]]></text-property>
</text>
<table id="974">
<property name="backgroundColor">#FFFFFF</property>
<property name="marginTop">10pt</property>
<property name="marginLeft">0pt</property>
<property name="marginBottom">0pt</property>
<property name="marginRight">0pt</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">0pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
<property name="textAlign">center</property>
<property name="showIfBlank">true</property>
<property name="canShrink">true</property>
<property name="width">65%</property>
<column id="1063">
<property name="width">1.2395833333in</property>
<property name="fontSize">8pt</property>
<property name="color">#008080</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">2pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
</column>
<column id="1064">
<property name="width">1.448in</property>
<property name="style">DATA-ROW1</property>
<property name="paddingLeft">2px</property>
</column>
<column id="1065">
<property name="width">0.5%</property>
<property name="backgroundColor">#FFFFFF</property>
<property name="fontSize">8pt</property>
<property name="color">#008080</property>
</column>
<column id="1066">
<property name="width">1.24in</property>
<property name="fontSize">8pt</property>
<property name="color">#008080</property>
<property name="paddingTop">0pt</property>
<property name="paddingLeft">2pt</property>
<property name="paddingBottom">0pt</property>
<property name="paddingRight">0pt</property>
</column>
<column id="1067">
<property name="width">1.448in</property>
<property name="style">DATA-ROW1</property>
<property name="paddingLeft">2px</property>
</column>
<detail>
<row id="975">
<cell id="976">
<property name="style">DARK-BACKGROUND</property>
<label id="1354">
<property
name="style">DARK-BACKGROUND</property>
<property name="fontWeight">bold</property>
<property name="color">#000000</property>
<property name="textAlign">left</property>
<text-property name="text">As At Date
:</text-property>
</label>
</cell>
<cell id="978">
<property name="style">DARK-BACKGROUND</property>
<data id="1501">
<list-property name="boundDataColumns">
<structure>
<property name="name">As At
Date</property>
<expression
name="expression">params["As At Date"]</expression>
</structure>
</list-property>
<property name="resultSetColumn">As At
Date</property>
</data>
</cell>
<cell id="1053"/>
<cell id="1054">
<property name="style">DARK-BACKGROUND</property>
<label id="1055">
<property
name="style">DARK-BACKGROUND</property>
<property name="fontWeight">bold</property>
<property name="color">#000000</property>
<property name="textAlign">left</property>
<text-property name="text">Business Area
:</text-property>
</label>
</cell>
<cell id="1056">
<property name="style">DARK-BACKGROUND</property>
<data id="1484">
<list-property name="boundDataColumns">
<structure>
<property name="name">Business
Area</property>
<expression
name="expression">params["Business Area"]</expression>
</structure>
</list-property>
<property name="resultSetColumn">Business
Area</property>
</data>
</cell>
</row>
<row id="1057">
<cell id="1058">
<property name="backgroundColor">#FFFFFF</property>
</cell>
<cell id="1059">
<property name="backgroundColor">#FFFFFF</property>
</cell>
<cell id="1060">
<property name="backgroundColor">#FFFFFF</property>
</cell>
<cell id="1061">
<property name="backgroundColor">#FFFFFF</property>
</cell>
<cell id="1062">
<property name="backgroundColor">#FFFFFF</property>
</cell>
</row>
<row id="1039">
<property name="style">LIGHT-BACKGROUND</property>
<cell id="1040">
<label id="1045">
<property
name="style">LIGHT-BACKGROUND</property>
<property name="fontWeight">bold</property>
<property name="color">#000000</property>
<property name="textAlign">left</property>
<text-property name="text">PL Grouping
:</text-property>
</label>
</cell>
<cell id="1041">
<data id="1618">
<list-property name="boundDataColumns">
<structure>
<property name="name">Sophis
Business</property>
<expression
name="expression">params["Sophis Business"]</expression>
</structure>
</list-property>
<property name="resultSetColumn">Sophis
Business</property>
</data>
</cell>
<cell id="1042"/>
<cell id="1043">
<label id="1046">
<property
name="style">LIGHT-BACKGROUND</property>
<property name="fontWeight">bold</property>
<property name="color">#000000</property>
<property name="textAlign">left</property>
<text-property name="text">Cost centre
:</text-property>
</label>
</cell>
<cell id="1044">
<data id="1581">
<list-property name="boundDataColumns">
<structure>
<property name="name">Cost
Center</property>
<expression
name="expression">params["Cost Center"]</expression>
</structure>
</list-property>
<property name="resultSetColumn">Cost
Center</property>
</data>
</cell>
</row>
<row id="1619">
<cell id="1620"/>
<cell id="1621"/>
<cell id="1622"/>
<cell id="1623"/>
<cell id="1624"/>
</row>
<row id="1625">
<property name="style">DARK-BACKGROUND</property>
<cell id="1626">
<label id="1588">
<property
name="style">DARK-BACKGROUND</property>
<property name="fontWeight">bold</property>
<property name="color">#000000</property>
<property name="textAlign">left</property>
<text-property name="text">Report Filter
:</text-property>
</label>
</cell>
<cell id="1627">
<data id="1617">
<list-property name="boundDataColumns">
<structure>
<property
name="name">ReportFilters</property>
<expression
name="expression">if(params["ReportFilters"]=='All Non Zeros'){
'All Records'
} else {
params["ReportFilters"]
}</expression>
<property
name="dataType">any</property>
</structure>
</list-property>
<property
name="resultSetColumn">ReportFilters</property>
</data>
</cell>
<cell id="1628"/>
<cell id="1629">
<label id="2059">
<property name="fontWeight">bold</property>
<property name="color">#000000</property>
<property name="textAlign">left</property>
<text-property name="text">Currency
:</text-property>
</label>
</cell>
<cell id="1630">
<data id="2072">
<list-property name="boundDataColumns">
<structure>
<property
name="name">Currency</property>
<expression
name="expression">params["Currency"]</expression>
</structure>
</list-property>
<property
name="resultSetColumn">Currency</property>
</data>
</cell>
</row>
</detail>
</table>
<table id="1359">
<property name="borderBottomColor">#F7F7F7</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#F7F7F7</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#F7F7F7</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#F7F7F7</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="marginTop">20pt</property>
<property name="height">1.2604166667in</property>
<property name="width">95%</property>
<property name="dataSet">FO_BO_GL</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">COST_CENTRE</property>
<expression
name="expression">if(dataSetRow["COST_CENTRE"] == ' ' ||
dataSetRow["COST_CENTRE"] == null){
'No Cost Centre';
} else {
dataSetRow["COST_CENTRE"] ;
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">CCY</property>
<expression name="expression">if(dataSetRow["CCY"] ==
' ' || dataSetRow["CCY"] == null){
'No Currency';
} else {
dataSetRow["CCY"]
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">ACCOUNT</property>
<expression name="expression">if(dataSetRow["ACCOUNT"]
== ' ' || dataSetRow["ACCOUNT"] == null){
'No Account';
} else {
dataSetRow["ACCOUNT"] ;
}</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">FO_MTM_SUM</property>
<expression
name="expression">dataSetRow["FO_MTM_SUM"]</expression>
<property name="dataType">float</property>
</structure>
<structure>
<property name="name">BO_MTM_SUM</property>
<expression
name="expression">dataSetRow["BO_MTM_SUM"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">GL_MTM_SUM</property>
<expression
name="expression">dataSetRow["GL_MTM_SUM"]</expression>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">FOBO_MTM_DIFF</property>
<expression
name="expression">dataSetRow["FOBO_MTM_DIFF"]</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">BOGL_MTM_DIFF</property>
<expression
name="expression">dataSetRow["BOGL_MTM_DIFF"]</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">FOGL_MTM_DIFF</property>
<expression
name="expression">dataSetRow["FOGL_MTM_DIFF"]</expression >
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="name">Aggregation</property>
<expression
name="expression">dataSetRow["FO_MTM_SUM"]</expression>
<property name="dataType">any</property>
<simple-property-list name="aggregateOn">
<value>CCY</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure>
<structure>
<property name="name">Aggregation_1</property>
<expression
name="expression">dataSetRow["BO_MTM_SUM"]</expression>
<property name="dataType">any</property>
<simple-property-list name="aggregateOn">
<value>CCY</value>
</simple-property-list>
<property name="aggregateFunction">sum</property>
</structure

Report message to a moderator

Re: Problem with the Export Data options from the BIRT - toolbar [message #210692 is a reply to message #210673]

Thu, 20 March 2008 17:34

Nitin Dahyabhai

Messages: 4435
Registered: July 2009

Senior Member

Seema, I think this is best asked in the BIRT newsgroup.

Seema wrote:
> Hello,
>
> I need help for the following issue as soon as possible, as our appl
> users are facing lot many problems.
>
> When I click on the 'Export Data' option from the BIRT-Web Viewer's
> toolbar,
> It displays some unwanted columns in 'Available Column' list.
>
> Name of the unwanted columns are like.. Total_Column_5, Total_column_6...
>
> Here is the XML Source of My report design:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.14"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version
> 2.2.0.v20070620 Build <2.2.0.v20070626-1003></property>
> <property name="units">in</property>
> <text-property name="title"></text-property>
> <property name="comments">Copyright (c) 2007 <<Your Company
> Name here>></property>
> <html-property name="description">Creates a blank report with no
> predefined content.</html-property>
> <text-property name="displayName">Blank Report</text-property>
> <property name="iconFile">/templates/blank_report.gif</property>
> <list-property name="cssStyleSheets">
> <structure>
> <property name="fileName"></property>
> </structure>
> </list-property>
> <parameters>
> <scalar-parameter name="ReportFilters" id="1582">
> <property name="valueType">static</property>
> <property name="dataType">string</property>
> <text-property name="promptText">Select Report
> Filter</text-property>
> <property name="controlType">list-box</property>
> <property name="mustMatch">true</property>
> <property name="fixedOrder">false</property>
> <property name="defaultValue">All Non Zeros</property>
> <property name="distinct">false</property>
> <property name="sortBy">label</property>
> <property name="sortDirection">asc</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> <list-property name="selectionList">
> <structure>
> <property name="value">Exceptions Only</property>
> <property name="label">Exceptions Only</property>
> </structure>
> <structure>
> <property name="value">All Non Zeros</property>
> <property name="label">All Records</property>
> </structure>
> </list-property>
> </scalar-parameter>
> <cascading-parameter-group name="AsAtDateCurrency" id="2082">
> <property name="promptText">Select As At Date and then
> Currency</property>
> <property name="dataSetMode">multiple</property>
> <parameters>
> <scalar-parameter name="As At Date" id="2083">
> <property name="valueType">dynamic</property>
> <property name="dataType">string</property>
> <text-property name="promptText">Select As At
> Date</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">list-box</property>
> <property name="dataSetName">AsAtDate</property>
> <expression
> name="valueExpr">row["AS_AT_DATE"]</expression>
> <expression
> name="labelExpr">row["AS_AT_DATE"]</expression>
> <property name="defaultValue"></property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Currency" id="2084">
> <property name="valueType">dynamic</property>
> <text-property name="promptText">Select
> Currency</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">list-box</property>
> <property name="dataSetName">ccy Currency</property>
> <expression
> name="valueExpr">row["CURRENCY"]</expression>
> <expression
> name="labelExpr">row["CURRENCY"]</expression>
> <property name="defaultValue">All</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </cascading-parameter-group>
> <cascading-parameter-group name="BusinessAreaPLGrouping" id="250">
> <property name="promptText">Select Business Area and PL
> Grouping and then Cost Centre</property>
> <property name="dataSetMode">multiple</property>
> <parameters>
> <scalar-parameter name="Business Area" id="251">
> <property name="valueType">dynamic</property>
> <property name="dataType">string</property>
> <text-property name="promptText">Select Business
> Area</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">list-box</property>
> <property name="dataSetName">business_area</property>
> <expression
> name="valueExpr">row["BUSINESS_AREA"]</expression>
> <expression
> name="labelExpr">row["BUSINESS_AREA"]</expression>
> <property name="defaultValue"></property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Sophis Business" id="252">
> <property name="valueType">dynamic</property>
> <text-property name="promptText">Select PL
> Grouping</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">list-box</property>
> <property name="dataSetName">PL Grouping</property>
> <expression
> name="valueExpr">row["SOPHIS_BUSINESS"]</expression>
> <expression
> name="labelExpr">row["SOPHIS_BUSINESS"]</expression>
> <property name="defaultValue">All</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="Cost Center" id="1580">
> <property name="valueType">dynamic</property>
> <text-property name="promptText">Select Cost
> Centre</text-property>
> <property name="isRequired">true</property>
> <property name="controlType">list-box</property>
> <property name="dataSetName">Cost Center</property>
> <expression
> name="valueExpr">row["COST_CENTRE"]</expression>
> <expression
> name="labelExpr">row["COST_CENTRE"]</expression>
> <property name="defaultValue">All</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> </cascading-parameter-group>
> </parameters>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Rec" id="1576">
> <property name="odaDriverClass"></property>
> <property name="odaURL"></property>
> <property name="odaUser"></property>
> <encrypted-property name="odaPassword">/encrypted-property>
> </oda-data-source>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="RecUAT"
> id="2039">
> <property name="odaDriverClass"></property>
> <property name="odaURL"></property>
> <property name="odaUser"></property>
> <encrypted-property name="odaPassword"></encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="FO_BO_GL" id="1481">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">COST_CENTRE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CCY</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">ACCOUNT</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">ACCOUNT_NAME</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">FO_MTM_SUM</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">BO_MTM_SUM</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">GL_MTM_SUM</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">FOBO_MTM_DIFF</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">BOGL_MTM_DIFF</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">FOGL_MTM_DIFF</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">RecUAT</property>
> <method name="beforeOpen"><![CDATA[this.queryText =
> this.queryText + " where AS_AT_DATE = '"+params['As At Date']+"' ";
>
> if(params['Currency'] != 'All'){
> this.queryText = this.queryText + " and CCY =
> '"+params['Currency'] + "' ";
> }
>
> //user wanna see all the cost centers present in STATIC_BOOK_MAPPING
> if(params['Cost Center'] == "All"){
>
> this.queryText = this.queryText + " and COST_CENTRE
> in ( "+
> " (select COST_CENTRE "+
> " from STATIC_BOOK_MAPPING "+
> " where BUSINESS_AREA = '"+params['Business Area'] + "' ";
>
> //if user want to see cost center irrespective of pl grouping
> //then do not include PL grouping in where clause else need to
> //include pl grouping in where clause
> if(params['Sophis Business'] != "All"){
> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
> '"+params['Sophis Business'] + "' ";
> }
>
> this.queryText = this.queryText + " ) UNION (SELECT distinct
> TREATS_CC as COST_CENTRE "+
> " FROM STATIC_BOOK_MAPPING where business_area =
> '"+params['Business Area'] + "' ";
>
> if(params['Sophis Business'] != "All"){
> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
> '"+params['Sophis Business'] + "' ";
> }
>
>
> this.queryText = this.queryText + " )) ";//end of in
>
> } else {//user has selected only one cost code
> this.queryText = this.queryText + " and COST_CENTRE =
> '"+params['Cost Center'] + "' ";
> }
>
>
> if(params['ReportFilters'] == "Exceptions Only"){
> //report fliter = exceptions only
> this.queryText = this.queryText + " AND
> (round(FOBO_MTM_DIFF,2) != 0"+
> " OR round(BOGL_MTM_DIFF,2) != 0"+
> " OR round(FOGL_MTM_DIFF,2) != 0 )";
> } else if(params['ReportFilters'] == "All Non Zeros"){
> //all records = all non zeros change on 19Mar2008
> //report fliter = All Non Zeros this.queryText =
> this.queryText + " AND (round(FO_MTM_SUM,2) != 0"+
> " OR round(BO_MTM_SUM,2) != 0"+
> " OR round(GL_MTM_SUM,2) != 0 )";
> }]]></method>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">COST_CENTRE</property>
> <property name="nativeName">COST_CENTRE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">CCY</property>
> <property name="nativeName">CCY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">ACCOUNT</property>
> <property name="nativeName">ACCOUNT</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">ACCOUNT_NAME</property>
> <property name="nativeName">ACCOUNT_NAME</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">FO_MTM_SUM</property>
> <property name="nativeName">FO_MTM_SUM</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">BO_MTM_SUM</property>
> <property name="nativeName">BO_MTM_SUM</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">GL_MTM_SUM</property>
> <property name="nativeName">GL_MTM_SUM</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">FOBO_MTM_DIFF</property>
> <property name="nativeName">FOBO_MTM_DIFF</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">BOGL_MTM_DIFF</property>
> <property name="nativeName">BOGL_MTM_DIFF</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">FOGL_MTM_DIFF</property>
> <property name="nativeName">FOGL_MTM_DIFF</property>
> <property name="dataType">decimal</property>
> <property name="nativeDataType">2</property>
> </structure>
> </list-property>
> <property name="queryText">select COST_CENTRE,
> CCY,
> ACCOUNT,
> ACCOUNT_NAME,
> round(FO_MTM_SUM,2) FO_MTM_SUM,
> round(BO_MTM_SUM,2) BO_MTM_SUM,
> round(GL_MTM_SUM,2) GL_MTM_SUM,
> round(FOBO_MTM_DIFF,2) FOBO_MTM_DIFF,
> round(BOGL_MTM_DIFF,2) BOGL_MTM_DIFF,
> round(FOGL_MTM_DIFF,2) FOGL_MTM_DIFF
> from REC_FO_BO_GL </property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="business_area" id="237">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">BUSINESS_AREA</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Rec</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">BUSINESS_AREA</property>
> <property name="nativeName">BUSINESS_AREA</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">select distinct
> PLR.STATIC_BOOK_MAPPING.BUSINESS_AREA
> from PLR.STATIC_BOOK_MAPPING
> order by PLR.STATIC_BOOK_MAPPING.BUSINESS_AREA</property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="PL Grouping" id="243">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">SOPHIS_BUSINESS</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Rec</property>
> <method name="beforeOpen"><![CDATA[if(params['Business Area']
> != ""){
> this.queryText = this.queryText + " where BUSINESS_AREA =
> '"+params['Business Area'] + "' ";
> }
>
> this.queryText = this.queryText + " order by SOPHIS_BUSINESS";]]></method>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">SOPHIS_BUSINESS</property>
> <property name="nativeName">SOPHIS_BUSINESS</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">select distinct SOPHIS_BUSINESS
> from STATIC_BOOK_MAPPING</property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="Cost Center" id="254">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">COST_CENTRE</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Rec</property>
> <method name="beforeOpen"><![CDATA[if(params['Business Area']
> != ""){
> this.queryText = this.queryText + " where BUSINESS_AREA =
> '"+params['Business Area'] + "' ";
> }
>
> //cost centres are retrieved from the table static_book_mapping
> //and its depends on the busines area and pl grouping selected
> //business area is a mandatory whereas use may select all from the pl
> grouping
> //in that case we need to ignore pl grouping in where clause
> if(params['Sophis Business'] != "All"){
> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
> '"+params['Sophis Business'] + "' ";
> }
>
> this.queryText = this.queryText + " union SELECT distinct TREATS_CC as
> COST_CENTRE "+
> "FROM STATIC_BOOK_MAPPING ";
>
> if(params['Business Area'] != ""){
> this.queryText = this.queryText + " where BUSINESS_AREA =
> '"+params['Business Area'] + "' ";
> }
>
> //cost centres are retrieved from the table static_book_mapping
> //and its depends on the busines area and pl grouping selected
> //business area is a mandatory whereas use may select all from the pl
> grouping
> //in that case we need to ignore pl grouping in where clause
> if(params['Sophis Business'] != "All"){
> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
> '"+params['Sophis Business'] + "' ";
> }
>
> //this.queryText = this.queryText + " order by COST_CENTRE";]]></method>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">COST_CENTRE</property>
> <property name="nativeName">COST_CENTRE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">select distinct COST_CENTRE from
> STATIC_BOOK_MAPPING
> </property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="AsAtDate" id="1641">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">AS_AT_DATE</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">AS_AT_DATE1</property>
> <property name="dataType">date-time</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">RecUAT</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">AS_AT_DATE</property>
> <property name="nativeName">AS_AT_DATE</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">AS_AT_DATE1</property>
> <property name="nativeName">AS_AT_DATE1</property>
> <property name="dataType">date-time</property>
> <property name="nativeDataType">93</property>
> </structure>
> </list-property>
> <property name="queryText">select distinct
> (TO_CHAR(as_at_date , 'dd MON yyyy') )
> as_at_date, as_at_date as_at_date1
> from REC_FO_BO_GL
> order by as_at_date1 desc</property>
> </oda-data-set>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
> name="ccy Currency" id="2041">
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">CURRENCY</property>
> <property name="dataType">string</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">RecUAT</property>
> <method name="beforeOpen"><![CDATA[if(params['As At Date'] !=
> ""){
> this.queryText = this.queryText + " where AS_AT_DATE = '"+params['As
> At Date'] + "' ";
> }
>
> this.queryText = this.queryText + " order by CCY";]]></method>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">CURRENCY</property>
> <property name="nativeName">CURRENCY</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> </list-property>
> <property name="queryText">select distinct( CCY) as currency
> from REC_FO_BO_GL </property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="crosstab" id="4">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab-cell" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="type">custom</property>
> <property name="height">20cm</property>
> <property name="width">40cm</property>
> <page-footer>
> <text id="3">
> <property name="fontSize">8pt</property>
> <property name="textAlign">left</property>
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[Print Date :
> <value-of>new Date()</value-of>]]></text-property>
> </text>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <text id="1003">
> <property name="style">REPORT-TITLE</property>
> <property name="fontFamily">"Verdana"</property>
> <property name="fontSize">10pt</property>
> <property name="fontWeight">bold</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomWidth">thin</property>
> <property name="marginTop">0pt</property>
> <property name="marginBottom">10pt</property>
> <property name="textAlign">left</property>
> <property name="textIndent">0em</property>
> <property name="verticalAlign">top</property>
> <property name="contentType">auto</property>
> <text-property name="content"><![CDATA[FO-BO-GL
> Reconciliation Market Value Report]]></text-property>
> </text>
> <table id="974">
> <property name="backgroundColor">#FFFFFF</property>
> <property name="marginTop">10pt</property>
> <property name="marginLeft">0pt</property>
> <property name="marginBottom">0pt</property>
> <property name="marginRight">0pt</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">0pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="paddingRight">0pt</property>
> <property name="textAlign">center</property>
> <property name="showIfBlank">true</property>
> <property name="canShrink">true</property>
> <property name="width">65%</property>
> <column id="1063">
> <property name="width">1.2395833333in</property>
> <property name="fontSize">8pt</property>
> <property name="color">#008080</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">2pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="paddingRight">0pt</property>
> </column>
> <column id="1064">
> <property name="width">1.448in</property>
> <property name="style">DATA-ROW1</property>
> <property name="paddingLeft">2px</property>
> </column>
> <column id="1065">
> <property name="width">0.5%</property>
> <property name="backgroundColor">#FFFFFF</property>
> <property name="fontSize">8pt</property>
> <property name="color">#008080</property>
> </column>
> <column id="1066">
> <property name="width">1.24in</property>
> <property name="fontSize">8pt</property>
> <property name="color">#008080</property>
> <property name="paddingTop">0pt</property>
> <property name="paddingLeft">2pt</property>
> <property name="paddingBottom">0pt</property>
> <property name="paddingRight">0pt</property>
> </column>
> <column id="1067">
> <property name="width">1.448in</property>
> <property name="style">DATA-ROW1</property>
> <property name="paddingLeft">2px</property>
> </column>
> <detail>
> <row id="975">
> <cell id="976">
> <property name="style">DARK-BACKGROUND</property>
> <label id="1354">
> <property
> name="style">DARK-BACKGROUND</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000000</property>
> <property name="textAlign">left</property>
> <text-property name="text">As At Date
> :</text-property>
> </label>
> </cell>
> <cell id="978">
> <property name="style">DARK-BACKGROUND</property>
> <data id="1501">
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">As At
> Date</property>
> <expression
> name="expression">params["As At Date"]</expression>
> </structure>
> </list-property>
> <property name="resultSetColumn">As At
> Date</property>
> </data>
> </cell>
> <cell id="1053"/>
> <cell id="1054">
> <property name="style">DARK-BACKGROUND</property>
> <label id="1055">
> <property
> name="style">DARK-BACKGROUND</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000000</property>
> <property name="textAlign">left</property>
> <text-property name="text">Business Area
> :</text-property>
> </label>
> </cell>
> <cell id="1056">
> <property name="style">DARK-BACKGROUND</property>
> <data id="1484">
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">Business
> Area</property>
> <expression
> name="expression">params["Business Area"]</expression>
> </structure>
> </list-property>
> <property name="resultSetColumn">Business
> Area</property>
> </data>
> </cell>
> </row>
> <row id="1057">
> <cell id="1058">
> <property name="backgroundColor">#FFFFFF</property>
> </cell>
> <cell id="1059">
> <property name="backgroundColor">#FFFFFF</property>
> </cell>
> <cell id="1060">
> <property name="backgroundColor">#FFFFFF</property>
> </cell>
> <cell id="1061">
> <property name="backgroundColor">#FFFFFF</property>
> </cell>
> <cell id="1062">
> <property name="backgroundColor">#FFFFFF</property>
> </cell>
> </row>
> <row id="1039">
> <property name="style">LIGHT-BACKGROUND</property>
> <cell id="1040">
> <label id="1045">
> <property
> name="style">LIGHT-BACKGROUND</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000000</property>
> <property name="textAlign">left</property>
> <text-property name="text">PL Grouping
> :</text-property>
> </label>
> </cell>
> <cell id="1041">
> <data id="1618">
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">Sophis
> Business</property>
> <expression
> name="expression">params["Sophis Business"]</expression>
> </structure>
> </list-property>
> <property name="resultSetColumn">Sophis
> Business</property>
> </data>
> </cell>
> <cell id="1042"/>
> <cell id="1043">
> <label id="1046">
> <property
> name="style">LIGHT-BACKGROUND</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000000</property>
> <property name="textAlign">left</property>
> <text-property name="text">Cost centre
> :</text-property>
> </label>
> </cell>
> <cell id="1044">
> <data id="1581">
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">Cost
> Center</property>
> <expression
> name="expression">params["Cost Center"]</expression>
> </structure>
> </list-property>
> <property name="resultSetColumn">Cost
> Center</property>
> </data>
> </cell>
> </row>
> <row id="1619">
> <cell id="1620"/>
> <cell id="1621"/>
> <cell id="1622"/>
> <cell id="1623"/>
> <cell id="1624"/>
> </row>
> <row id="1625">
> <property name="style">DARK-BACKGROUND</property>
> <cell id="1626">
> <label id="1588">
> <property
> name="style">DARK-BACKGROUND</property>
> <property name="fontWeight">bold</property>
> <property name="color">#000000</property>
> <property name="textAlign">left</property>
> <text-property name="text">Report Filter
> :</text-property>
> </label>
> </cell>
> <cell id="1627">
> <data id="1617">
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">ReportFilters</property>
> <expression
> name="expression">if(params["ReportFilters"]=='All Non Zeros'){
> 'All Records'
> } else {
> params["ReportFilters"]
> }</expression>
> <property name="dataType">any</property>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">ReportFilters</property>
> </data>
> </cell>
> <cell id="1628"/>
> <cell id="1629">
> <label id="2059">
> <property name="fontWeight">bold</property>
> <property name="color">#000000</property>
> <property name="textAlign">left</property>
> <text-property name="text">Currency
> :</text-property>
> </label>
> </cell>
> <cell id="1630">
> <data id="2072">
> <list-property name="boundDataColumns">
> <structure>
> <property
> name="name">Currency</property>
> <expression
> name="expression">params["Currency"]</expression>
> </structure>
> </list-property>
> <property
> name="resultSetColumn">Currency</property>
> </data>
> </cell>
> </row>
> </detail>
> </table>
> <table id="1359">
> <property name="borderBottomColor">#F7F7F7</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#F7F7F7</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#F7F7F7</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#F7F7F7</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="marginTop">20pt</property>
> <property name="height">1.2604166667in</property>
> <property name="width">95%</property>
> <property name="dataSet">FO_BO_GL</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">COST_CENTRE</property>
> <expression
> name="expression">if(dataSetRow["COST_CENTRE"] == ' ' ||
> dataSetRow["COST_CENTRE"] == null){
> 'No Cost Centre';
> } else {
> dataSetRow["COST_CENTRE"] ;
> }</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">CCY</property>
> <expression name="expression">if(dataSetRow["CCY"] ==
> ' ' || dataSetRow["CCY"] == null){
> 'No Currency';
> } else {
> dataSetRow["CCY"] }</expression>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="name">ACCOUNT</property>
> <expression
> name="expression">if(dataSetRow["ACCOUNT"] =

_
Nitin Dahyabhai
Eclipse Web Tools Platform

Report message to a moderator

Re: Problem with the Export Data options from the BIRT - toolbar [message #210790 is a reply to message #210692]

Mon, 24 March 2008 16:17

Eclipse User

Originally posted by: jasonweathersby.alltel.net

The columns shown in the export list are all the columns listed under
the binding tab. If the columns are not used, remove them from the
binding and they will not show up in the export.

Jason

Nitin Dahyabhai wrote:
> Seema, I think this is best asked in the BIRT newsgroup.
>
> Seema wrote:
>> Hello,
>>
>> I need help for the following issue as soon as possible, as our appl
>> users are facing lot many problems.
>>
>> When I click on the 'Export Data' option from the BIRT-Web Viewer's
>> toolbar,
>> It displays some unwanted columns in 'Available Column' list.
>>
>> Name of the unwanted columns are like.. Total_Column_5, Total_column_6...
>>
>> Here is the XML Source of My report design:
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <report xmlns="http://www.eclipse.org/birt/2005/design"
>> version="3.2.14" id="1">
>> <property name="createdBy">Eclipse BIRT Designer Version
>> 2.2.0.v20070620 Build <2.2.0.v20070626-1003></property>
>> <property name="units">in</property>
>> <text-property name="title"></text-property>
>> <property name="comments">Copyright (c) 2007 <<Your Company
>> Name here>></property>
>> <html-property name="description">Creates a blank report with no
>> predefined content.</html-property>
>> <text-property name="displayName">Blank Report</text-property>
>> <property name="iconFile">/templates/blank_report.gif</property>
>> <list-property name="cssStyleSheets">
>> <structure>
>> <property name="fileName"></property>
>> </structure>
>> </list-property>
>> <parameters>
>> <scalar-parameter name="ReportFilters" id="1582">
>> <property name="valueType">static</property>
>> <property name="dataType">string</property>
>> <text-property name="promptText">Select Report
>> Filter</text-property>
>> <property name="controlType">list-box</property>
>> <property name="mustMatch">true</property>
>> <property name="fixedOrder">false</property>
>> <property name="defaultValue">All Non Zeros</property>
>> <property name="distinct">false</property>
>> <property name="sortBy">label</property>
>> <property name="sortDirection">asc</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> <list-property name="selectionList">
>> <structure>
>> <property name="value">Exceptions Only</property>
>> <property name="label">Exceptions Only</property>
>> </structure>
>> <structure>
>> <property name="value">All Non Zeros</property>
>> <property name="label">All Records</property>
>> </structure>
>> </list-property>
>> </scalar-parameter>
>> <cascading-parameter-group name="AsAtDateCurrency" id="2082">
>> <property name="promptText">Select As At Date and then
>> Currency</property>
>> <property name="dataSetMode">multiple</property>
>> <parameters>
>> <scalar-parameter name="As At Date" id="2083">
>> <property name="valueType">dynamic</property>
>> <property name="dataType">string</property>
>> <text-property name="promptText">Select As At
>> Date</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">list-box</property>
>> <property name="dataSetName">AsAtDate</property>
>> <expression
>> name="valueExpr">row["AS_AT_DATE"]</expression>
>> <expression
>> name="labelExpr">row["AS_AT_DATE"]</expression>
>> <property name="defaultValue"></property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="Currency" id="2084">
>> <property name="valueType">dynamic</property>
>> <text-property name="promptText">Select
>> Currency</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">list-box</property>
>> <property name="dataSetName">ccy Currency</property>
>> <expression
>> name="valueExpr">row["CURRENCY"]</expression>
>> <expression
>> name="labelExpr">row["CURRENCY"]</expression>
>> <property name="defaultValue">All</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> </parameters>
>> </cascading-parameter-group>
>> <cascading-parameter-group name="BusinessAreaPLGrouping" id="250">
>> <property name="promptText">Select Business Area and PL
>> Grouping and then Cost Centre</property>
>> <property name="dataSetMode">multiple</property>
>> <parameters>
>> <scalar-parameter name="Business Area" id="251">
>> <property name="valueType">dynamic</property>
>> <property name="dataType">string</property>
>> <text-property name="promptText">Select Business
>> Area</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">list-box</property>
>> <property name="dataSetName">business_area</property>
>> <expression
>> name="valueExpr">row["BUSINESS_AREA"]</expression>
>> <expression
>> name="labelExpr">row["BUSINESS_AREA"]</expression>
>> <property name="defaultValue"></property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="Sophis Business" id="252">
>> <property name="valueType">dynamic</property>
>> <text-property name="promptText">Select PL
>> Grouping</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">list-box</property>
>> <property name="dataSetName">PL Grouping</property>
>> <expression
>> name="valueExpr">row["SOPHIS_BUSINESS"]</expression>
>> <expression
>> name="labelExpr">row["SOPHIS_BUSINESS"]</expression>
>> <property name="defaultValue">All</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> <scalar-parameter name="Cost Center" id="1580">
>> <property name="valueType">dynamic</property>
>> <text-property name="promptText">Select Cost
>> Centre</text-property>
>> <property name="isRequired">true</property>
>> <property name="controlType">list-box</property>
>> <property name="dataSetName">Cost Center</property>
>> <expression
>> name="valueExpr">row["COST_CENTRE"]</expression>
>> <expression
>> name="labelExpr">row["COST_CENTRE"]</expression>
>> <property name="defaultValue">All</property>
>> <structure name="format">
>> <property name="category">Unformatted</property>
>> </structure>
>> </scalar-parameter>
>> </parameters>
>> </cascading-parameter-group>
>> </parameters>
>> <data-sources>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Rec" id="1576">
>> <property name="odaDriverClass"></property>
>> <property name="odaURL"></property>
>> <property name="odaUser"></property>
>> <encrypted-property name="odaPassword">/encrypted-property>
>> </oda-data-source>
>> <oda-data-source
>> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="RecUAT"
>> id="2039">
>> <property name="odaDriverClass"></property>
>> <property name="odaURL"></property>
>> <property name="odaUser"></property>
>> <encrypted-property name="odaPassword"></encrypted-property>
>> </oda-data-source>
>> </data-sources>
>> <data-sets>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="FO_BO_GL" id="1481">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">COST_CENTRE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">CCY</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">ACCOUNT</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">ACCOUNT_NAME</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">FO_MTM_SUM</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">BO_MTM_SUM</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">GL_MTM_SUM</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">8</property>
>> <property name="name">FOBO_MTM_DIFF</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">9</property>
>> <property name="name">BOGL_MTM_DIFF</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> <structure>
>> <property name="position">10</property>
>> <property name="name">FOGL_MTM_DIFF</property>
>> <property name="dataType">decimal</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">RecUAT</property>
>> <method name="beforeOpen"><![CDATA[this.queryText =
>> this.queryText + " where AS_AT_DATE = '"+params['As At Date']+"' ";
>> if(params['Currency'] != 'All'){
>> this.queryText = this.queryText + " and CCY =
>> '"+params['Currency'] + "' ";
>> }
>> //user wanna see all the cost centers present in
>> STATIC_BOOK_MAPPING if(params['Cost Center'] == "All"){
>> this.queryText = this.queryText + " and
>> COST_CENTRE in ( "+
>> " (select COST_CENTRE "+
>> " from STATIC_BOOK_MAPPING "+
>> " where BUSINESS_AREA = '"+params['Business Area'] + "' ";
>> //if user want to see cost center irrespective of pl grouping
>> //then do not include PL grouping in where clause else need to
>> //include pl grouping in where clause
>> if(params['Sophis Business'] != "All"){
>> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
>> '"+params['Sophis Business'] + "' ";
>> }
>> this.queryText = this.queryText + " ) UNION (SELECT
>> distinct TREATS_CC as COST_CENTRE "+
>> " FROM STATIC_BOOK_MAPPING where business_area =
>> '"+params['Business Area'] + "' ";
>> if(params['Sophis Business'] != "All"){
>> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
>> '"+params['Sophis Business'] + "' ";
>> }
>> this.queryText = this.queryText + " )) ";//end
>> of in
>> } else {//user has selected only one cost code
>> this.queryText = this.queryText + " and COST_CENTRE =
>> '"+params['Cost Center'] + "' ";
>> }
>> if(params['ReportFilters'] == "Exceptions Only"){
>> //report fliter = exceptions only
>> this.queryText = this.queryText + " AND
>> (round(FOBO_MTM_DIFF,2) != 0"+
>> " OR round(BOGL_MTM_DIFF,2) != 0"+
>> " OR round(FOGL_MTM_DIFF,2) != 0 )";
>> } else if(params['ReportFilters'] == "All Non Zeros"){
>> //all records = all non zeros change on 19Mar2008
>> //report fliter = All Non Zeros this.queryText =
>> this.queryText + " AND (round(FO_MTM_SUM,2) != 0"+
>> " OR round(BO_MTM_SUM,2) != 0"+
>> " OR round(GL_MTM_SUM,2) != 0 )";
>> }]]></method>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">COST_CENTRE</property>
>> <property name="nativeName">COST_CENTRE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">CCY</property>
>> <property name="nativeName">CCY</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">3</property>
>> <property name="name">ACCOUNT</property>
>> <property name="nativeName">ACCOUNT</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">4</property>
>> <property name="name">ACCOUNT_NAME</property>
>> <property name="nativeName">ACCOUNT_NAME</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">5</property>
>> <property name="name">FO_MTM_SUM</property>
>> <property name="nativeName">FO_MTM_SUM</property>
>> <property name="dataType">decimal</property>
>> <property name="nativeDataType">2</property>
>> </structure>
>> <structure>
>> <property name="position">6</property>
>> <property name="name">BO_MTM_SUM</property>
>> <property name="nativeName">BO_MTM_SUM</property>
>> <property name="dataType">decimal</property>
>> <property name="nativeDataType">2</property>
>> </structure>
>> <structure>
>> <property name="position">7</property>
>> <property name="name">GL_MTM_SUM</property>
>> <property name="nativeName">GL_MTM_SUM</property>
>> <property name="dataType">decimal</property>
>> <property name="nativeDataType">2</property>
>> </structure>
>> <structure>
>> <property name="position">8</property>
>> <property name="name">FOBO_MTM_DIFF</property>
>> <property name="nativeName">FOBO_MTM_DIFF</property>
>> <property name="dataType">decimal</property>
>> <property name="nativeDataType">2</property>
>> </structure>
>> <structure>
>> <property name="position">9</property>
>> <property name="name">BOGL_MTM_DIFF</property>
>> <property name="nativeName">BOGL_MTM_DIFF</property>
>> <property name="dataType">decimal</property>
>> <property name="nativeDataType">2</property>
>> </structure>
>> <structure>
>> <property name="position">10</property>
>> <property name="name">FOGL_MTM_DIFF</property>
>> <property name="nativeName">FOGL_MTM_DIFF</property>
>> <property name="dataType">decimal</property>
>> <property name="nativeDataType">2</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select COST_CENTRE,
>> CCY,
>> ACCOUNT,
>> ACCOUNT_NAME,
>> round(FO_MTM_SUM,2) FO_MTM_SUM,
>> round(BO_MTM_SUM,2) BO_MTM_SUM,
>> round(GL_MTM_SUM,2) GL_MTM_SUM,
>> round(FOBO_MTM_DIFF,2) FOBO_MTM_DIFF,
>> round(BOGL_MTM_DIFF,2) BOGL_MTM_DIFF,
>> round(FOGL_MTM_DIFF,2) FOGL_MTM_DIFF
>> from REC_FO_BO_GL </property>
>> </oda-data-set>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="business_area" id="237">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">BUSINESS_AREA</property>
>> <property name="dataType">string</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Rec</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">BUSINESS_AREA</property>
>> <property name="nativeName">BUSINESS_AREA</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select distinct
>> PLR.STATIC_BOOK_MAPPING.BUSINESS_AREA
>> from PLR.STATIC_BOOK_MAPPING
>> order by PLR.STATIC_BOOK_MAPPING.BUSINESS_AREA</property>
>> </oda-data-set>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="PL Grouping" id="243">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">SOPHIS_BUSINESS</property>
>> <property name="dataType">string</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Rec</property>
>> <method name="beforeOpen"><![CDATA[if(params['Business
>> Area'] != ""){
>> this.queryText = this.queryText + " where BUSINESS_AREA =
>> '"+params['Business Area'] + "' ";
>> }
>>
>> this.queryText = this.queryText + " order by
>> SOPHIS_BUSINESS";]]></method>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">SOPHIS_BUSINESS</property>
>> <property name="nativeName">SOPHIS_BUSINESS</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select distinct SOPHIS_BUSINESS
>> from STATIC_BOOK_MAPPING</property>
>> </oda-data-set>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="Cost Center" id="254">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">COST_CENTRE</property>
>> <property name="dataType">string</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">Rec</property>
>> <method name="beforeOpen"><![CDATA[if(params['Business
>> Area'] != ""){
>> this.queryText = this.queryText + " where BUSINESS_AREA =
>> '"+params['Business Area'] + "' ";
>> }
>>
>> //cost centres are retrieved from the table static_book_mapping
>> //and its depends on the busines area and pl grouping selected
>> //business area is a mandatory whereas use may select all from the pl
>> grouping
>> //in that case we need to ignore pl grouping in where clause
>> if(params['Sophis Business'] != "All"){
>> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
>> '"+params['Sophis Business'] + "' ";
>> }
>>
>> this.queryText = this.queryText + " union SELECT distinct TREATS_CC as
>> COST_CENTRE "+
>> "FROM STATIC_BOOK_MAPPING ";
>>
>> if(params['Business Area'] != ""){
>> this.queryText = this.queryText + " where BUSINESS_AREA =
>> '"+params['Business Area'] + "' ";
>> }
>>
>> //cost centres are retrieved from the table static_book_mapping
>> //and its depends on the busines area and pl grouping selected
>> //business area is a mandatory whereas use may select all from the pl
>> grouping
>> //in that case we need to ignore pl grouping in where clause
>> if(params['Sophis Business'] != "All"){
>> this.queryText = this.queryText + " and SOPHIS_BUSINESS =
>> '"+params['Sophis Business'] + "' ";
>> }
>>
>> //this.queryText = this.queryText + " order by COST_CENTRE";]]></method>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">COST_CENTRE</property>
>> <property name="nativeName">COST_CENTRE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select distinct COST_CENTRE from
>> STATIC_BOOK_MAPPING
>> </property>
>> </oda-data-set>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="AsAtDate" id="1641">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">AS_AT_DATE</property>
>> <property name="dataType">string</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">AS_AT_DATE1</property>
>> <property name="dataType">date-time</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">RecUAT</property>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">AS_AT_DATE</property>
>> <property name="nativeName">AS_AT_DATE</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> <structure>
>> <property name="position">2</property>
>> <property name="name">AS_AT_DATE1</property>
>> <property name="nativeName">AS_AT_DATE1</property>
>> <property name="dataType">date-time</property>
>> <property name="nativeDataType">93</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select distinct
>> (TO_CHAR(as_at_date , 'dd MON yyyy') )
>> as_at_date, as_at_date as_at_date1
>> from REC_FO_BO_GL
>> order by as_at_date1 desc</property>
>> </oda-data-set>
>> <oda-data-set
>> extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet "
>> name="ccy Currency" id="2041">
>> <structure name="cachedMetaData">
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">CURRENCY</property>
>> <property name="dataType">string</property>
>> </structure>
>> </list-property>
>> </structure>
>> <property name="dataSource">RecUAT</property>
>> <method name="beforeOpen"><![CDATA[if(params['As At Date']
>> != ""){
>> this.queryText = this.queryText + " where AS_AT_DATE =
>> '"+params['As At Date'] + "' ";
>> }
>>
>> this.queryText = this.queryText + " order by CCY";]]></method>
>> <list-property name="resultSet">
>> <structure>
>> <property name="position">1</property>
>> <property name="name">CURRENCY</property>
>> <property name="nativeName">CURRENCY</property>
>> <property name="dataType">string</property>
>> <property name="nativeDataType">12</property>
>> </structure>
>> </list-property>
>> <property name="queryText">select distinct( CCY) as currency
>> from REC_FO_BO_GL </property>
>> </oda-data-set>
>> </data-sets>
>> <styles>
>> <style name="crosstab" id="4">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> <style name="crosstab-cell" id="5">
>> <property name="borderBottomColor">#CCCCCC</property>
>> <property name="borderBottomStyle">solid</property>
>> <property name="borderBottomWidth">1pt</property>
>> <property name="borderLeftColor">#CCCCCC</property>
>> <property name="borderLeftStyle">solid</property>
>> <property name="borderLeftWidth">1pt</property>
>> <property name="borderRightColor">#CCCCCC</property>
>> <property name="borderRightStyle">solid</property>
>> <property name="borderRightWidth">1pt</property>
>> <property name="borderTopColor">#CCCCCC</property>
>> <property name="borderTopStyle">solid</property>
>> <property name="borderTopWidth">1pt</property>
>> </style>
>> </styles>
>> <page-setup>
>> <simple-master-page name="Simple MasterPage" id="2">
>> <property name="type">custom</property>
>> <property name="height">20cm</property>
>> <property name="width">40cm</property>
>> <page-footer>
>> <text id="3">
>> <property name="fontSize">8pt</property>
>> <property name="textAlign">left</property>
>> <property name="contentType">html</property>
>> <text-property name="content"><![CDATA[Print Date :
>> <value-of>new Date()</value-of>]]></text-property>
>> </text>
>> </page-footer>
>> </simple-master-page>
>> </page-setup>
>> <body>
>> <text id="1003">
>> <property name="style">REPORT-TITLE</property>
>> <property name="fontFamily">"Verdana"</property>
>> <property name="fontSize">10pt</property>
>> <property name="fontWeight">bold</property>
>> <property name="borderBottomColor">#000000</property>
>> <property name="borderBottomWidth">thin</property>
>> <property name="marginTop">0pt</property>
>> <property name="marginBottom">10pt</property>
>> <property name="textAlign">left</property>
>> <property name="textIndent">0em</property>
>> <property name="verticalAlign">top</property>
>> <property name="contentType">auto</property>
>> <text-property name="content"><![CDATA[FO-BO-GL
>> Reconciliation Market Value Report]]></text-property>
>> </text>
>> <table id="974">
>> <property name="backgroundColor">#FFFFFF</property>
>> <property name="marginTop">10pt</property>
>> <property name="marginLeft">0pt</property>
>> <property name="marginBottom">0pt</property>
>> <property name="marginRight">0pt</property>
>> <property name="paddingTop">0pt</property>
>> <property name="paddingLeft">0pt</property>
>> <property name="paddingBottom">0pt</property>
>> <property name="paddingRight">0pt</property>
>> <property name="textAlign">center</property>
>> <property name="showIfBlank">true</property>
>> <property name="canShrink">true</property>
>> <property name="width">65%</property>
>> <column id="1063">
>> <property name="width">1.2395833333in</property>
>> <property name="fontSize">8pt</property>
>> <property name="color">#008080</property>
>> <property name="paddingTop">0pt</property>
>> <property name="paddingLeft">2pt</property>
>> <property name="paddingBottom">0pt</property>
>> <property name="paddingRight">0pt</property>
>> </column>
>> <column id="1064">
>> <property name="width">1.448in</property>
>> <property name="style">DATA-ROW1</property>
>> <property name="paddingLeft">2px</property>
>> </column>
>> <column id="1065">
>> <property name="width">0.5%</property>
>> <property name="backgroundColor">#FFFFFF</property>
>> <property name="fontSize">8pt</property>
>> <property name="color">#008080</property>
>> </column>
>> <column id="1066">
>> <property name="width">1.24in</property>
>> <property name="fontSize">8pt</property>
>> <property name="color">#008080</property>
>> <property name="paddingTop">0pt</property>
>> <property name="paddingLeft">2pt</property>
>> <property name="paddingBottom">0pt</property>
>> <property name="paddingRight">0pt</property>
>> </column>
>> <column id="1067">
>> <property name="width">1.448in</property>
>> <property name="style">DATA-ROW1</property>
>> <property name="paddingLeft">2px</property>
>> </column>
>> <detail>
>> <row id="975">
>> <cell id="976">
>> <property name="style">DARK-BACKGROUND</property>
>> <label id="1354">
>> <property
>> name="style">DARK-BACKGROUND</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#000000</property>
>> <property name="textAlign">left</property>
>> <text-property name="text">As At Date
>> :</text-property>
>> </label>
>> </cell>
>> <cell id="978">
>> <property name="style">DARK-BACKGROUND</property>
>> <data id="1501">
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">As At
>> Date</property>
>> <expression
>> name="expression">params["As At Date"]</expression>
>> </structure>
>> </list-property>
>> <property name="resultSetColumn">As At
>> Date</property>
>> </data>
>> </cell>
>> <cell id="1053"/>
>> <cell id="1054">
>> <property name="style">DARK-BACKGROUND</property>
>> <label id="1055">
>> <property
>> name="style">DARK-BACKGROUND</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#000000</property>
>> <property name="textAlign">left</property>
>> <text-property name="text">Business Area
>> :</text-property>
>> </label>
>> </cell>
>> <cell id="1056">
>> <property name="style">DARK-BACKGROUND</property>
>> <data id="1484">
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">Business
>> Area</property>
>> <expression
>> name="expression">params["Business Area"]</expression>
>> </structure>
>> </list-property>
>> <property name="resultSetColumn">Business
>> Area</property>
>> </data>
>> </cell>
>> </row>
>> <row id="1057">
>> <cell id="1058">
>> <property
>> name="backgroundColor">#FFFFFF</property>
>> </cell>
>> <cell id="1059">
>> <property
>> name="backgroundColor">#FFFFFF</property>
>> </cell>
>> <cell id="1060">
>> <property
>> name="backgroundColor">#FFFFFF</property>
>> </cell>
>> <cell id="1061">
>> <property
>> name="backgroundColor">#FFFFFF</property>
>> </cell>
>> <cell id="1062">
>> <property
>> name="backgroundColor">#FFFFFF</property>
>> </cell>
>> </row>
>> <row id="1039">
>> <property name="style">LIGHT-BACKGROUND</property>
>> <cell id="1040">
>> <label id="1045">
>> <property
>> name="style">LIGHT-BACKGROUND</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#000000</property>
>> <property name="textAlign">left</property>
>> <text-property name="text">PL Grouping
>> :</text-property>
>> </label>
>> </cell>
>> <cell id="1041">
>> <data id="1618">
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">Sophis
>> Business</property>
>> <expression
>> name="expression">params["Sophis Business"]</expression>
>> </structure>
>> </list-property>
>> <property name="resultSetColumn">Sophis
>> Business</property>
>> </data>
>> </cell>
>> <cell id="1042"/>
>> <cell id="1043">
>> <label id="1046">
>> <property
>> name="style">LIGHT-BACKGROUND</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#000000</property>
>> <property name="textAlign">left</property>
>> <text-property name="text">Cost centre
>> :</text-property>
>> </label>
>> </cell>
>> <cell id="1044">
>> <data id="1581">
>> <list-property name="boundDataColumns">
>> <structure>
>> <property name="name">Cost
>> Center</property>
>> <expression
>> name="expression">params["Cost Center"]</expression>
>> </structure>
>> </list-property>
>> <property name="resultSetColumn">Cost
>> Center</property>
>> </data>
>> </cell>
>> </row>
>> <row id="1619">
>> <cell id="1620"/>
>> <cell id="1621"/>
>> <cell id="1622"/>
>> <cell id="1623"/>
>> <cell id="1624"/>
>> </row>
>> <row id="1625">
>> <property name="style">DARK-BACKGROUND</property>
>> <cell id="1626">
>> <label id="1588">
>> <property
>> name="style">DARK-BACKGROUND</property>
>> <property name="fontWeight">bold</property>
>> <property name="color">#000000</property>
>> <property name="textAlign">left</property>
>> <text-property name="text">Report Filter
>> :</text-property>
>> </label>
>> </cell>
>> <cell id="1627">
>> <data id="1617">
>> <list-property name="boundDataColumns">
>> <structure>
>> <property
>> name="name">ReportFilters</property>
>> <expression
>> name="expression">if(params["ReportFilters"]=='All Non Zeros'){
>> 'All Records'
>> } else {
>> params["ReportFilters"]
>> }</expression>
>> <property
>> name="dataType">any</property>
>> </structure>
>> </list-property>
>> <property
>> name="resultSetColumn">ReportFilters</property>
>> </data>
>> </cell>
>> <cell id="1628"/>
>> <cell id="1629">
>> <label id="2059">
>> <property name="fontWeight">bold</property>
>> <property name="color">#000000</property>
>> <property name="textAlign">left</property>
>> <text-property name="text">Currency
>> :</text-property>
>> </label>
>> </cell>
>> <cell id="1630">
>> <data id="2072">
>> <list-property name="boundDataColumns">
>> <structure>
>> <property
>> name=&qu

Report message to a moderator

Re: Problem with the Export Data options from the BIRT - toolbar [message #211027 is a reply to message #210790]

Wed, 26 March 2008 09:22

Eclipse User

Originally posted by: seemakhopade.hsbc.co.in

No Jason, I am getting some extra columns other than the columns which are
under binding tab.

Nitin: I would like to know, why this is the best question ?

Report message to a moderator

Re: Problem with the Export Data options from the BIRT - toolbar [message #211084 is a reply to message #211027]

Wed, 26 March 2008 14:20

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Seema,

What version of BIRT are you using? I believe this has to do with the
conditional grouping you have on the nested group. I have tried it in
BIRT 2.2.1 and can not reproduce the issue.

Jason

Seema wrote:
> No Jason, I am getting some extra columns other than the columns which
> are under binding tab.
> Nitin: I would like to know, why this is the best question ?
>
>

Report message to a moderator

Re: Problem with the Export Data options from the BIRT - toolbar [message #211091 is a reply to message #211084]

Wed, 26 March 2008 15:07

Eclipse User

Originally posted by: seemakhopade.hsbc.co.in

Thanks for the prompt response.

I am using birt-report-designer-all-in-one-2_2_0

Report message to a moderator

Re: Problem with the Export Data options from the BIRT - toolbar [message #211110 is a reply to message #211091]

Wed, 26 March 2008 15:34

Eclipse User

Originally posted by: seemakhopade.hsbc.co.in

I have also tested my report with BIRT 2.2.2 , its running fine.
However with BIRT 2.2.0 , report is displaying extra columns.

So can we resolve this using BIRT 2.2.0, as we cannot use BIRT 2.2.2 .

Report message to a moderator

Re: Problem with the Export Data options from the BIRT - toolbar [message #211134 is a reply to message #211110]

Wed, 26 March 2008 16:16

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Seema,

As a work around for this version you could modify the
BirtSimpleExportDataDialog.js file in the ajax directory of the viewer.
in the __bind method the dialog is loaded with the names.
I modified it to add an alert of the column names
columnName[0].firstChild.data. You could put an if statement where it
is added to the availableResultSets[k] to verify that it does not
contain Total_Column.

for ( var k = 0; k < resultSets.length; k++ )
{
var resultSet = resultSets[k];

var queryNames = resultSet.getElementsByTagName( 'QueryName' );
oSelects[0].options.add( new Option( queryNames[0].firstChild.data ) );

this.availableResultSets[k] = {};

var columns = resultSet.getElementsByTagName( 'Column' );
for( var i = 0; i < columns.length; i++ )
{
var column = columns[i];

var columnName = column.getElementsByTagName( 'Name' );
alert(columnName[0].firstChild.data);
var label = column.getElementsByTagName( 'Label' );
this.availableResultSets[k][label[0].firstChild.data] =
columnName[0].firstChild.data;
}
}

Jason

Seema wrote:
> I have also tested my report with BIRT 2.2.2 , its running fine.
> However with BIRT 2.2.0 , report is displaying extra columns.
>
> So can we resolve this using BIRT 2.2.0, as we cannot use BIRT 2.2.2 .
>

Report message to a moderator