Hi michale
   if i am using for-each eleemnt in for-each i am not able to get output, if i use inner for-each statement out side the outer for-each then i am getting output, why i unable to get output with this code


<xsl:if test="$MfrPartCount &gt; 0 ">
<xsl:for-each select="range[@ag_class='ManufacturerParts']">
   <xsl:element name="ManufacturerParts"></xsl:element>
   <xsl:element name="ManufacturerPartsComposition">
    <xsl:for-each select="range[@ag_class='BOS_ROHS']">
    <xsl:variable name="ROHS">
        <xsl:value-of select="cell[@id='$ROHS']/@value" />
    </xsl:variable>

    <xsl:choose>
         <xsl:when test="$ROHS=''"></xsl:when>
        <xsl:when test="$ROHS!=''">

    <xsl:element name="SubstanceNode">
      <xsl:element name="SubstanceName">
         <xsl:value-of select="cell[@id='$ag_Substance']/@value"/>
        </xsl:element>

    <xsl:choose>

    <xsl:when test="$ROHS='substances'">
    <xsl:element name="SubstanceType">
       <xsl:value-of select="$substances" />
    </xsl:element>
    </xsl:when>

<xsl:when test="$ROHS='Substance Groups' or 'Substance Group'">
                    <xsl:element name="SubstanceType">
                        <xsl:value-of select="$sg" />
                    </xsl:element>
                </xsl:when>
                </xsl:choose>


        </xsl:element>
        </xsl:when>
        </xsl:choose>
            </xsl:when>
            </xsl:choose>


                </xsl:element>
                </xsl:for-each>



Source XML file:
---------------

<ambassador>
    <document>

        <range id="MPN1" address="ag_Table!1" ag_class="ManufacturerParts" setbaseline="true">
            <cell id="$ag_PartType" value="ManufacturerParts"/>
            <cell id="$ag_ItemNumber" value="1N5239F[ITT INDUSTRIES/CANNON]"/>
            <cell id="$ag_ItemName" value=""/>
        <cell id="$ag_Specification" value="JIG A/B"/>
    </range>
    <range id="MPN2" address="ag_Table!1" ag_class="ManufacturerParts" setbaseline="true">
            <cell id="$ag_PartType" value="ManufacturerParts"/>
            <cell id="$ag_ItemNumber" value="1N5239F[ITT INDUSTRIES/CANNON]"/>
            <cell id="$ag_ItemName" value=""/>
            <cell id="$ag_Specification" value="ROHS"/>
    </range>

    <range id="1" address="ag_BOSTable!1" ag_class="BOS_ROHS" template="ag_BOSTable template" setbaseline="true">
        <cell id="$ag_JIGLevel" value="A"/>
        <cell id="$ag_Substance" value="Asbestos Compounds"/>
        <cell id="$ROHS" value="Substance Groups"/>
    </range>

    <range id="1" address="ag_BOSTable!1" ag_class="BOS_ROHS" template="ag_BOSTable template" setbaseline="true">
        <cell id="$ag_JIGLevel" value="A"/>
        <cell id="$ag_Substance" value="Cadmium"/>
        <cell id="$ROHS" value="Substance Groups"/>
        </range>
</document>
</ambassador>

You haven't shown enough of the code for me to see what the context item is. The fact that you didn't show this suggests that you haven't understood the importance of getting the context right, because this is the most likely cause of this kind of error. The relationship of your two xsl:for-each expressions also suggests confusion about context:

<xsl:for-each select="range[@ag_class='ManufacturerParts']">
   <xsl:element name="ManufacturerParts"></xsl:element>
   <xsl:element name="ManufacturerPartsComposition">
    <xsl:for-each select="range[@ag_class='BOS_ROHS']">

If the outer for-each selects anything, it will select a range element, and the inner for-each will then try to select children of this range element; but in your source document a range element never has any children called range.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Your first for-each selects range[@ag_class='ManufacturerParts'] so, assuming that works you are poised on range elements, i.e. the context node is range.
The second for-each selects range[@ag_class='BOS_ROHS'], this means all the range elements that are children of the context node, which is a range element.

--

Joe (Microsoft MVP - XML)