BIRT: Using Reflection to get Total Page Count

I could have sworn I had posted this previously. My mind must be slipping.

A common question that comes up in the newsgroups for BIRT is how to access the total page count during render time. You would think this is an easy question to answer, however it has proven more difficult than originally thought. There is an Auto-Text item already in BIRT that will display the total page count, but none of its properties are accessible publicly.

Fortunately, there is a workaround. To get access to the total page count, you need to get access to the Report Document Reader created after the Run Task has completed. This is stored in the application context, but in a private field. So how do we get access to the report document? By using Java Reflection. Below is an example of how to get access to the Report Document Reader stored in the app context. This needs to be put into the beforeFactory event, which means it is only available at Render Time.

var rciClass = reportContext.getClass();

var fieldFromScript = rciClass.getDeclaredField("context");
fieldFromScript.setAccessible(true);

var execContext = fieldFromScript.get(reportContext);

// Now, we have the exeuctionContext. We can get the currently rendering
// report documents location

var doc = execContext.getReportDocument();

if (doc != null) {
var pageCount = doc. getPageCount();

reportContext.setGlobalVariable("totalPageCount", pageCount);
}

So now you can use the totalPageCount variable anywhere in the Render phase. So keep in mind, you can’t add this to a report because the report element are created during run time, this is only used to affect Render operations. You could create a report item extension to display it, and to demonstrate that, I dropped a chart since charts are created at render time. The chart will display the text “Page Count” on the X Axis, and the bars will go up to the actual page count.

<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.17" id="1">
   <property name="createdBy">Eclipse BIRT Designer Version 2.3.2.r232_20090202 Build &lt;2.3.2.v20090218-0730></property>
   <property name="units">in</property>
   <method name="beforeRender"><![CDATA[var rciClass = reportContext.getClass();
          
var fieldFromScript = rciClass.getDeclaredField("context");
fieldFromScript.setAccessible(true);

var execContext = fieldFromScript.get(reportContext);

// Now, we have the exeuctionContext. We can get the currently rendering
// report documents location

var doc = execContext.getReportDocument();

if (doc != null) {
   var pageCount = doc.getPageCount();

   reportContext.setGlobalVariable("totalPageCount", pageCount);
   params["PageCount"].value = pageCount;
}
]]></method>
   <property name="iconFile">/templates/blank_report.gif</property>
   <property name="layoutPreference">auto layout</property>
   <property name="bidiLayoutOrientation">ltr</property>
   <parameters>
       <scalar-parameter name="PageCount" id="80">
           <property name="hidden">true</property>
           <property name="valueType">static</property>
           <property name="dataType">string</property>
           <property name="paramType">simple</property>
           <property name="isRequired">false</property>
           <property name="controlType">text-box</property>
           <property name="defaultValue">-1</property>
           <property name="distinct">true</property>
           <structure name="format">
               <property name="category">Unformatted</property>
           </structure>
       </scalar-parameter>
   </parameters>
   <data-sources>
       <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7">
           <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property>
           <property name="odaURL">jdbc:classicmodels:sampledb</property>
           <property name="odaUser">ClassicModels</property>
       </oda-data-source>
   </data-sources>
   <data-sets>
       <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="8">
           <list-property name="columnHints">
               <structure>
                   <property name="columnName">EMPLOYEENUMBER</property>
                   <property name="displayName">EMPLOYEENUMBER</property>
               </structure>
               <structure>
                   <property name="columnName">LASTNAME</property>
                   <property name="displayName">LASTNAME</property>
               </structure>
               <structure>
                   <property name="columnName">FIRSTNAME</property>
                   <property name="displayName">FIRSTNAME</property>
               </structure>
               <structure>
                   <property name="columnName">EXTENSION</property>
                   <property name="displayName">EXTENSION</property>
               </structure>
               <structure>
                   <property name="columnName">EMAIL</property>
                   <property name="displayName">EMAIL</property>
               </structure>
               <structure>
                   <property name="columnName">OFFICECODE</property>
                   <property name="displayName">OFFICECODE</property>
               </structure>
               <structure>
                   <property name="columnName">REPORTSTO</property>
                   <property name="displayName">REPORTSTO</property>
               </structure>
               <structure>
                   <property name="columnName">JOBTITLE</property>
                   <property name="displayName">JOBTITLE</property>
               </structure>
           </list-property>
           <structure name="cachedMetaData">
               <list-property name="resultSet">
                   <structure>
                       <property name="position">1</property>
                       <property name="name">EMPLOYEENUMBER</property>
                       <property name="dataType">integer</property>
                   </structure>
                   <structure>
                       <property name="position">2</property>
                       <property name="name">LASTNAME</property>
                       <property name="dataType">string</property>
                   </structure>
                   <structure>
                       <property name="position">3</property>
                       <property name="name">FIRSTNAME</property>
                       <property name="dataType">string</property>
                   </structure>
                   <structure>
                       <property name="position">4</property>
                       <property name="name">EXTENSION</property>
                       <property name="dataType">string</property>
                   </structure>
                   <structure>
                       <property name="position">5</property>
                       <property name="name">EMAIL</property>
                       <property name="dataType">string</property>
                   </structure>
                   <structure>
                       <property name="position">6</property>
                       <property name="name">OFFICECODE</property>
                       <property name="dataType">string</property>
                   </structure>
                   <structure>
                       <property name="position">7</property>
                       <property name="name">REPORTSTO</property>
                       <property name="dataType">integer</property>
                   </structure>
                   <structure>
                       <property name="position">8</property>
                       <property name="name">JOBTITLE</property>
                       <property name="dataType">string</property>
                   </structure>
               </list-property>
           </structure>
           <property name="dataSource">Data Source</property>
           <list-property name="resultSet">
               <structure>
                   <property name="position">1</property>
                   <property name="name">EMPLOYEENUMBER</property>
                   <property name="nativeName">EMPLOYEENUMBER</property>
                   <property name="dataType">integer</property>
                   <property name="nativeDataType">4</property>
               </structure>
               <structure>
                   <property name="position">2</property>
                   <property name="name">LASTNAME</property>
                   <property name="nativeName">LASTNAME</property>
                   <property name="dataType">string</property>
                   <property name="nativeDataType">12</property>
               </structure>
               <structure>
                   <property name="position">3</property>
                   <property name="name">FIRSTNAME</property>
                   <property name="nativeName">FIRSTNAME</property>
                   <property name="dataType">string</property>
                   <property name="nativeDataType">12</property>
               </structure>
               <structure>
                   <property name="position">4</property>
                   <property name="name">EXTENSION</property>
                   <property name="nativeName">EXTENSION</property>
                   <property name="dataType">string</property>
                   <property name="nativeDataType">12</property>
               </structure>
               <structure>
                   <property name="position">5</property>
                   <property name="name">EMAIL</property>
                   <property name="nativeName">EMAIL</property>
                   <property name="dataType">string</property>
                   <property name="nativeDataType">12</property>
               </structure>
               <structure>
                   <property name="position">6</property>
                   <property name="name">OFFICECODE</property>
                   <property name="nativeName">OFFICECODE</property>
                   <property name="dataType">string</property>
                   <property name="nativeDataType">12</property>
               </structure>
               <structure>
                   <property name="position">7</property>
                   <property name="name">REPORTSTO</property>
                   <property name="nativeName">REPORTSTO</property>
                   <property name="dataType">integer</property>
                   <property name="nativeDataType">4</property>
               </structure>
               <structure>
                   <property name="position">8</property>
                   <property name="name">JOBTITLE</property>
                   <property name="nativeName">JOBTITLE</property>
                   <property name="dataType">string</property>
                   <property name="nativeDataType">12</property>
               </structure>
           </list-property>
           <property name="queryText">select *
