Â¥Ö÷

Ô´Îļþ ºÍÎÊÌâÌù³öÀ´ÁË,¸øÎÒ°ïÖú ²¿·ÖҪת»»µÄxmlÎļþ <?xml version="1.0" encoding="utf-8" ?> <Report> <x:PivotField>    <x:Name>Product Family</x:Name>    <x:SourceName>[Product].[Product Family]</x:SourceName>    <x:FilterCaption>Product</x:FilterCaption>    <x:Orientation>Row</x:Orientation>    <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>    <x:AllIncludeExclude>Include</x:AllIncludeExclude>    <x:ExcludedMember>     <x:Name>Non-Consumable</x:Name>     <x:UniqueName>[Product].[All Products].[Non-Consumable]</x:UniqueName>    </x:ExcludedMember>   </x:PivotField>   <x:PivotField>    <x:Name>Product Department</x:Name>    <x:SourceName>[Product].[Product Department]</x:SourceName>    <x:Orientation>Row</x:Orientation>    <x:Position>2</x:Position>    <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>    <x:ExcludedMember>     <x:Name>Dairy</x:Name>     <x:UniqueName>[Product].[All Products].[Food].[Dairy]</x:UniqueName>    </x:ExcludedMember>    <x:ExcludedMember>     <x:Name>Baked Goods</x:Name>     <x:UniqueName>[Product].[All Products].[Food].[Baked Goods]</x:UniqueName>    </x:ExcludedMember>   </x:PivotField>   <x:PivotField>    <x:Name>Product Category</x:Name>    <x:SourceName>[Product].[Product Category]</x:SourceName>    <x:Orientation>Row</x:Orientation>    <x:Position>3</x:Position>    <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>   </x:PivotField>   <x:PivotField>    <x:Name>Product Subcategory</x:Name>    <x:SourceName>[Product].[Product Subcategory]</x:SourceName>    <x:Orientation>Row</x:Orientation>    <x:Position>4</x:Position>    <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>    <x:IncludedMember>     <x:Name>Bagels</x:Name>     <x:UniqueName>[Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels]</x:UniqueName>    </x:IncludedMember>    <x:IncludedMember>     <x:Name>Sliced Bread</x:Name>     <x:UniqueName>[Product].[All Products].[Food].[Baked Goods].[Bread].[Sliced Bread]</x:UniqueName>    </x:IncludedMember>   </x:PivotField>   <x:PivotField>    <x:Name>Brand Name</x:Name>    <x:SourceName>[Product].[Brand Name]</x:SourceName>    <x:Orientation>Row</x:Orientation>    <x:Position>5</x:Position>    <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>    <x:ExcludedMember>     <x:Name>Colony</x:Name>     <x:UniqueName>[Product].[All Products].[Food].[Baked Goods].[Bread].[Sliced Bread].[Colony]</x:UniqueName>    </x:ExcludedMember>   </x:PivotField>   <x:PivotField>    <x:Name>Product Name</x:Name>    <x:SourceName>[Product].[Product Name]</x:SourceName>    <x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>   </x:PivotField> </Report> ½âÊÍ: ÕâÊÇÒ»¸ö¶àάµÄÊý¾Ý ËùÓÐx:SourceName  ÖеÚÒ»¸ö[]ÄÚÏàͬµÄ¶¼ ÊÇÒ»¸öά,,È»ºóÒ»¸öά¿ÉÒÔÓжà¸ö¼¶±ð [Product].[Product Family] [Product].[Product Department],[Product].[Product Category] [Product].[Product Subcategory] [Product].[Brand Name] [Product].[Product Name]¶¼ ÊÇproductµÄ¼¶±ð ÏÖÔÚÎÒÏëÍê³ÉÕâÑùÒ»¸öÈÎÎñ: ÎÒÊ×ÏÈÑ¡ÔñÔÚpoductά¶ÈÖеÄËùÓÐexcludedmemberÔªËØ <xsl:for-each select="//x:ExcludedMember[substring-before(x:UniqueName,'.')='[Product']"> µÚ¶þ²½ ÎÒÏëÑ¡ÔñËüµÄx:ExcludedMember×ÓÔªËØ(¿ÉÄܺܶà),x:ExcludedMemberµ×ÏÂÓÐx:UniqueNameÔªËØ. ÎĵµÖеÄÆäËüµØ·½»¹ÓÐx:IncludedMember/x:UniqueNameÔªËØ,ÎÊÌâÊÇÎÒ²»ÏëÑ¡ÔñÂú×ãstarts-with(ÎĵµÖÐÈκÎx:IncludedMember/x:UniqueName,ÎÒµ±Ç°´¦ÀíµÄx:ExcludedMemberµÄx:UniqueName)µÄÄÇЩx:ExcludeMemberÔªËØ,ÓÚÊÇÎÒÓÖ¼ÓÁ˾äÕâÑùµÄ´úÂë not (//x:IncludedMember[starts-with(x:UniqueName,./x:UniqueName)])]"> È»ºóÎÒÏë°ÑËùÓеÄÕâÑùµÄÔªËصÄx:UniqueNameÓÃ,ºÅÁ¬ÆðÀ´,µ«×îºóÒ»¸ö²»Òª ËùÒÔ ×ܵÄxsl´úÂë ÊÇ <?xml version="1.0" encoding="gb2312" ?> <xsl:stylesheet version="1.0" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"  xmlns:x="urn:schemas-microsoft-com:office:excel"> <xsl:template name="add"> <xsl:for-each select="//x:ExcludedMember[substring-before(x:UniqueName,'.')='[Product'][not (//x:IncludedMember[starts-with(x:UniqueName,current()/x:UniqueName)])]"> Descendants(<xsl:value-of select="x:UniqueName" />)     <xsl:if test="position()!=last()">     ,     </xsl:if>   </xsl:for-each> </xsl:template> </xsl:stylesheet> µ«½á¹ûºÍÎÒÏëÒªµÄÊDz»Í¬µÄ, ²»Öª¸ÃÈçºÎÊǺà (ÖмäÔÚÌùµÄʱºò.ÓÐËùÐÞ¸Ä,ÓеãÓï·¨´íÎó,¼ûÁÂ,ÎÒ²»»á³öÄÇ·½ÃæµÄÔ­Òò) [´ËÌù×ÓÒѾ­±»×÷ÕßÓÚ2005-11-19 12:49:56±à¼­¹ý]    Êղؠ  ·ÖÏí   ¶¥(0)

	µÚ2Â¥

<xsl:template> </xsl:stylesheet> Ó¦¸ÃÊÇ </xsl:template> </xsl:stylesheet>

----------------------------------------------
ÖØÊ°Ó¢Óï...

	µÚ3Â¥

¶Ô,,ÎÒÂíÉϸĹýÀ´

	µÚ4Â¥

ÕâÑù¿ÉÒÔô£¿ <?xml version="1.0" encoding="gb2312" ?> <xsl:stylesheet version="1.0" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"  xmlns:x="urn:schemas-microsoft-com:office:excel"> <xsl:template name="add"> <xsl:for-each select="//x:ExcludedMember[substring-before(x:UniqueName,'.')='[Product'][not (//x:IncludedMember[starts-with(x:UniqueName,//x:ExcludedMember/x:UniqueName)])]"> Descendants(<xsl:value-of select="x:UniqueName" />)     <xsl:if test="position()!=last()">     ,     </xsl:if>   </xsl:for-each> </xsl:template> </xsl:stylesheet>

----------------------------------------------
ÖØÊ°Ó¢Óï...

	µÚ5Â¥

ÎÒÊÔÊÔ¿´

	µÚ6Â¥

²»Ðа¡,´ó¸ç

	µÚ7Â¥

ÒÔÏÂÊÇÎҵĽâ¾ö·½·¨  <xsl:template name="FilterExcludedMember">   <xsl:param name="Index" select="1" />   <xsl:param name="Visited" select="0" /><!--ÕâÀïΪʲô²»ÄÜÓÃ×Ö·û´®"False"-->   <xsl:param name="Super" />   <xsl:if test="$Index &lt;= count(//x:ExcludedMember)">    <xsl:variable name="Temp" select="//x:ExcludedMember[substring-before(x:UniqueName,'.')=substring-before($Super,'.')][position()=$Index]/x:UniqueName" />    <xsl:choose>     <xsl:when test="not (//x:IncludedMember[starts-with(x:UniqueName,$Temp)]) and $Visited =0">     Descendants(<xsl:value-of select="$Temp" />)     <xsl:call-template name="FilterExcludedMember">       <xsl:with-param name="Visited">        <xsl:value-of select="1" />       </xsl:with-param>       <xsl:with-param name="Index">        <xsl:value-of select="$Index + 1" />       </xsl:with-param>       <xsl:with-param name="Super">        <xsl:value-of select="$Super" />       </xsl:with-param>      </xsl:call-template>     </xsl:when>     <xsl:when test="not (//x:IncludedMember[starts-with(x:UniqueName,$Temp)]) and $Visited =1">     ,Descendants(<xsl:value-of select="$Temp" />)     <xsl:call-template name="FilterExcludedMember">       <xsl:with-param name="Visited">        <xsl:value-of select="1" />       </xsl:with-param>       <xsl:with-param name="Index">        <xsl:value-of select="$Index + 1" />       </xsl:with-param>       <xsl:with-param name="Super">        <xsl:value-of select="$Super" />       </xsl:with-param>      </xsl:call-template>     </xsl:when>     <xsl:otherwise>      <xsl:call-template name="FilterExcludedMember">       <xsl:with-param name="Visited">        <xsl:value-of select="$Visited" />       </xsl:with-param>       <xsl:with-param name="Index">        <xsl:value-of select="$Index + 1" />       </xsl:with-param>       <xsl:with-param name="Super">        <xsl:value-of select="$Super" />       </xsl:with-param>      </xsl:call-template>     </xsl:otherwise>    </xsl:choose>   </xsl:if>   <xsl:if test="$Index &gt; count(//x:ExcludedMember) and //x:PivotField[x:IncludedMember][substring-before(x:SourceName,']')=substring-before($Super,']')] and $Visited =1 ">         ,    </xsl:if>  </xsl:template>

	µÚ8Â¥

ÄãµÄÎÊÌâ½â¾öÁËô£¿

----------------------------------------------
ÖØÊ°Ó¢Óï...

	µÚ9Â¥

ÓÃÎҵķ½·¨½â¾öÁË