Jay Bryant wrote:
Hi, Sheldon,
1 - I am using number-columns-spanned in order to use the same
template with sub-section headings and totals. I use the parameter
<merge>. For the sub-titles, I give it a value of 13 (all the
columns). For the sub-section totals, I give the first one a value of
5, followed by eight cells with a value of 1. It all worked, but I
get one blank for the number of columns spanned and one blank for the
background color. I isolated it to the following in the xml file:
<bu_line>
<bu_item>
<value>TRACKING SALES</value>
<align>start</align>
<borderline>solid .5pt</borderline>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<color>black</color>
<merge>13</merge>
<bg_color>#FFFF99</bg_color>
</bu_item>
</bu_line>
If I remove that block, then there are no errors. In the xsl, it uses
those keys for every line in the business bu_tiem section, with no
additional errors. I'm stumped. It works, but it isn't "clean".
Without seeing your XSL for this bit, it's hard to provide a for-sure
answer. My initial thought is that you're not checking for the existence
I am posting the files. No, I don't do the checking, but this is the
only <bu_line> that gives a problem and they all go through the same code.
Thank you for being so exceedingly helpful. Now my REAL effort begins.
I have to do a log of php coding in order to gather the data and
generate the xml files that use this xsl file.
<?xml version="1.0"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:fo="http://www.w3.org/1999/XSL/Format";>
<xsl:template match="print-compliance">
<xsl:processing-instruction name="cocoon-format">type="text/xslfo"
</xsl:processing-instruction>
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format";>
<fo:layout-master-set>
<fo:simple-page-master master-name="compliance-form"
margin-top="50pt"
margin-bottom="50pt"
margin-left="5pt"
margin-right="5pt"
page-height="8.5in"
page-width="11in">
<fo:region-body margin-bottom="1pt"/>
</fo:simple-page-master>
</fo:layout-master-set>
<fo:page-sequence master-reference="compliance-form">
<fo:flow flow-name="xsl-region-body">
<xsl:apply-templates select="header" />
<xsl:apply-templates select="business_units" />
</fo:flow>
</fo:page-sequence>
</fo:root>
</xsl:template>
<xsl:template match="header">
<fo:table table-layout="fixed" border-collapse="collapse" space-before="0pt"
border-style="none">
<xsl:variable name="product_list" select="product_list" />
<fo:table-column column-width="{fullwidth}"/>
<fo:table-body >
<fo:table-row line-height="{linespace}" >
<fo:table-cell background-color="{title_bg_color}" >
<fo:block text-align="center" wrap-option="no-wrap" font-size="{fontsize}"
font-weight="{fontweight}"
color="{color}" border="{border}">
<xsl:value-of select="report_name"/>
</fo:block>
</fo:table-cell>
</fo:table-row>
</fo:table-body>
</fo:table>
<xsl:apply-templates select="headerline"/>
</xsl:template>
<xsl:template match="headerline">
<fo:table table-layout="fixed" space-before="0pt">
<xsl:for-each select="colsize">
<fo:table-column column-width="{value}"/>
</xsl:for-each>
<fo:table-body>
<fo:table-row line-height="{linespace}" display-align="{vertical}">
<xsl:apply-templates select="hdr_itm"/>
</fo:table-row>
</fo:table-body>
</fo:table>
</xsl:template>
<xsl:template match="hdr_itm">
<fo:table-cell background-color='{bg_color}' border="{border}">
<fo:block text-align="{align}" font-size="{fontsize}" wrap-option="{../wrap}"
font-weight="{../fontweight}" color="{color}">
<xsl:value-of select="value"/>
</fo:block>
</fo:table-cell>
</xsl:template>
<xsl:template match="business_units">
<xsl:for-each select="bu">
<xsl:apply-templates select="bus_header"/>
<xsl:apply-templates select="bus_data"/>
<xsl:apply-templates select="bus_summary"/>
</xsl:for-each>
</xsl:template>
<xsl:template match="bus_header">
<fo:table table-layout="fixed" space-before="0pt" space-after="0pt">
<fo:table-column column-width='{fullwidth}'/>
<fo:table-body >
<fo:table-row line-height="{linespace}">
<fo:table-cell background-color='{bu_bg_color}' border="{border}">
<fo:block text-align="start" wrap-option="{wrap}" font-size="{fontsize}"
font-weight="bold" color='{bu_color}'>
<xsl:value-of select="bu_title"/>
</fo:block>
</fo:table-cell>
</fo:table-row>
</fo:table-body>
</fo:table>
</xsl:template>
<xsl:template match="bus_data">
<fo:table table-layout="fixed" space-before="0pt" space-after="0pt">
<xsl:for-each select="bu_col_width">
<fo:table-column column-width="{value}"/>
</xsl:for-each>
<fo:table-body>
<xsl:for-each select="bu_line">
<fo:table-row line-height="{../linespace}" >
<xsl:for-each select="bu_item">
<fo:table-cell background-color="{bg_color}" number-columns-spanned="{merge}"
border="{borderline}">
<fo:block text-align="{align}" wrap-option="no-wrap" font-size="{fontsize}"
font-weight="{fontweight}" color="{color}">
<xsl:value-of select="value"/>
</fo:block>
</fo:table-cell>
</xsl:for-each>
</fo:table-row>
</xsl:for-each>
</fo:table-body>
</fo:table>
</xsl:template>
<xsl:template match="bus_summary">
<fo:table table-layout="fixed" space-before="0pt" space-after="0pt" >
<xsl:for-each select="sum_col_width">
<fo:table-column column-width="{value}"/>
</xsl:for-each>
<fo:table-body >
<fo:table-row line-height="{linespace}">
<xsl:for-each select="summary_item">
<fo:table-cell background-color='{../bu_bg_color}' border="solid {borderline}">
<fo:block text-align="{align}" wrap-option="no-wrap" font-size="{fontsize}"
font-weight="{fontweight}" color="{color}">
<xsl:value-of select="value"/>
</fo:block>
</fo:table-cell>
</xsl:for-each>
</fo:table-row>
</fo:table-body>
</fo:table>
</xsl:template>
</xsl:stylesheet>
<?xml version="1.0" encoding="utf-8"?>
<print-compliance>
<header>
<bg_color>#FFCC99</bg_color>
<title_bg_color>lightgray</title_bg_color>
<fontweight>bold</fontweight>
<color>maroon</color>
<report_name>U.S. - NOVEMBER 2007 CONTRACT NON - COMPLIANCE REPORT</report_name>
<fullwidth>700pt</fullwidth>
<fontsize>8pt</fontsize>
<linespace>15pt</linespace>
<border>none</border>
<headerline>
<linespace>10pt</linespace>
<fontweight>bold</fontweight>
<wrap>wrap</wrap>
<vertical>center</vertical>
<colsize><value>300pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<hdr_itm>
<value>COMMODITY </value>
<bg_color>lightgray</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>end</align>
</hdr_itm>
<hdr_itm>
<value>Reprographics</value>
<bg_color>#FFCC99</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Cylinder Gas</value>
<bg_color>lightgray</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>LTL Freight</value>
<bg_color>#FFCC99</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Office Supplies</value>
<bg_color>lightgray</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>#FFCC99</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>lightgray</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>#FFCC99</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>lightgray</bg_color>
<color>black</color>
<fontsize>5pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
</headerline>
<headerline>
<linespace>8pt</linespace>
<fontweight>bold</fontweight>
<wrap>wrap</wrap>
<vertical>after</vertical>
<colsize><value>110pt</value></colsize>
<colsize><value>60pt</value></colsize>
<colsize><value>70pt</value></colsize>
<colsize><value>30pt</value></colsize>
<colsize><value>30pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<colsize><value>50pt</value></colsize>
<hdr_itm>
<value>LOCATION</value>
<align>start</align>
<fontsize>6pt</fontsize>
<color>black</color>
<bg_color>lightgray</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>RESPONSIBILITY</value>
<fontsize>6pt</fontsize>
<align>start</align>
<color>black</color>
<bg_color>lightgray</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>VICE PRESIDENT</value>
<fontsize>6pt</fontsize>
<align>start</align>
<color>black</color>
<bg_color>lightgray</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>LOG / FIN CO.</value>
<fontsize>6pt</fontsize>
<color>black</color>
<align>center</align>
<bg_color>lightgray</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>DIM.</value>
<fontsize>6pt</fontsize>
<color>black</color>
<bg_color>lightgray</bg_color>
<border>solid .5pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>IKON PERCENT OF COMPLIANCE</value>
<color>black</color>
<bg_color>#FFCC99</bg_color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>AIRGAS PERCENT OF COMPLIANCE</value>
<fontsize>6pt</fontsize>
<bg_color>lightgray</bg_color>
<color>black</color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>COMBINED LTL FREIGHT PERCENT OF COMPLIANCE</value>
<fontsize>6pt</fontsize>
<bg_color>#FFCC99</bg_color>
<color>black</color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>STAPLES PERCENT OF COMPLIANCE</value>
<fontsize>6pt</fontsize>
<color>black</color>
<bg_color>lightgray</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>STANDARD CAR TRUCK PERCENT OF COMPLIANCE</value>
<fontsize>6pt</fontsize>
<color>black</color>
<bg_color>#FFCC99</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>NEW YORK AIR BRAKE PERCENT OF COMPLIANCE</value>
<color>black</color>
<fontsize>6pt</fontsize>`
<bg_color>lightgray</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>PITTSBURGH PINS PERCENT OF COMPLIANCE</value>
<color>black</color>
<fontsize>6pt</fontsize>
<bg_color>#FFCC99</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>RAILROAD FRICTION PRODUCTS PERCENT OF COMPLIANCE</value>
<fontsize>6pt</fontsize>
<color>black</color>
<bg_color>lightgray</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
</headerline>
</header>
<business_units>
<bu>
<bus_header>
<bu_bg_color>#FFCC99</bu_bg_color>
<linespace>10pt</linespace>
<bu_color>maroon</bu_color>
<bu_title>CORPORATE</bu_title>
<fullwidth>700pt</fullwidth>
<border>solid 1pt</border>
<fontsize>6pt</fontsize>
<wrap>no-wrap</wrap>
</bus_header>
<bus_data>
<bu_col_width><value>110pt</value></bu_col_width>
<bu_col_width><value>60pt</value></bu_col_width>
<bu_col_width><value>70pt</value></bu_col_width>
<bu_col_width><value>30pt</value></bu_col_width>
<bu_col_width><value>30pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bg_color>white</bg_color>
<linespace>8pt</linespace>
<bu_line>
<bu_item>
<value> Admin - Corporate</value>
<align>start</align>
<borderline>solid .5pt</borderline>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>.5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>George Smith</value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>100</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>19815</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>0.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>0.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
</bu_line>
<bu_line>
<bu_item>
<value> Safety - Corporate</value>
<align>start</align>
<borderline>solid .5pt</borderline>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>Frank Corley</value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>Ed Oneal</value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>100</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>19830</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>0.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
</bu_line>
</bus_data>
<bus_summary>
<bu_bg_color>#FFCC99</bu_bg_color>
<linespace>10pt</linespace>
<sum_col_width><value>300pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<summary_item>
<value>TOTAL COMPLIANCE FOR CORPORATE</value>
<align>start</align>
<fontweight>bold</fontweight>
<color>maroon</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>76.24%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>0.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>100.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>100.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
</bus_summary>
</bu>
<bu>
<bus_header>
<bu_bg_color>#FFCC99</bu_bg_color>
<linespace>10pt</linespace>
<bu_color>maroon</bu_color>
<bu_title>ENGINEERING AND TRACK SERVICES (ETS)</bu_title>
<fullwidth>700pt</fullwidth>
<border>solid 1pt</border>
<fontsize>6pt</fontsize>
<wrap>no-wrap</wrap>
</bus_header>
<bus_data>
<bu_col_width><value>110pt</value></bu_col_width>
<bu_col_width><value>60pt</value></bu_col_width>
<bu_col_width><value>70pt</value></bu_col_width>
<bu_col_width><value>30pt</value></bu_col_width>
<bu_col_width><value>30pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bu_col_width><value>50pt</value></bu_col_width>
<bg_color>white</bg_color>
<linespace>8pt</linespace>
<bu_line>
<bu_item>
<value>TOTAL COMPLIANCE FOR ALL TRACK</value>
<align>start</align>
<borderline>solid .5pt</borderline>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<color>black</color>
<merge>5</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value>100%</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value>100%</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value>90.73%</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
</bu_line>
<bu_line>
<bu_item>
<value>TRACKWORK SALES</value>
<align>start</align>
<borderline>solid .5pt</borderline>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<color>black</color>
<merge>13</merge>
<bg_color>#FFFF99</bg_color>
</bu_item>
</bu_line>
<bu_line>
<bu_item>
<value> Trackwork Sales Admin</value>
<align>start</align>
<borderline>solid .5pt</borderline>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>Patrick Jansen</value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>Patrick Jansen</value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>100</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value>29075</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
</bu_item>
<bu_item>
<value>70.34%</value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#FFFFFF</bg_color>
</bu_item>
</bu_line>
<bu_line>
<bu_item>
<value>TOTAL COMPLIANCE FOR TRACKWORK SALES</value>
<align>start</align>
<borderline>solid .5pt</borderline>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<color>black</color>
<merge>5</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value> </value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<bg_color>#CCFFCC</bg_color>
<merge>1</merge>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value>70.34%</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value>90.69%</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
<bu_item>
<value></value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
<merge>1</merge>
<bg_color>#CCFFCC</bg_color>
</bu_item>
</bu_line>
</bus_data>
<bus_summary>
<bu_bg_color>#FFCC99</bu_bg_color>
<linespace>10pt</linespace>
<sum_col_width><value>300pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<sum_col_width><value>50pt</value></sum_col_width>
<summary_item>
<value>TOTAL FOR ENGINEERING AND TRACKWORK SALES (ETS)</value>
<align>start</align>
<fontweight>bold</fontweight>
<color>maroon</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>38.81%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>98.31%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>88.89%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>96.01%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
</bus_summary>
</bu>
</business_units>
</print-compliance>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