from CLASSICMODELS.EMPLOYEES</property>
           <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
 <Version>1.0</Version>
 <design:ResultSets derivedMetaData="true">
   <design:resultSetDefinitions>
     <design:resultSetColumns>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>EMPLOYEENUMBER</design:name>
           <design:position>1</design:position>
           <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
           <design:precision>10</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>EMPLOYEENUMBER</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>EMPLOYEENUMBER</design:label>
           <design:formattingHints>
             <design:displaySize>11</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>LASTNAME</design:name>
           <design:position>2</design:position>
           <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
           <design:precision>50</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>LASTNAME</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>LASTNAME</design:label>
           <design:formattingHints>
             <design:displaySize>50</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>FIRSTNAME</design:name>
           <design:position>3</design:position>
           <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
           <design:precision>50</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>FIRSTNAME</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>FIRSTNAME</design:label>
           <design:formattingHints>
             <design:displaySize>50</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>EXTENSION</design:name>
           <design:position>4</design:position>
           <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
           <design:precision>10</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>EXTENSION</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>EXTENSION</design:label>
           <design:formattingHints>
             <design:displaySize>10</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>EMAIL</design:name>
           <design:position>5</design:position>
           <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
           <design:precision>100</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>EMAIL</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>EMAIL</design:label>
           <design:formattingHints>
             <design:displaySize>100</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>OFFICECODE</design:name>
           <design:position>6</design:position>
           <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
           <design:precision>10</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>OFFICECODE</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>OFFICECODE</design:label>
           <design:formattingHints>
             <design:displaySize>10</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>REPORTSTO</design:name>
           <design:position>7</design:position>
           <design:nativeDataTypeCode>4</design:nativeDataTypeCode>
           <design:precision>10</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>REPORTSTO</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>REPORTSTO</design:label>
           <design:formattingHints>
             <design:displaySize>11</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
       <design:resultColumnDefinitions>
         <design:attributes>
           <design:name>JOBTITLE</design:name>
           <design:position>8</design:position>
           <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
           <design:precision>50</design:precision>
           <design:scale>0</design:scale>
           <design:nullability>Nullable</design:nullability>
           <design:uiHints>
             <design:displayName>JOBTITLE</design:displayName>
           </design:uiHints>
         </design:attributes>
         <design:usageHints>
           <design:label>JOBTITLE</design:label>
           <design:formattingHints>
             <design:displaySize>50</design:displaySize>
           </design:formattingHints>
         </design:usageHints>
       </design:resultColumnDefinitions>
     </design:resultSetColumns>
   </design:resultSetDefinitions>
 </design:ResultSets>
