Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Export Data shows multiple rows in CSV
Export Data shows multiple rows in CSV [message #754095] Mon, 31 October 2011 18:25 Go to next message
hazelj  is currently offline hazelj Friend
Messages: 7
Registered: October 2009
Junior Member
Each time I export data from a BIRT report, I am getting 2 rows in the csv file.
What could be causing this issue?

Any help appreciated!
Re: Export Data shows multiple rows in CSV [message #754197 is a reply to message #754095] Tue, 01 November 2011 10:20 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you post the report?

Jason

On 10/31/2011 2:25 PM, hazelj wrote:
> Each time I export data from a BIRT report, I am getting 2 rows in the
> csv file.
> What could be causing this issue?
> Any help appreciated!
Re: Export Data shows multiple rows in CSV [message #754214 is a reply to message #754197] Tue, 01 November 2011 13:18 Go to previous messageGo to next message
hazelj  is currently offline hazelj Friend
Messages: 7
Registered: October 2009
Junior Member
Here is the report:

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903 Build &lt;2.5.1.v20090922-0630></property>
<property name="units">in</property>
<list-property name="propertyBindings">
<structure>
<property name="name">odaDriverClass</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">odaURL</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">odaUser</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">odaPassword</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">odaAutoCommit</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">odaIsolationMode</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">odaJndiName</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">OdaConnProfileName</property>
<property name="id">517</property>
</structure>
<structure>
<property name="name">OdaConnProfileStorePath</property>
<property name="id">517</property>
</structure>
</list-property>
<property name="bidiLayoutOrientation">ltr</property>
<parameters>
<scalar-parameter name="StartDate" id="519">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
<property name="pattern">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="StopDate" id="520">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
<property name="pattern">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="OperatorID" id="521">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
<property name="pattern">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="SectionID" id="522">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
<property name="pattern">Unformatted</property>
</structure>
</scalar-parameter>
<scalar-parameter name="WorkAreaID" id="524">
<property name="valueType">static</property>
<property name="isRequired">false</property>
<property name="dataType">string</property>
<property name="controlType">text-box</property>
<structure name="format">
<property name="category">Unformatted</property>
<property name="pattern">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="DirectorIT" id="517">
<list-property name="privateDriverProperties">
<ex-property>
<name>contentBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
<ex-property>
<name>metadataBidiFormatStr</name>
<value>ILYNN</value>
</ex-property>
</list-property>
<property name="odaDriverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="odaURL">jdbc:sqlserver://MACHine:1433;DatabaseName=DB</property>
<property name="odaUser">History</property>
<encrypted-property name="odaPassword" encryptionID="base64">UGlja0RpcmVjdG9ySGlzdG9yeQ==</encrypted-property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet" name="GetOperatorStatistics" id="518">
<list-property name="parameters">
<structure>
<property name="name">StartDate</property>
<property name="nativeName">StartDate</property>
<property name="dataType">string</property>
<property name="position">1</property>
<expression name="defaultValue">'2006-09-02 10:27:42.450'</expression>
<property name="isInput">true</property>
</structure>
<structure>
<property name="name">StopDate</property>
<property name="nativeName">StopDate</property>
<property name="dataType">string</property>
<property name="position">2</property>
<expression name="defaultValue" type="javascript">'2011-10-03 10:27:42.450'</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">OperatorID</property>
<property name="nativeName">OperatorID</property>
<property name="dataType">string</property>
<property name="position">3</property>
<expression name="defaultValue">'ALL'</expression>
<property name="isInput">true</property>
</structure>
<structure>
<property name="name">SectionID</property>
<property name="nativeName">SectionID</property>
<property name="dataType">string</property>
<property name="position">4</property>
<expression name="defaultValue">'ALL'</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
<structure>
<property name="name">WorkAreaID</property>
<property name="nativeName">WorkAreaID</property>
<property name="dataType">string</property>
<property name="position">5</property>
<expression name="defaultValue">'ALL'</expression>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Logontime</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LogoffTime</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">LoggedInSeconds</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PausedSeconds</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">OperatorID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">DisplayName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ZoneID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ZoneName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">WorkAreaID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">MapID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">InductCount</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">HitCount</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">PutCount</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">MergeLoggedInSeconds</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
</structure>
<property name="dataSource">DIT</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">Logontime</property>
<property name="nativeName">Logontime</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">LogoffTime</property>
<property name="nativeName">LogoffTime</property>
<property name="dataType">date-time</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">LoggedInSeconds</property>
<property name="nativeName">LoggedInSeconds</property>
<property name="dataType">decimal</property>
</structure>
<structure>
<property name="position">4</property>
<property name="name">PausedSeconds</property>
<property name="nativeName">PausedSeconds</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">5</property>
<property name="name">OperatorID</property>
<property name="nativeName">OperatorID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">6</property>
<property name="name">DisplayName</property>
<property name="nativeName">DisplayName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">7</property>
<property name="name">ZoneID</property>
<property name="nativeName">ZoneID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">8</property>
<property name="name">ZoneName</property>
<property name="nativeName">ZoneName</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">9</property>
<property name="name">WorkAreaID</property>
<property name="nativeName">WorkAreaID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">10</property>
<property name="name">MapID</property>
<property name="nativeName">MapID</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">11</property>
<property name="name">InductCount</property>
<property name="nativeName">InductCount</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">12</property>
<property name="name">HitCount</property>
<property name="nativeName">HitCount</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">13</property>
<property name="name">PutCount</property>
<property name="nativeName">PutCount</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">14</property>
<property name="name">MergeLoggedInSeconds</property>
<property name="nativeName">MergeLoggedInSeconds</property>
<property name="dataType">decimal</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[{call PickDirectorHistory.GetOperatorStatistics(?,?,?,?,?)}]]></xml-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab-cell" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="NewStyle" id="78">
<property name="borderBottomStyle">solid</property>
<property name="borderLeftStyle">solid</property>
<property name="borderRightStyle">solid</property>
<property name="borderTopStyle">solid</property>
</style>
<style name="sdecimal" id="833">
<structure name="numberFormat">
<property name="category">Custom</property>
<property name="pattern">0.00</property>
</structure>
</style>
<style name="LoggedInDuration" id="834">
<structure name="stringFormat">
<property name="category">Custom</property>
<property name="pattern">@@ - Day(s) @@:@@:@@</property>
</structure>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<property name="orientation">landscape</property>
<page-footer>
<grid id="391">
<property name="height">0.2708333333333333in</property>
<property name="width">9.291666666666666in</property>
<column id="392">
<property name="width">3.5729166666666665in</property>
</column>
<column id="393">
<property name="width">4.625in</property>
</column>
<column id="893">
<property name="width">0.5in</property>
</column>
<column id="394">
<property name="width">0.59375in</property>
</column>
<row id="395">
<property name="height">0.2708333333333333in</property>
<cell id="396">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<text id="407">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[Created on: <value-of>new Date()</value-of>]]></text-property>
</text>
</cell>
<cell id="892">
<label id="894">
<property name="textAlign">right</property>
<text-property name="text">Page:</text-property>
</label>
</cell>
<cell id="398">
<auto-text id="895">
<property name="type">page-number</property>
</auto-text>
</cell>
</row>
</grid>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<grid id="250">
<property name="width">100%</property>
<column id="251"/>
<row id="254">
<property name="height">0.791in</property>
<cell id="255">
<text id="289">
<property name="backgroundColor">#C0C0C0</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">medium</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">medium</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">medium</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">medium</property>
<property name="textAlign">center</property>
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<H2>Statistics By Operator</H2>
]]></text-property>
</text>
</cell>
</row>
<row id="258">
<cell id="259"/>
</row>
<row id="262">
<cell id="263"/>
</row>
</grid>
<grid id="270">
<property name="width">100%</property>
<column id="271">
<property name="width">2.208in</property>
</column>
<column id="272">
<property name="width">3.781in</property>
</column>
<row id="274">
<cell id="275">
<property name="colSpan">2</property>
<property name="rowSpan">1</property>
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="276">
<property name="fontSize">larger</property>
<property name="fontWeight">bold</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[Parameters :]]></text-property>
</text>
</cell>
</row>
<row id="279">
<cell id="280">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
<cell id="283">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
</row>
<row id="512">
<cell id="513">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="515">
<property name="textAlign">right</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[Start Date/Time : ]]></text-property>
</text>
</cell>
<cell id="514">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="827">
<property name="paddingLeft">10pt</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">params["StartDate"]</property>
<expression name="expression">params["StartDate"]</expression>
</structure>
</list-property>
<property name="allowExport">false</property>
<property name="resultSetColumn">params["StartDate"]</property>
</data>
</cell>
</row>
<row id="291">
<cell id="292">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="301">
<property name="textAlign">right</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[Stop Date/Time : ]]></text-property>
</text>
</cell>
<cell id="293">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="828">
<property name="paddingLeft">10pt</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">params["StopDate"]</property>
<expression name="expression">params["StopDate"]</expression>
</structure>
</list-property>
<property name="allowExport">false</property>
<property name="resultSetColumn">params["StopDate"]</property>
</data>
</cell>
</row>
<row id="350">
<cell id="351">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="353">
<property name="textAlign">right</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[Operator ID : ]]></text-property>
</text>
</cell>
<cell id="352">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="829">
<property name="paddingLeft">10pt</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">params["OperatorID"]</property>
<expression name="expression">params["OperatorID"]</expression>
</structure>
</list-property>
<property name="allowExport">false</property>
<property name="resultSetColumn">params["OperatorID"]</property>
</data>
</cell>
</row>
<row id="359">
<cell id="360">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="373">
<property name="textAlign">right</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[Section ID : ]]></text-property>
</text>
</cell>
<cell id="361">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="830">
<property name="paddingLeft">10pt</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">params["SectionID"]</property>
<expression name="expression">params["SectionID"]</expression>
</structure>
</list-property>
<property name="allowExport">false</property>
<property name="resultSetColumn">params["SectionID"]</property>
</data>
</cell>
</row>
<row id="526">
<cell id="527">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="529">
<property name="textAlign">right</property>
<property name="contentType">plain</property>
<text-property name="content"><![CDATA[Work Area ID : ]]></text-property>
</text>
</cell>
<cell id="528">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<data id="831">
<property name="paddingLeft">10pt</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">params["WorkAreaID"]</property>
<expression name="expression">params["WorkAreaID"]</expression>
</structure>
</list-property>
<property name="allowExport">false</property>
<property name="resultSetColumn">params["WorkAreaID"]</property>
</data>
</cell>
</row>
<row id="365">
<cell id="366">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<text id="343">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<HR>]]></text-property>
</text>
</cell>
<cell id="367">
<property name="borderBottomColor">#FFFFFF</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#FFFFFF</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#FFFFFF</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#FFFFFF</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
</cell>
</row>
</grid>
<grid id="96">
<property name="height">5.90625in</property>
<property name="width">10.385416666666666in</property>
<column id="97">
<property name="width">10.385416666666666in</property>
</column>
<row id="102">
<property name="height">5.395833333333333in</property>
<cell id="103">
<table name="Data Grid" id="835">
<property name="backgroundColor">#FFFFFF</property>
<property name="borderBottomColor">#000000</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">thin</property>
<property name="borderLeftColor">#000000</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">thin</property>
<property name="borderRightColor">#000000</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">thin</property>
<property name="borderTopColor">#000000</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">thin</property>
<property name="height">5.15625in</property>
<property name="width">9.2708333333in</property>
<property name="dataSet">GetOperatorStatistics</property>
<list-property name="paramBindings">
<structure>
<property name="paramName">StartDate</property>
<expression name="expression">params["StartDate"]</expression>
</structure>
<structure>
<property name="paramName">StopDate</property>
<expression name="expression">params["StopDate"]</expression>

