>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries

>Thread Prev - Re: table
[Thread Next]
Re: table

From: a@-----------.---------.---
To: NULL
Date: 4/8/2005 3:17:00 PM
BigD:

Thanks for the help.

I've tried a number of things to no avail and at this point I'll take your 
suggestion to restructure the elements.  My brother always reminds me that if 
it works, working is more important than elegance.

The one thing that I haven't done yet is try different parsers, so MAYBE 
I'll try that at some point.
-----------------------------------------------------------------------------------------
"bigdaithi@h..." wrote:

> I've been trying to get this to work for ages without success, I think
> you're going to have to bite the bullet and reorganise your XML file so
> that your values are stored in elements e.g.
> 
> <!-- In Xml file -->
> <Account>
>      <FixedAssets>Value1</FixedAssets>
>      <StocksInventory>Value1</StocksInventory>
>      <Debtors>Value1</Debtors>
> </Account>
> <Account>
>      <FixedAssets>Value2</FixedAssets>
>      <StocksInventory>Value2</StocksInventory>
>      <Debtors>Value2</Debtors>
> </Account>
> 
> This would make the table layout you are looking for relatively easy to
> do.
> 
> It's not ideal but it would work!
> 
> 
> 
> 
> 
> 
> a wrote:
> > I'm trying to get a particular layout in a table.  In the included
> files, I
> > have data that I want in a table where the simple element tags are
> used as
> > column headers and the values are aligned below the column header in
> separate
> > rows.  What I keep getting is all the element values lined up under
> the first
> > column header.  There are three elements, hence 3 values in each
> column
> > before the next template fills the next colum with 3 more
> values...that's
> > what I want anyway...like this...
> >
> > Header1   Header2
> > Value1     Value1
> > Value2     Value2
> > Value3     Value3
> >
> > In my xml file it would look like this:
> >
> > FixedAssets         StocksInventory
> > 843000000          2000000
> > 1408000000        2000000
> > 1192000000        2000000
> >
> > Any ideas on how to solve this?
> > Thanks,
> >
> > Paul
> > ====================================================
> > Here is the xml file:
> > <?xml version="1.0" encoding="UTF-8"?>
> > <?xml-stylesheet type="text/xsl" href="C:\Reuters.xslt"?>
> > <xbrl xmlns="http://www.xbrl.org/2003/instance"
> > xmlns:uk-gaap-ci="http://www.xbrl.org/uk/fr/gaap/ci/2004-05-15">
> > 	<uk-gaap-ci:FixedAssets precision="INF" contextRef="cH104inst"
> > unitRef="GBP">843000000</uk-gaap-ci:FixedAssets>
> > 	<uk-gaap-ci:FixedAssets precision="INF" contextRef="cH103inst"
> > unitRef="GBP">1408000000</uk-gaap-ci:FixedAssets>
> > 	<uk-gaap-ci:FixedAssets precision="INF" contextRef="cFY03inst"
> > unitRef="GBP">1192000000</uk-gaap-ci:FixedAssets>
> > 	<uk-gaap-ci:StocksInventory precision="INF" contextRef="cH104inst"
> > unitRef="GBP">2000000</uk-gaap-ci:StocksInventory>
> > 	<uk-gaap-ci:StocksInventory precision="INF" contextRef="cH103inst"
> > unitRef="GBP">2000000</uk-gaap-ci:StocksInventory>
> > 	<uk-gaap-ci:StocksInventory precision="INF" contextRef="cFY03inst"
> > unitRef="GBP">2000000</uk-gaap-ci:StocksInventory>
> > 	<uk-gaap-ci:Debtors precision="INF" contextRef="cH104inst"
> > unitRef="GBP">920000000</uk-gaap-ci:Debtors>
> > 	<uk-gaap-ci:Debtors precision="INF" contextRef="cH103inst"
> > unitRef="GBP">1369000000</uk-gaap-ci:Debtors>
> > 	<uk-gaap-ci:Debtors precision="INF" contextRef="cFY03inst"
> > unitRef="GBP">981000000</uk-gaap-ci:Debtors>
> > </xbrl>
> >
> > ====================================================
> > And the xslt:
> > <?xml version="1.0" encoding="UTF-8"?>
> > <xsl:stylesheet version="2.0"
> > xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> > xmlns:xs="http://www.w3.org/2001/XMLSchema"
> > xmlns:n1="http://www.xbrl.org/2003/instance"
> > xmlns:uk-gaap-ci="http://www.xbrl.org/uk/fr/gaap/ci/2004-05-15"
> > xmlns:fn="http://www.w3.org/2005/02/xpath-functions"
> > xmlns:xdt="http://www.w3.org/2005/02/xpath-datatypes">
> >
> > 	<xsl:output version="1.0" encoding="UTF-8" indent="no"
> > omit-xml-declaration="no" media-type="text/html"/>
> > 	<xsl:template match="/">
> > 		<html>
> > 			<head>
> > 				<title/>
> > 			</head>
> > 			<body>
> > 				<br/>
> >
> > 				<table border="1">
> > 					<thead>
> > 						<tr>
> > 							<td>FixedAssets</td>
> > 							<td>Stocks Inventory</td>
> > 						</tr>
> > 					</thead>
> > 					<tbody>
> > 						<xsl:for-each select="n1:xbrl">
> >
> > 								<xsl:for-each select="uk-gaap-ci:FixedAssets">
> > 									<tr>
> > 										<td bgcolor="#FF0000">
> > 											<xsl:apply-templates/>
> > 										</td>
> > 									</tr>
> > 								</xsl:for-each>
> >
> > 								<xsl:for-each select="uk-gaap-ci:StocksInventory">
> > 									<tr>
> > 										<td bgcolor="blue">
> > 											<xsl:apply-templates/>
> > 										</td>
> > 									</tr>
> > 								</xsl:for-each>
> >
> > 						</xsl:for-each>
> > 					</tbody>
> > 				</table>
> >
> > 			</body>
> > 		</html>
> > 	</xsl:template>
> > </xsl:stylesheet>
> >  
> >  
> >  
> > Expand AllCollapse All
> 
>
>Thread Prev - Re: table
[Thread Next]

>Archive Index
>microsoft.public.xsl Archive Home
>Recent entries
Altova Mailing List Archives

Re: table