</model:DesignValues>]]></xml-property>
       </oda-data-set>
   </data-sets>
   <styles>
       <style name="report" id="4">
           <property name="fontFamily">"Verdana"</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>
   </styles>
   <page-setup>
       <simple-master-page name="Simple MasterPage" id="2">
           <property name="topMargin">0.25in</property>
           <property name="leftMargin">0.25in</property>
           <property name="bottomMargin">0.25in</property>
           <property name="rightMargin">0.25in</property>
           <page-footer>
               <text id="78">
                   <property name="contentType">html</property>
                   <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
               </text>
           </page-footer>
       </simple-master-page>
   </page-setup>
   <body>
       <table id="9">
           <property name="width">100%</property>
           <property name="dataSet">Data Set</property>
           <list-property name="boundDataColumns">
               <structure>
                   <property name="name">EMPLOYEENUMBER</property>
                   <property name="displayName">EMPLOYEENUMBER</property>
                   <expression name="expression">dataSetRow["EMPLOYEENUMBER"]</expression>
                   <property name="dataType">integer</property>
               </structure>
               <structure>
                   <property name="name">LASTNAME</property>
                   <property name="displayName">LASTNAME</property>
                   <expression name="expression">dataSetRow["LASTNAME"]</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">FIRSTNAME</property>
                   <property name="displayName">FIRSTNAME</property>
                   <expression name="expression">dataSetRow["FIRSTNAME"]</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">EXTENSION</property>
                   <property name="displayName">EXTENSION</property>
                   <expression name="expression">dataSetRow["EXTENSION"]</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">EMAIL</property>
                   <property name="displayName">EMAIL</property>
                   <expression name="expression">dataSetRow["EMAIL"]</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">OFFICECODE</property>
                   <property name="displayName">OFFICECODE</property>
                   <expression name="expression">dataSetRow["OFFICECODE"]</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">REPORTSTO</property>
                   <property name="displayName">REPORTSTO</property>
                   <expression name="expression">dataSetRow["REPORTSTO"]</expression>
                   <property name="dataType">integer</property>
               </structure>
               <structure>
                   <property name="name">JOBTITLE</property>
                   <property name="displayName">JOBTITLE</property>
                   <expression name="expression">dataSetRow["JOBTITLE"]</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">Column Binding</property>
                   <expression name="expression">"Total Pages: "</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">Column Binding_1</property>
                   <expression name="expression">reportContext.getGlobalVariable("totalPageCount")</expression>
                   <property name="dataType">string</property>
               </structure>
               <structure>
                   <property name="name">Column Binding_2</property>
                   <expression name="expression">params["PageCount"].value</expression>
                   <property name="dataType">string</property>
               </structure>
           </list-property>
           <property name="pageBreakInterval">4</property>
           <column id="53"/>
           <column id="54"/>
           <column id="55"/>
           <column id="56"/>
           <column id="57"/>
           <column id="58"/>
           <column id="59"/>
           <column id="60"/>
           <header>
               <row id="10">
                   <property name="fontWeight">bold</property>
                   <property name="textAlign">left</property>
                   <cell id="11">
                       <label id="12">
                           <text-property name="text">EMPLOYEENUMBER</text-property>
                       </label>
                   </cell>
                   <cell id="13">
                       <label id="14">
                           <text-property name="text">LASTNAME</text-property>
                       </label>
                   </cell>
                   <cell id="15">
                       <label id="16">
                           <text-property name="text">FIRSTNAME</text-property>
                       </label>
                   </cell>
                   <cell id="17">
                       <label id="18">
                           <text-property name="text">EXTENSION</text-property>
                       </label>
                   </cell>
                   <cell id="19">
                       <label id="20">
                           <text-property name="text">EMAIL</text-property>
                       </label>
                   </cell>
                   <cell id="21">
                       <label id="22">
                           <text-property name="text">OFFICECODE</text-property>
                       </label>
                   </cell>
                   <cell id="23">
                       <label id="24">
                           <text-property name="text">REPORTSTO</text-property>
                       </label>
                   </cell>
                   <cell id="25">
                       <label id="26">
                           <text-property name="text">JOBTITLE</text-property>
                       </label>
                   </cell>
               </row>
           </header>
           <detail>
               <row id="27">
                   <cell id="28">
                       <data id="29">
                           <property name="resultSetColumn">EMPLOYEENUMBER</property>
                       </data>
                   </cell>
                   <cell id="30">
                       <data id="31">
                           <property name="resultSetColumn">LASTNAME</property>
                       </data>
                   </cell>
                   <cell id="32">
                       <data id="33">
                           <property name="resultSetColumn">FIRSTNAME</property>
                       </data>
                   </cell>
                   <cell id="34">
                       <data id="35">
                           <property name="resultSetColumn">EXTENSION</property>
                       </data>
                   </cell>
                   <cell id="36">
                       <data id="37">
                           <property name="resultSetColumn">EMAIL</property>
                       </data>
                   </cell>
                   <cell id="38">
                       <data id="39">
                           <property name="resultSetColumn">OFFICECODE</property>
                       </data>
                   </cell>
                   <cell id="40">
                       <data id="41">
                           <property name="resultSetColumn">REPORTSTO</property>
                       </data>
                   </cell>
                   <cell id="42">
                       <data id="43">
                           <property name="resultSetColumn">JOBTITLE</property>
                       </data>
                   </cell>
               </row>
           </detail>
           <footer>
               <row id="44">
                   <cell id="45">
                       <property name="colSpan">8</property>
                       <property name="rowSpan">1</property>
                       <extended-item extensionName="Chart" name="NewChart" id="81">
                           <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:data="http://www.birt.eclipse.org/ChartModelData" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
 <Type>Bar Chart</Type>
 <SubType>Side-by-side</SubType>
 <Block>
   <Children xsi:type="layout:TitleBlock">
     <Bounds>
       <Left>0.0</Left>
       <Top>0.0</Top>
       <Width>0.0</Width>
       <Height>0.0</Height>
     </Bounds>
     <Insets>
       <Top>3.0</Top>
       <Left>3.0</Left>
       <Bottom>3.0</Bottom>
       <Right>3.0</Right>
     </Insets>
     <Row>-1</Row>
     <Column>-1</Column>
     <Rowspan>-1</Rowspan>
     <Columnspan>-1</Columnspan>
     <Outline>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>0</Green>
         <Blue>0</Blue>
       </Color>
       <Visible>false</Visible>
     </Outline>
     <Visible>true</Visible>
     <Label>
       <Caption>
         <Value>Bar Chart Title</Value>
         <Font>
           <Size>16.0</Size>
           <Bold>true</Bold>
           <Alignment>
             <horizontalAlignment>Center</horizontalAlignment>
             <verticalAlignment>Center</verticalAlignment>
           </Alignment>
         </Font>
       </Caption>
       <Background xsi:type="attribute:ColorDefinition">
         <Transparency>0</Transparency>
         <Red>255</Red>
         <Green>255</Green>
         <Blue>255</Blue>
       </Background>
       <Outline>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>0</Green>
           <Blue>0</Blue>
         </Color>
       </Outline>
       <Insets>
         <Top>0.0</Top>
         <Left>2.0</Left>
         <Bottom>0.0</Bottom>
         <Right>3.0</Right>
       </Insets>
       <Visible>true</Visible>
     </Label>
   </Children>
   <Children xsi:type="layout:Plot">
     <Bounds>
       <Left>0.0</Left>
       <Top>0.0</Top>
       <Width>0.0</Width>
       <Height>0.0</Height>
     </Bounds>
     <Insets>
       <Top>3.0</Top>
       <Left>3.0</Left>
       <Bottom>3.0</Bottom>
       <Right>3.0</Right>
     </Insets>
     <Row>-1</Row>
     <Column>-1</Column>
     <Rowspan>-1</Rowspan>
     <Columnspan>-1</Columnspan>
     <Outline>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>0</Green>
         <Blue>0</Blue>
       </Color>
       <Visible>false</Visible>
     </Outline>
     <Visible>true</Visible>
     <HorizontalSpacing>5</HorizontalSpacing>
     <VerticalSpacing>5</VerticalSpacing>
     <ClientArea>
       <Outline>
         <Style>Solid</Style>
         <Thickness>0</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>0</Green>
           <Blue>0</Blue>
         </Color>
         <Visible>false</Visible>
       </Outline>
       <Insets>
         <Top>0.0</Top>
         <Left>0.0</Left>
         <Bottom>0.0</Bottom>
         <Right>0.0</Right>
       </Insets>
     </ClientArea>
   </Children>
   <Children xsi:type="layout:Legend">
     <Bounds>
       <Left>0.0</Left>
       <Top>0.0</Top>
       <Width>0.0</Width>
       <Height>0.0</Height>
     </Bounds>
     <Insets>
       <Top>3.0</Top>
       <Left>3.0</Left>
       <Bottom>3.0</Bottom>
       <Right>3.0</Right>
     </Insets>
     <Row>-1</Row>
     <Column>-1</Column>
     <Rowspan>-1</Rowspan>
     <Columnspan>-1</Columnspan>
     <Outline>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>0</Green>
         <Blue>0</Blue>
       </Color>
       <Visible>false</Visible>
     </Outline>
     <Visible>true</Visible>
     <ClientArea>
       <Outline>
         <Style>Solid</Style>
         <Thickness>0</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>0</Green>
           <Blue>0</Blue>
         </Color>
         <Visible>false</Visible>
       </Outline>
       <Insets>
         <Top>2.0</Top>
         <Left>2.0</Left>
         <Bottom>2.0</Bottom>
         <Right>2.0</Right>
       </Insets>
     </ClientArea>
     <Text>
       <Value></Value>
       <Font>
         <Alignment/>
       </Font>
     </Text>
     <Orientation>Vertical</Orientation>
     <Direction>Top_Bottom</Direction>
     <Separator>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>0</Green>
         <Blue>0</Blue>
       </Color>
       <Visible>true</Visible>
     </Separator>
     <Position>Right</Position>
     <ItemType>Series</ItemType>
     <Title>
       <Caption>
         <Value></Value>
         <Font>
           <Alignment/>
         </Font>
       </Caption>
       <Background xsi:type="attribute:ColorDefinition">
         <Transparency>0</Transparency>
         <Red>255</Red>
         <Green>255</Green>
         <Blue>255</Blue>
       </Background>
       <Outline>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>0</Green>
           <Blue>0</Blue>
         </Color>
         <Visible>false</Visible>
       </Outline>
       <Insets>
         <Top>0.0</Top>
         <Left>2.0</Left>
         <Bottom>0.0</Bottom>
         <Right>3.0</Right>
       </Insets>
       <Visible>false</Visible>
     </Title>
     <TitlePosition>Above</TitlePosition>
   </Children>
   <Bounds>
     <Left>0.0</Left>
     <Top>0.0</Top>
     <Width>570.75</Width>
     <Height>150.0</Height>
   </Bounds>
   <Insets>
     <Top>3.0</Top>
     <Left>3.0</Left>
     <Bottom>3.0</Bottom>
     <Right>3.0</Right>
   </Insets>
   <Row>-1</Row>
   <Column>-1</Column>
   <Rowspan>-1</Rowspan>
   <Columnspan>-1</Columnspan>
   <Outline>
     <Style>Solid</Style>
     <Thickness>1</Thickness>
     <Color>
       <Transparency>255</Transparency>
       <Red>0</Red>
       <Green>0</Green>
       <Blue>0</Blue>
     </Color>
     <Visible>false</Visible>
   </Outline>
   <Background xsi:type="attribute:ColorDefinition">
     <Transparency>255</Transparency>
     <Red>255</Red>
     <Green>255</Green>
     <Blue>255</Blue>
   </Background>
   <Visible>true</Visible>
 </Block>
 <Dimension>Two_Dimensional</Dimension>
 <Units>Points</Units>
 <SeriesThickness>10.0</SeriesThickness>
 <SampleData>
   <BaseSampleData>
     <DataSetRepresentation>A, B, C</DataSetRepresentation>
   </BaseSampleData>
   <OrthogonalSampleData>
     <DataSetRepresentation>5,4,12</DataSetRepresentation>
     <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
   </OrthogonalSampleData>
 </SampleData>
 <Interactivity/>
 <Axes>
   <Type>Text</Type>
   <Title>
     <Caption>
       <Value>X-Axis Title</Value>
       <Font>
         <Size>14.0</Size>
         <Bold>true</Bold>
         <Alignment>
           <horizontalAlignment>Center</horizontalAlignment>
           <verticalAlignment>Center</verticalAlignment>
         </Alignment>
       </Font>
     </Caption>
     <Background xsi:type="attribute:ColorDefinition">
       <Transparency>0</Transparency>
       <Red>255</Red>
       <Green>255</Green>
       <Blue>255</Blue>
     </Background>
     <Outline>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>0</Green>
         <Blue>0</Blue>
       </Color>
     </Outline>
     <Insets>
       <Top>0.0</Top>
       <Left>2.0</Left>
       <Bottom>0.0</Bottom>
       <Right>3.0</Right>
     </Insets>
     <Visible>false</Visible>
   </Title>
   <TitlePosition>Below</TitlePosition>
   <AssociatedAxes>
     <Type>Linear</Type>
     <Title>
       <Caption>
         <Value>Y-Axis Title</Value>
         <Font>
           <Size>14.0</Size>
           <Bold>true</Bold>
           <Alignment>
             <horizontalAlignment>Center</horizontalAlignment>
             <verticalAlignment>Center</verticalAlignment>
           </Alignment>
           <Rotation>90.0</Rotation>
         </Font>
       </Caption>
       <Background xsi:type="attribute:ColorDefinition">
         <Transparency>0</Transparency>
         <Red>255</Red>
         <Green>255</Green>
         <Blue>255</Blue>
       </Background>
       <Outline>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>0</Green>
           <Blue>0</Blue>
         </Color>
       </Outline>
       <Insets>
         <Top>0.0</Top>
         <Left>2.0</Left>
         <Bottom>0.0</Bottom>
         <Right>3.0</Right>
       </Insets>
       <Visible>false</Visible>
     </Title>
     <TitlePosition>Left</TitlePosition>
     <SeriesDefinitions>
       <Query>
         <Definition></Definition>
       </Query>
       <SeriesPalette>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>80</Red>
           <Green>166</Green>
           <Blue>218</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>242</Red>
           <Green>88</Green>
           <Blue>106</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>232</Red>
           <Green>172</Green>
           <Blue>57</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>255</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>64</Red>
           <Green>128</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>128</Green>
           <Blue>192</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>170</Red>
           <Green>85</Green>
           <Blue>85</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>128</Green>
           <Blue>0</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>192</Red>
           <Green>192</Green>
           <Blue>192</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>255</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>192</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>7</Red>
           <Green>146</Green>
           <Blue>94</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>128</Green>
           <Blue>255</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>128</Green>
           <Blue>192</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>255</Green>
           <Blue>255</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>128</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>128</Green>
           <Blue>192</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>128</Green>
           <Blue>192</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>0</Green>
           <Blue>255</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>64</Green>
           <Blue>64</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>128</Green>
           <Blue>64</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>80</Red>
           <Green>240</Green>
           <Blue>120</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>64</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>0</Green>
           <Blue>64</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>0</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>128</Green>
           <Blue>64</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>128</Red>
           <Green>128</Green>
           <Blue>128</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>128</Green>
           <Blue>255</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>64</Green>
           <Blue>0</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>0</Green>
           <Blue>0</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>255</Green>
           <Blue>255</Blue>
         </Entries>
         <Entries xsi:type="attribute:ColorDefinition">
           <Transparency>255</Transparency>
           <Red>255</Red>
           <Green>128</Green>
           <Blue>0</Blue>
         </Entries>
       </SeriesPalette>
       <Series xsi:type="type:BarSeries">
         <Visible>true</Visible>
         <Label>
           <Caption>
             <Value></Value>
             <Font>
               <Alignment/>
             </Font>
           </Caption>
           <Background xsi:type="attribute:ColorDefinition">
             <Transparency>0</Transparency>
             <Red>255</Red>
             <Green>255</Green>
             <Blue>255</Blue>
           </Background>
           <Outline>
             <Style>Solid</Style>
             <Thickness>1</Thickness>
             <Color>
               <Transparency>255</Transparency>
               <Red>0</Red>
               <Green>0</Green>
               <Blue>0</Blue>
             </Color>
             <Visible>false</Visible>
           </Outline>
           <Insets>
             <Top>0.0</Top>
             <Left>2.0</Left>
             <Bottom>0.0</Bottom>
             <Right>3.0</Right>
           </Insets>
           <Visible>false</Visible>
         </Label>
         <DataDefinition>
           <Definition>reportContext.getGlobalVariable(&quot;totalPageCount&quot;)</Definition>
         </DataDefinition>
         <SeriesIdentifier>Series 1</SeriesIdentifier>
         <DataPoint>
           <Components>
             <Type>Orthogonal_Value</Type>
           </Components>
           <Separator>, </Separator>
         </DataPoint>
         <LabelPosition>Outside</LabelPosition>
         <Stacked>false</Stacked>
         <Riser>Rectangle</Riser>
       </Series>
       <Grouping>
         <Enabled>false</Enabled>
         <GroupingInterval>1.0</GroupingInterval>
         <GroupType>Text</GroupType>
         <AggregateExpression>Sum</AggregateExpression>
       </Grouping>
     </SeriesDefinitions>
     <Orientation>Vertical</Orientation>
     <LineAttributes>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Visible>true</Visible>
     </LineAttributes>
     <Label>
       <Caption>
         <Value></Value>
         <Font>
           <Alignment/>
         </Font>
       </Caption>
       <Background xsi:type="attribute:ColorDefinition">
         <Transparency>0</Transparency>
         <Red>255</Red>
         <Green>255</Green>
         <Blue>255</Blue>
       </Background>
       <Outline>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>0</Red>
           <Green>0</Green>
           <Blue>0</Blue>
         </Color>
       </Outline>
       <Insets>
         <Top>0.0</Top>
         <Left>2.0</Left>
         <Bottom>0.0</Bottom>
         <Right>3.0</Right>
       </Insets>
       <Visible>true</Visible>
     </Label>
     <LabelPosition>Left</LabelPosition>
     <MajorGrid>
       <LineAttributes>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>196</Red>
           <Green>196</Green>
           <Blue>196</Blue>
         </Color>
         <Visible>false</Visible>
       </LineAttributes>
       <TickStyle>Across</TickStyle>
       <TickAttributes>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>196</Red>
           <Green>196</Green>
           <Blue>196</Blue>
         </Color>
         <Visible>true</Visible>
       </TickAttributes>
     </MajorGrid>
     <MinorGrid>
       <LineAttributes>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>225</Red>
           <Green>225</Green>
           <Blue>225</Blue>
         </Color>
         <Visible>false</Visible>
       </LineAttributes>
       <TickStyle>Across</TickStyle>
       <TickAttributes>
         <Style>Solid</Style>
         <Thickness>1</Thickness>
         <Color>
           <Transparency>255</Transparency>
           <Red>225</Red>
           <Green>225</Green>
           <Blue>225</Blue>
         </Color>
         <Visible>false</Visible>
       </TickAttributes>
     </MinorGrid>
     <Scale>
       <MinorGridsPerUnit>5</MinorGridsPerUnit>
     </Scale>
     <Origin>
       <Type>Min</Type>
       <Value xsi:type="data:NumberDataElement">
         <Value>0.0</Value>
       </Value>
     </Origin>
     <PrimaryAxis>true</PrimaryAxis>
     <Percent>false</Percent>
   </AssociatedAxes>
   <SeriesDefinitions>
     <Query>
       <Definition></Definition>
     </Query>
     <SeriesPalette>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>80</Red>
         <Green>166</Green>
         <Blue>218</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>242</Red>
         <Green>88</Green>
         <Blue>106</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>232</Red>
         <Green>172</Green>
         <Blue>57</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>255</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>64</Red>
         <Green>128</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>128</Green>
         <Blue>192</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>170</Red>
         <Green>85</Green>
         <Blue>85</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>128</Green>
         <Blue>0</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>192</Red>
         <Green>192</Green>
         <Blue>192</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>255</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>192</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>7</Red>
         <Green>146</Green>
         <Blue>94</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>128</Green>
         <Blue>255</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>128</Green>
         <Blue>192</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>255</Green>
         <Blue>255</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>128</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>128</Green>
         <Blue>192</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>128</Green>
         <Blue>192</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>0</Green>
         <Blue>255</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>64</Green>
         <Blue>64</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>128</Green>
         <Blue>64</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>80</Red>
         <Green>240</Green>
         <Blue>120</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>64</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>0</Green>
         <Blue>64</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>0</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>128</Green>
         <Blue>64</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>128</Red>
         <Green>128</Green>
         <Blue>128</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>128</Green>
         <Blue>255</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>64</Green>
         <Blue>0</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>0</Green>
         <Blue>0</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>255</Green>
         <Blue>255</Blue>
       </Entries>
       <Entries xsi:type="attribute:ColorDefinition">
         <Transparency>255</Transparency>
         <Red>255</Red>
         <Green>128</Green>
         <Blue>0</Blue>
       </Entries>
     </SeriesPalette>
     <Series>
       <Visible>true</Visible>
       <Label>
         <Caption>
           <Value></Value>
           <Font>
             <Alignment/>
           </Font>
         </Caption>
         <Background xsi:type="attribute:ColorDefinition">
           <Transparency>0</Transparency>
           <Red>255</Red>
           <Green>255</Green>
           <Blue>255</Blue>
         </Background>
         <Outline>
           <Style>Solid</Style>
           <Thickness>1</Thickness>
           <Color>
             <Transparency>255</Transparency>
             <Red>0</Red>
             <Green>0</Green>
             <Blue>0</Blue>
           </Color>
           <Visible>false</Visible>
         </Outline>
         <Insets>
           <Top>0.0</Top>
           <Left>2.0</Left>
           <Bottom>0.0</Bottom>
           <Right>3.0</Right>
         </Insets>
         <Visible>false</Visible>
       </Label>
       <DataDefinition>
         <Definition>&quot;Page Count&quot;</Definition>
       </DataDefinition>
       <SeriesIdentifier></SeriesIdentifier>
       <DataPoint>
         <Components>
           <Type>Orthogonal_Value</Type>
         </Components>
         <Separator>, </Separator>
       </DataPoint>
       <LabelPosition>Outside</LabelPosition>
       <Stacked>false</Stacked>
     </Series>
     <Grouping>
       <Enabled>false</Enabled>
       <GroupingInterval>0.0</GroupingInterval>
       <GroupType>Text</GroupType>
       <AggregateExpression>Sum</AggregateExpression>
     </Grouping>
     <SortKey/>
   </SeriesDefinitions>
   <Orientation>Horizontal</Orientation>
   <LineAttributes>
     <Style>Solid</Style>
     <Thickness>1</Thickness>
     <Visible>true</Visible>
   </LineAttributes>
   <Label>
     <Caption>
       <Value></Value>
       <Font>
         <Alignment/>
       </Font>
     </Caption>
     <Background xsi:type="attribute:ColorDefinition">
       <Transparency>0</Transparency>
       <Red>255</Red>
       <Green>255</Green>
       <Blue>255</Blue>
     </Background>
     <Outline>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>0</Red>
         <Green>0</Green>
         <Blue>0</Blue>
       </Color>
     </Outline>
     <Insets>
       <Top>0.0</Top>
       <Left>2.0</Left>
       <Bottom>0.0</Bottom>
       <Right>3.0</Right>
     </Insets>
     <Visible>true</Visible>
   </Label>
   <LabelPosition>Below</LabelPosition>
   <MajorGrid>
     <LineAttributes>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>196</Red>
         <Green>196</Green>
         <Blue>196</Blue>
       </Color>
       <Visible>false</Visible>
     </LineAttributes>
     <TickStyle>Across</TickStyle>
     <TickAttributes>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>196</Red>
         <Green>196</Green>
         <Blue>196</Blue>
       </Color>
       <Visible>true</Visible>
     </TickAttributes>
   </MajorGrid>
   <MinorGrid>
     <LineAttributes>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>225</Red>
         <Green>225</Green>
         <Blue>225</Blue>
       </Color>
       <Visible>false</Visible>
     </LineAttributes>
     <TickStyle>Across</TickStyle>
     <TickAttributes>
       <Style>Solid</Style>
       <Thickness>1</Thickness>
       <Color>
         <Transparency>255</Transparency>
         <Red>225</Red>
         <Green>225</Green>
         <Blue>225</Blue>
       </Color>
       <Visible>false</Visible>
     </TickAttributes>
   </MinorGrid>
   <Scale>
     <MinorGridsPerUnit>5</MinorGridsPerUnit>
   </Scale>
   <Origin>
     <Type>Min</Type>
     <Value xsi:type="data:NumberDataElement">
       <Value>0.0</Value>
     </Value>
   </Origin>
   <PrimaryAxis>true</PrimaryAxis>
   <CategoryAxis>true</CategoryAxis>
   <Percent>false</Percent>
 </Axes>
 <Orientation>Vertical</Orientation>
 <UnitSpacing>50.0</UnitSpacing>
 <Rotation/>