[Updated on: Tue, 01 November 2011 13:20]

Report message to a moderator

Re: Export Data shows multiple rows in CSV [message #754601 is a reply to message #754214] Thu, 03 November 2011 13:08 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

The entire report did not come through. Can you email it to me or attach
it to the post?

jasonweathersby at windstream dot net



On 11/1/2011 9:18 AM, hazelj wrote:
> Here is the report:
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.20"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903
> Build <2.5.1.v20090922-0630></property>
> <property name="units">in</property>
> <list-property name="propertyBindings">
> <structure>
> <property name="name">odaDriverClass</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">odaURL</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">odaUser</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">odaPassword</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">odaAutoCommit</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">odaIsolationMode</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">odaJndiName</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">OdaConnProfileName</property>
> <property name="id">517</property>
> </structure>
> <structure>
> <property name="name">OdaConnProfileStorePath</property>
> <property name="id">517</property>
> </structure>
> </list-property>
> <property name="bidiLayoutOrientation">ltr</property>
> <parameters>
> <scalar-parameter name="StartDate" id="519">
> <property name="valueType">static</property>
> <property name="isRequired">false</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="StopDate" id="520">
> <property name="valueType">static</property>
> <property name="isRequired">false</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="OperatorID" id="521">
> <property name="valueType">static</property>
> <property name="isRequired">false</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="SectionID" id="522">
> <property name="valueType">static</property>
> <property name="isRequired">false</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> <scalar-parameter name="WorkAreaID" id="524">
> <property name="valueType">static</property>
> <property name="isRequired">false</property>
> <property name="dataType">string</property>
> <property name="controlType">text-box</property>
> <structure name="format">
> <property name="category">Unformatted</property>
> <property name="pattern">Unformatted</property>
> </structure>
> </scalar-parameter>
> </parameters>
> <data-sources>
> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc"
> name="DirectorIT" id="517">
> <list-property name="privateDriverProperties">
> <ex-property>
> <name>contentBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> <ex-property>
> <name>metadataBidiFormatStr</name>
> <value>ILYNN</value>
> </ex-property>
> </list-property>
> <property
> name="odaDriverClass">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
>
> <property
> name="odaURL">jdbc:sqlserver://US0664NB:1433;DatabaseName=PFSWeb</property>
> <property name="odaUser">PickDirectorHistory</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">UGlja0RpcmVjdG9ySGlzdG9yeQ==</encrypted-property>
> </oda-data-source>
> </data-sources>
> <data-sets>
> <oda-data-set
> extensionID="org.eclipse.birt.report.data.oda.jdbc.SPSelectDataSet"
> name="GetOperatorStatistics" id="518">
> <list-property name="parameters">
> <structure>
> <property name="name">StartDate</property>
> <property name="nativeName">StartDate</property>
> <property name="dataType">string</property>
> <property name="position">1</property>
> <expression name="defaultValue">'2006-09-02 10:27:42.450'</expression>
> <property name="isInput">true</property>
> </structure>
> <structure>
> <property name="name">StopDate</property>
> <property name="nativeName">StopDate</property>
> <property name="dataType">string</property>
> <property name="position">2</property>
> <expression name="defaultValue" type="javascript">'2011-10-03
> 10:27:42.450'</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">OperatorID</property>
> <property name="nativeName">OperatorID</property>
> <property name="dataType">string</property>
> <property name="position">3</property>
> <expression name="defaultValue">'ALL'</expression>
> <property name="isInput">true</property>
> </structure>
> <structure>
> <property name="name">SectionID</property>
> <property name="nativeName">SectionID</property>
> <property name="dataType">string</property>
> <property name="position">4</property>
> <expression name="defaultValue">'ALL'</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> <structure>
> <property name="name">WorkAreaID</property>
> <property name="nativeName">WorkAreaID</property>
> <property name="dataType">string</property>
> <property name="position">5</property>
> <expression name="defaultValue">'ALL'</expression>
> <property name="isInput">true</property>
> <property name="isOutput">false</property>
> </structure>
> </list-property>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">Logontime</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">LogoffTime</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">LoggedInSeconds</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PausedSeconds</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">OperatorID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">DisplayName</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ZoneID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">ZoneName</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">WorkAreaID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">MapID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">InductCount</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">HitCount</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">PutCount</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">MergeLoggedInSeconds</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">DirectorIT</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">Logontime</property>
> <property name="nativeName">Logontime</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">LogoffTime</property>
> <property name="nativeName">LogoffTime</property>
> <property name="dataType">date-time</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">LoggedInSeconds</property>
> <property name="nativeName">LoggedInSeconds</property>
> <property name="dataType">decimal</property>
> </structure>
> <structure>
> <property name="position">4</property>
> <property name="name">PausedSeconds</property>
> <property name="nativeName">PausedSeconds</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">5</property>
> <property name="name">OperatorID</property>
> <property name="nativeName">OperatorID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">6</property>
> <property name="name">DisplayName</property>
> <property name="nativeName">DisplayName</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">7</property>
> <property name="name">ZoneID</property>
> <property name="nativeName">ZoneID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">8</property>
> <property name="name">ZoneName</property>
> <property name="nativeName">ZoneName</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">9</property>
> <property name="name">WorkAreaID</property>
> <property name="nativeName">WorkAreaID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">10</property>
> <property name="name">MapID</property>
> <property name="nativeName">MapID</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">11</property>
> <property name="name">InductCount</property>
> <property name="nativeName">InductCount</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">12</property>
> <property name="name">HitCount</property>
> <property name="nativeName">HitCount</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">13</property>
> <property name="name">PutCount</property>
> <property name="nativeName">PutCount</property>
> <property name="dataType">integer</property>
> </structure>
> <structure>
> <property name="position">14</property>
> <property name="name">MergeLoggedInSeconds</property>
> <property name="nativeName">MergeLoggedInSeconds</property>
> <property name="dataType">decimal</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[{call
> PickDirectorHistory.GetOperatorStatistics(?,?,?,?,?)}]]></xml-property>
> </oda-data-set>
> </data-sets>
> <styles>
> <style name="report" id="4">
> <property name="fontFamily">sans-serif</property>
> <property name="fontSize">10pt</property>
> </style>
> <style name="crosstab-cell" id="5">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="crosstab" id="6">
> <property name="borderBottomColor">#CCCCCC</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">1pt</property>
> <property name="borderLeftColor">#CCCCCC</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">1pt</property>
> <property name="borderRightColor">#CCCCCC</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">1pt</property>
> <property name="borderTopColor">#CCCCCC</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">1pt</property>
> </style>
> <style name="NewStyle" id="78">
> <property name="borderBottomStyle">solid</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderTopStyle">solid</property>
> </style>
> <style name="sdecimal" id="833">
> <structure name="numberFormat">
> <property name="category">Custom</property>
> <property name="pattern">0.00</property>
> </structure>
> </style>
> <style name="LoggedInDuration" id="834">
> <structure name="stringFormat">
> <property name="category">Custom</property>
> <property name="pattern">@@ - Day(s) @@:@@:@@</property>
> </structure>
> </style>
> </styles>
> <page-setup>
> <simple-master-page name="Simple MasterPage" id="2">
> <property name="orientation">landscape</property>
> <page-footer>
> <grid id="391">
> <property name="height">0.2708333333333333in</property>
> <property name="width">9.291666666666666in</property>
> <column id="392">
> <property name="width">3.5729166666666665in</property>
> </column>
> <column id="393">
> <property name="width">4.625in</property>
> </column>
> <column id="893">
> <property name="width">0.5in</property>
> </column>
> <column id="394">
> <property name="width">0.59375in</property>
> </column>
> <row id="395">
> <property name="height">0.2708333333333333in</property>
> <cell id="396">
> <property name="colSpan">2</property>
> <property name="rowSpan">1</property>
> <text id="407">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[Created on: <value-of>new
> Date()</value-of>]]></text-property>
> </text>
> </cell>
> <cell id="892">
> <label id="894">
> <property name="textAlign">right</property>
> <text-property name="text">Page:</text-property>
> </label>
> </cell>
> <cell id="398">
> <auto-text id="895">
> <property name="type">page-number</property>
> </auto-text>
> </cell>
> </row>
> </grid>
> </page-footer>
> </simple-master-page>
> </page-setup>
> <body>
> <grid id="250">
> <property name="width">100%</property>
> <column id="251"/>
> <row id="254">
> <property name="height">0.791in</property>
> <cell id="255">
> <text id="289">
> <property name="backgroundColor">#C0C0C0</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">medium</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">medium</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">medium</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">medium</property>
> <property name="textAlign">center</property>
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<H2>Statistics By Operator</H2>
> ]]></text-property>
> </text>
> </cell>
> </row>
> <row id="258">
> <cell id="259"/>
> </row>
> <row id="262">
> <cell id="263"/>
> </row>
> </grid>
> <grid id="270">
> <property name="width">100%</property>
> <column id="271">
> <property name="width">2.208in</property>
> </column>
> <column id="272">
> <property name="width">3.781in</property>
> </column>
> <row id="274">
> <cell id="275">
> <property name="colSpan">2</property>
> <property name="rowSpan">1</property>
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="276">
> <property name="fontSize">larger</property>
> <property name="fontWeight">bold</property>
> <property name="contentType">plain</property>
> <text-property name="content"><![CDATA[Parameters :]]></text-property>
> </text>
> </cell>
> </row>
> <row id="279">
> <cell id="280">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </cell>
> <cell id="283">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </cell>
> </row>
> <row id="512">
> <cell id="513">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="515">
> <property name="textAlign">right</property>
> <property name="contentType">plain</property>
> <text-property name="content"><![CDATA[Start Date/Time :
> ]]></text-property>
> </text>
> </cell>
> <cell id="514">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="827">
> <property name="paddingLeft">10pt</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">params["StartDate"]</property>
> <expression name="expression">params["StartDate"]</expression>
> </structure>
> </list-property>
> <property name="allowExport">false</property>
> <property name="resultSetColumn">params["StartDate"]</property>
> </data>
> </cell>
> </row>
> <row id="291">
> <cell id="292">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="301">
> <property name="textAlign">right</property>
> <property name="contentType">plain</property>
> <text-property name="content"><![CDATA[Stop Date/Time : ]]></text-property>
> </text>
> </cell>
> <cell id="293">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="828">
> <property name="paddingLeft">10pt</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">params["StopDate"]</property>
> <expression name="expression">params["StopDate"]</expression>
> </structure>
> </list-property>
> <property name="allowExport">false</property>
> <property name="resultSetColumn">params["StopDate"]</property>
> </data>
> </cell>
> </row>
> <row id="350">
> <cell id="351">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="353">
> <property name="textAlign">right</property>
> <property name="contentType">plain</property>
> <text-property name="content"><![CDATA[Operator ID : ]]></text-property>
> </text>
> </cell>
> <cell id="352">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="829">
> <property name="paddingLeft">10pt</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">params["OperatorID"]</property>
> <expression name="expression">params["OperatorID"]</expression>
> </structure>
> </list-property>
> <property name="allowExport">false</property>
> <property name="resultSetColumn">params["OperatorID"]</property>
> </data>
> </cell>
> </row>
> <row id="359">
> <cell id="360">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="373">
> <property name="textAlign">right</property>
> <property name="contentType">plain</property>
> <text-property name="content"><![CDATA[Section ID : ]]></text-property>
> </text>
> </cell>
> <cell id="361">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="830">
> <property name="paddingLeft">10pt</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">params["SectionID"]</property>
> <expression name="expression">params["SectionID"]</expression>
> </structure>
> </list-property>
> <property name="allowExport">false</property>
> <property name="resultSetColumn">params["SectionID"]</property>
> </data>
> </cell>
> </row>
> <row id="526">
> <cell id="527">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="529">
> <property name="textAlign">right</property>
> <property name="contentType">plain</property>
> <text-property name="content"><![CDATA[Work Area ID : ]]></text-property>
> </text>
> </cell>
> <cell id="528">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <data id="831">
> <property name="paddingLeft">10pt</property>
> <list-property name="boundDataColumns">
> <structure>
> <property name="name">params["WorkAreaID"]</property>
> <expression name="expression">params["WorkAreaID"]</expression>
> </structure>
> </list-property>
> <property name="allowExport">false</property>
> <property name="resultSetColumn">params["WorkAreaID"]</property>
> </data>
> </cell>
> </row>
> <row id="365">
> <cell id="366">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <text id="343">
> <property name="contentType">html</property>
> <text-property name="content"><![CDATA[<HR>]]></text-property>
> </text>
> </cell>
> <cell id="367">
> <property name="borderBottomColor">#FFFFFF</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#FFFFFF</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#FFFFFF</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#FFFFFF</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> </cell>
> </row>
> </grid>
> <grid id="96">
> <property name="height">5.90625in</property>
> <property name="width">10.385416666666666in</property>
> <column id="97">
> <property name="width">10.385416666666666in</property>
> </column>
> <row id="102">
> <property name="height">5.395833333333333in</property>
> <cell id="103">
> <table name="Data Grid" id="835">
> <property name="backgroundColor">#FFFFFF</property>
> <property name="borderBottomColor">#000000</property>
> <property name="borderBottomStyle">solid</property>
> <property name="borderBottomWidth">thin</property>
> <property name="borderLeftColor">#000000</property>
> <property name="borderLeftStyle">solid</property>
> <property name="borderLeftWidth">thin</property>
> <property name="borderRightColor">#000000</property>
> <property name="borderRightStyle">solid</property>
> <property name="borderRightWidth">thin</property>
> <property name="borderTopColor">#000000</property>
> <property name="borderTopStyle">solid</property>
> <property name="borderTopWidth">thin</property>
> <property name="height">5.15625in</property>
> <property name="width">9.2708333333in</property>
> <property name="dataSet">GetOperatorStatistics</property>
> <list-property name="paramBindings">
> <structure>
> <property name="paramName">StartDate</property>
> <expression name="expression">params["StartDate"]</expression>
> </structure>
> <structure>
> <property name="paramName">StopDate</property>
> <expression name="expression">params["StopDate"]</expression>
Previous Topic:How to specify a relative path to sample XML file
Next Topic:How to set the x-axis order
Goto Forum:
  


Current Time: Sat Dec 20 22:16:10 GMT 2014

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

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