Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Web Tools Project (WTP) » Problem with the Export Data options from the BIRT - toolbar
Problem with the Export Data options from the BIRT - toolbar [message #210673] Thu, 20 March 2008 16:48 Go to next message
Eclipse UserFriend
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 &lt;2.2.0.v20070626-1003></property>
<property name="units">in</property>
<text-property name="title"></text-property>
<property name="comments">Copyright (c) 2007 &lt;&lt;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
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 Go to previous messageGo to next message
Nitin Dahyabhai is currently offline Nitin DahyabhaiFriend
Messages: 2341
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 &lt;2.2.0.v20070626-1003></property>
> <property name="units">in</property>
> <text-property name="title"></text-property>
> <property name="comments">Copyright (c) 2007 &lt;&lt;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 WTP, IBM
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 Go to previous messageGo to next message
Eclipse UserFriend
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 &lt;2.2.0.v20070626-1003></property>
>> <property name="units">in</property>
>> <text-property name="title"></text-property>
>> <property name="comments">Copyright (c) 2007 &lt;&lt;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
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 Go to previous messageGo to next message
Eclipse UserFriend
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 ?
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 Go to previous messageGo to next message
Eclipse UserFriend
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 ?
>
>
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 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: seemakhopade.hsbc.co.in

Thanks for the prompt response.

I am using birt-report-designer-all-in-one-2_2_0
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 Go to previous messageGo to next message
Eclipse UserFriend
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 .
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 Go to previous messageGo to next message
Eclipse UserFriend
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 .
>
Re: Problem with the Export Data options from the BIRT - toolbar [message #211140 is a reply to message #211134] Wed, 26 March 2008 16:54 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: seemakhopade.hsbc.co.in

Thanx a lot Jason.
I modified js as u said and Its working fine :-)
Re: Problem with the Export Data options from the BIRT - toolbar [message #211146 is a reply to message #211140] Wed, 26 March 2008 17:10 Go to previous message
Eclipse UserFriend
Originally posted by: seemakhopade.hsbc.co.in

Extra columns were getting added because of Row-Highlighting
Previous Topic:Dependent Projects
Next Topic:use Websphere 6.1 JDBC
Goto Forum:
  


Current Time: Sat Dec 20 08:44:29 GMT 2014

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

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