</model:ChartWithAxes>
]]></xml-property>
                           <property name="outputFormat">PNG</property>
                           <property name="height">2.0833333333333335in</property>
                           <property name="width">7.927083333333333in</property>
                       </extended-item>
                   </cell>
               </row>
           </footer>
       </table>
   </body>
</report>

BIRT: Creating an SWT Emitter

I had shown a proof of concept of this idea at EclipseCon, albeit in a very simplified manner by coupling an emitter to a TreeView component in SWT. But this guy took it a step further and has taken it a step further and has an emitter that outputs directly to an SWT table. This opens the door for all sorts of cool opportunities, such as customized action handlers for interacting directly with SWT components.

Not sure why I didn't think of passing in the composite as a render option as I went about it in a different way, but this is definitely cool stuff. With a little modification to handle groups, you can do all sorts of cool interactive report interfaces using RCP or RAP :)

Technology Musing: Devices that Have Changed My Adult Life

This week, me and my wife went on a cruise. As an experiment, I decided that while I was on this cruise, I wouldn’t use any technical gadgets. I didn’t bring my laptop, turned off my cell phone, and only used my iPod when I went to the gym. So while I had this opportunity to get away from technology, I had the opportunity to reflect on the gadgets that have made the biggest impact on my recent life. By no means is this a reflection of my life as a whole, because things like the original NES aren’t on here, just a relfection of devices from the last 10 years or that have changed my outlook on technology or my life in some significant way.

