XSL Grouping/Headers Help Needed.

[doubledangerbat]

I'm at a total loss here, I need to create an XSL template for an XML file I have, and can't seem to figure out how to get it finished. I would appreciate any help someone can provide.

I have an xml document and the it's made up like this:

<Catalogue>
    <ProdID>1</ProdID>
    <ProdDescription>Bristol Fixture HP Sodium</ProdDescription>
    <ProdPartNo>AP-0207</ProdPartNo>
    <ProdTypeID>3</ProdTypeID>
    <ProdTypeDescription>Ornamental</ProdTypeDescription>
    <ProdCatID>2</ProdCatID>
    <ProdCatDescription>Lighting Fixtures</ProdCatDescription>
    <ProdSubCatID>4</ProdSubCatID>
    <ProdSubCatDescription>Bristol Series Fixtures</ProdSubCatDescription>
    <PDFFileName>O2-Renaissance Fixture.pdf</PDFFileName>
</Catalogue>
 

I need it to write out a header for each distinct ProdCatID and then under that, a header for each ProdSubCatID with the appropriate ProdPartNo listed under the sub categories.

I have gotten it to the point where I can get the first categories to list with each entry under them, but can't get the second to work.

Here's the code I have so far:

<xsl:template match="/">
    <!-- consider all ProdCatDescription, one by one, sorted, no double -->
    <xsl:for-each select="/NewDataSet/Catalogue/ProdCatDescription[not(../preceding-sibling::Catalogue/ProdCatDescription = .)]">
        <xsl:sort/>
        <xsl:call-template name="handle-ProdCatDescription">
            <xsl:with-param name="ProdCatDescription" select="."/>
        </xsl:call-template>
    </xsl:for-each>
</xsl:template>
 
<!-- display all ProdCatDescription for a give Catalogue -->
<xsl:template name="handle-ProdCatDescription">
    <xsl:param name="ProdCatDescription"/>
    <xsl:variable name="Catalogues" select="/NewDataSet/Catalogue[ProdCatDescription = $ProdCatDescription]"/>
    <H3>
    <xsl:value-of select="$ProdCatDescription"/>, contains <xsl:value-of select="count($Catalogues)"/> Products.
    </H3>
    <xsl:for-each select="$Catalogues">
        <xsl:sort select="ProdSubCatDescription"/>
        <xsl:sort select="ProdPartNo"/>
 
        <xsl:value-of select="ProdSubCatDescription"/> :: <xsl:value-of select="ProdPartNo"/>
        <br/>
    </xsl:for-each>
</xsl:template>
 

This results in:

Main Category Name 1
    Sub Category Name 1 :: Product Part Number
    Sub Category Name 1 :: Product Part Number
    Sub Category Name 2 :: Product Part Number
 
Main Category Name 2...etc...

I need it to look like this, if the Sub Category Names are the same...

Main Category Name 1
    Sub Category Name 1
        Product Part Number
        Product Part Number
    Sub Category Name 2
        Product Part Number
 
Main Category Name 2...etc...

I need this done and am at a complete end, any help is much appreciated. Thanks a ton.

[bharathreddy]

Dont be upset, we have a tool to create schemas called styluss. Go through the link below.

http://www.stylusstudio.com/videos/x...mlschema1.html