Sheldon Glickler wrote:
Sheldon Glickler wrote:
I followed Jay Bryant's advice and structured my xsl file according to
his example. I got it to work well, but in saving things I overwrote
what I had done. I recreated it -- almost. I now have a few questions;
1 - In the attached files, why are no business units showing up? I
have looked and looked but can't figure out why they don't.
2 - How do I get the background color to fill the entire cell and not
just the text background. (When I had the business units data showing
up, the header cell backgrounds filled the entire space).
3 - When the business data did appear earlier, and I viewed at 100%,
the borders did not run into each other and left a small space between
them. How do I force the borders to join?
Thanks for any help.
I figured out what the answer to (1) is. I needed to bracket the data
in the xml with tags to match the select in the xsl.
I have attached the xsl and xml tags. They generate what I am now
asking about. Viewing the output at 100%:
1 - How do I fill the backgrounds of the cells of the third line (the
last header line).
2 - How can I get the borders top join? Look at the line between the
last header line and the first business unit header line. Also, between
the other lines. the intent here is for the borders to be with 1pt of .5pt.
3 - Why doesn't the border show when cells are empty in the data area?
4 - Why does it look like the vertical borders on the last line extend
beyond the bottom of the line?
<?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="15pt"
margin-right="20pt"
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>
<fo:table-cell background-color="{title_bg_color}" >
<fo:block text-align="center" wrap-option="no-wrap" font-size="{fontsize}"
line-height="{linespace}" 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" border-collapse="collapse" 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 wrap-option="{../wrap}">
<fo:block text-align="{align}" font-size="{fontsize}" border="{border}"
font-weight="{../fontweight}" color="{color}" background-color='{bg_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" border-collapse="collapse" space-before="0pt"
space-after="0pt" border="{border}">
<fo:table-column column-width='{fullwidth}'/>
<fo:table-body >
<fo:table-row>
<xsl:variable name="bu_bg_color" select="bu_bg_color" />
<xsl:variable name="bu_color" select="bu_color" />
<fo:table-cell background-color='{bu_bg_color}'>
<fo:block text-align="start" wrap-option="{wrap}" font-size="{fontsize}"
line-height="{linespace}" font-weight="bold" color='{bu_color}'
border="{border}">
<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" border-collapse="collapse" space-before="0pt"
space-after="0pt" background-color="{bg_color}"
line-height="{linespace}" >
<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>
<xsl:for-each select="bu_item">
<fo:table-cell>
<fo:block text-align="{align}" wrap-option="no-wrap" font-size="{fontsize}"
font-weight="{fontweight}" color="{color}" border="{borderline}">
<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" border-collapse="collapse" space-before="0pt"
space-after="0pt" line-height="{linespace}">
<xsl:for-each select="sum_col_width">
<fo:table-column column-width="{value}"/>
</xsl:for-each>
<fo:table-body >
<fo:table-row>
<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>rgb(255,190,160)</bg_color>
<title_bg_color>darkgray</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>10pt</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>darkgray</bg_color>
<color>black</color>
<fontsize>8pt</fontsize>
<border>solid 1pt</border>
<align>end</align>
</hdr_itm>
<hdr_itm>
<value>Reprographics</value>
<bg_color>rgb(255,190,160)</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Cylinder Gas</value>
<bg_color>darkgray</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>LTL Freight</value>
<bg_color>rgb(255,190,160)</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Office Supplies</value>
<bg_color>darkgray</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>rgb(255,190,160)</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>darkgray</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>rgb(255,190,160)</bg_color>
<color>black</color>
<fontsize>6pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>Direct Material</value>
<bg_color>darkgray</bg_color>
<color>black</color>
<fontsize>6pt</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>120pt</value></colsize>
<colsize><value>60pt</value></colsize>
<colsize><value>60pt</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>8pt</fontsize>
<color>black</color>
<bg_color>rgb(255,190,160)</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>RESPONSIBILITY</value>
<fontsize>8pt</fontsize>
<align>start</align>
<color>black</color>
<bg_color>rgb(255,190,160)</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>VICE PRESIDENT</value>
<fontsize>8pt</fontsize>
<align>start</align>
<color>black</color>
<bg_color>rgb(255,190,160)</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>LOG / FIN CO.</value>
<fontsize>8pt</fontsize>
<color>black</color>
<align>center</align>
<bg_color>rgb(255,190,160)</bg_color>
<border>solid .5pt</border>
</hdr_itm>
<hdr_itm>
<value>DIM.</value>
<fontsize>8pt</fontsize>
<color>black</color>
<bg_color>rgb(255,190,160)</bg_color>
<border>solid .5pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>IKON PERCENT OF COMPLIANCE</value>
<color>black</color>
<bg_color>rgb(255,190,160)</bg_color>
<fontsize>8pt</fontsize>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>AIRGAS PERCENT OF COMPLIANCE</value>
<fontsize>8pt</fontsize>
<bg_color>darkgray</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>8pt</fontsize>
<bg_color>rgb(255,190,160)</bg_color>
<color>black</color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>STAPLES PERCENT OF COMPLIANCE</value>
<fontsize>8pt</fontsize>
<color>black</color>
<bg_color>darkgray</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>STANDARD CAR TRUCK PERCENT OF COMPLIANCE</value>
<fontsize>8pt</fontsize>
<color>black</color>
<bg_color>rgb(255,190,160)</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>8pt</fontsize>`
<bg_color>darkgray</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>PITTSBURGH PINS PERCENT OF COMPLIANCE</value>
<color>black</color>
<fontsize>8pt</fontsize>
<bg_color>rgb(255,190,160)</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
<hdr_itm>
<value>RAILROAD FRICTION PRODUCTS PERCENT OF COMPLIANCE</value>
<fontsize>8pt</fontsize>
<color>black</color>
<bg_color>darkgray</bg_color>
<border>solid 1pt</border>
<align>center</align>
</hdr_itm>
</headerline>
</header>
<business_units>
<bu>
<bus_header>
<bu_bg_color>rgb(255,190,160)</bu_bg_color>
<linespace>10pt</linespace>
<bu_color>maroon</bu_color>
<bu_title>CORPORATE</bu_title>
<fullwidth>700pt</fullwidth>
<border>solid 1pt</border>
<fontsize>8pt</fontsize>
<wrap>no-wrap</wrap>
</bus_header>
<bus_data>
<bu_col_width><value>120pt</value></bu_col_width>
<bu_col_width><value>60pt</value></bu_col_width>
<bu_col_width><value>60pt</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>
</bu_item>
<bu_item>
<value>George Smith</value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
</bu_item>
<bu_item>
<value> </value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
</bu_item>
<bu_item>
<value>100</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
</bu_item>
<bu_item>
<value>19815</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</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>
</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> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</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>
</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> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</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> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</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>
</bu_item>
<bu_item>
<value>Frank Corley</value>
<align>start</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</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>
</bu_item>
<bu_item>
<value>100</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</color>
</bu_item>
<bu_item>
<value>19830</value>
<align>center</align>
<fontweight>normal</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid .5pt</borderline>
<color>black</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> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</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>0.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</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> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</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> </value>
<align>center</align>
<fontweight>bold</fontweight>
<fontsize>6pt</fontsize>
<borderline>solid 1pt</borderline>
<color>black</color>
</bu_item>
</bu_line>
</bus_data>
<bus_summary>
<bu_bg_color>rgb(255,190,160)</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>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>76.24%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>0.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>100.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value>100.00%</value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</fontsize>
<borderline>solid 1pt</borderline>
</summary_item>
<summary_item>
<value></value>
<align>center</align>
<fontweight>bold</fontweight>
<color>black</color>
<fontsize>8pt</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]