IPod:
About 5 years ago I was a PC fan boy. I had that mentality for years, dating back to the early 90’s. It was so rabid in fact that I laughed when Apple announced the launch of the iPod. I laughed that this feeble device was Apples attempt to stay relevant. I wasn’t sold on Macs. I thought the iMac was a “cute” little device, and I did like the Adobe suite of software, but I wouldn’t even consider it on anything except a PC.

At the time of its arrival, there were other MP3 players out on the market. In fact, I had a cute little 256M player that I worked out with up until 2003, with the thought of an iPod so distant, that it was laughable. All that changed in 2006, when I broke down and bought my first iPod Video. Ever since, this little device has changed my life.

When I first bought it, I was able to load up every single MP3 I owned, with room to spare for tons of movies which I used to work out. Previously I had a PC I configured to “hide” on a network to provide music for everyone at work. All that fit on a 30 Gig hard drive. My new iPod fit all of this, plus movies. It was awesome.

So how had this device changed my life. Quite simply, since that first iPod video, I bought a iPod Nano for my workouts, and when that died two weeks ago, I broke down and bought an iPod touch. Now the Touch has all my flashcards for studying various subjects, podcasts, movies and videos (especially my P90X videos for working out, Kenpo 5.0 videos, and Royler Gracies takedown DVD’s), not to mention my music collection. I still have the iPod video sitting in a video unit. I store my contacts and calendar for casual use on it.

Out of everything, I think the iPod has been by far the single most life changing device I own. I’ve learned a second language because of my iPod. I no longer listen to commercial radio because of my iPod. I use Nike+ as a motivation to run everyday. In fact, I’ve lost almost 80 pounds over the past 3 years, mostly due to listening to music while running with my iPod.

The iPod changed my perspective so much, that I convinced my wife to buy a Macbook, and I will probably end up buying one of my own. Now consider that, 5 years ago, I wouldn’t touch a Mac, 5 years later I’ve bought 5 Apple products (3 iPods, 1 iPod for my wife, and her Macbook). I’d have to say, that’s a pretty big change.

HTC Touch.

Before I bought a smart phone a few years ago, I relied on some very bare bones PC’s. It wasn’t until I started to hack my Razr that I started to think about getting a phone that did “just a little bit more”. I had played around with Pocket PC’s for years, but I just didn’t get that into them because it was just a big bother to carry around multiple devices. All that changed when I bought my XV6900.

Now, this device has become the digital center of my life, more so than my laptop. I’ve become one of those obnoxious people who are constantly texting, checking emails, and can’t seem to pry myself away from it.

I use it when I’m in airports and need Internet access. I use it for business and personal calls. I keep track of my daily schedule, upcoming events, and contacts with it. I play chess on it. And its always attached to my hip. I don’t even have a land line now because of this device.

Laptop:

Another one of those 5 years ago changes. 5 years ago I was anchored to a desk by a big old PC. Since I turned consultant, I couldn’t imagine going back to a PC. I like the freedom of being able to work anywhere, and staying connected to all my devices with a handful of cables. I like that option of being able to dock at my home office, and having a dual monitor setup off of a single laptop, then being able to pick up, go to my living room, and plop in front of the TV and work at the same time. This was freedom that wasn’t afforded with the desk anchor, and I think my productivity suffered as a result of being stuck in one place. Now, whenever I have an idea, I can just open my laptop and work on it.

George Foreman Grill:

Yeah, I’m serious. This is definitely a gadget that changed my life. Used to be I was a real fast food kind of guy. The George Foreman Grill actually changed that. Now, I prefer to cook at home since it takes only about 10 minutes to grill a steak, without a lot of the fat. With the combination of the Reveo Marivac Food Tumbler, I eat better, healthier than I ever did before. I keep track of recipes, marinades, and wines that go good with them. Plus, its seems to REALLY impress my wifes friends that I can cook, so keep that in mind, chicks dig guys who can cook.

Xbox 360:

When I was a kid, I was a video game junky. I mean, I was really into video games, which is in part why I had such a horrible physique into young adulthood. I turned away from video games for several years, but was re-introduced with the Xbox and the PS2. So, up until that point, I was just a solo player. Since the 360’s release, I couldn’t imagine a game that didn’t have multiplayer capabilities. The 360 has become the media center for the whole house, with its Netflix movie hookup, ability to play DVD’s, music, hook up to the MP3 server in our house, movie rentals from the 360 video service, and so forth. In fact, the only thing my PS3 does is play blue ray, for some reason it just hasn’t caught on as a gaming device in my house hold. A huge change in moving the media device from the PC to the living room for me.