Hello ... I am trying to group using muenchian method ...
The problem is that what I want and what is happening are two different things. I want the grouping by month within the "QuoteDetail". The grouping is overriding the "QuoteDetail" and the quotes are getting mixed up because of it. Is this supposed to happen or is there something wrong with my code? I am kind of new at this, so I wouldn't be surprised if I missed something important.
Thanks in advance for your help!
LK
Here is my (relevant) code:
<xsl:for-each select="XML/Quote">
<xsl:for-each select="QuoteDetail">
<xsl:for-each select="QuoteDetailDate[generate-id(.)=generate-id(key('insert-by-month',QuoteDetailDateCalendarMonth)[1])]">
<xsl:for-each select="key('insert-by-month',QuoteDetailDateCalendarMonth)">
<tr>
<td width="100" align="left"><xsl:value-of select="../NewspaperName"/></td>
<td><xsl:value-of select="QuoteDetailDateCalendarMonth"/></td>
<td></td>
<td></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAgencyPCI"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateRateType"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateScheduled"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateCampaignCode"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateAdCaption"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAdColor"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateTotalInches"/>"</td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateAdColumns"/>C x <xsl:value-of select="QuoteDetailDateAdDepth"/>"</td>
<td width="100" align="center">$<xsl:value-of select="MRCost"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAgencyColor"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAgencyPickup"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateTotalAdCost"/></td>
</tr>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>
The problem is that what I want and what is happening are two different things. I want the grouping by month within the "QuoteDetail". The grouping is overriding the "QuoteDetail" and the quotes are getting mixed up because of it. Is this supposed to happen or is there something wrong with my code? I am kind of new at this, so I wouldn't be surprised if I missed something important.
Thanks in advance for your help!LK
Here is my (relevant) code:
<xsl:for-each select="XML/Quote">
<xsl:for-each select="QuoteDetail">
<xsl:for-each select="QuoteDetailDate[generate-id(.)=generate-id(key('insert-by-month',QuoteDetailDateCalendarMonth)[1])]">
<xsl:for-each select="key('insert-by-month',QuoteDetailDateCalendarMonth)">
<tr>
<td width="100" align="left"><xsl:value-of select="../NewspaperName"/></td>
<td><xsl:value-of select="QuoteDetailDateCalendarMonth"/></td>
<td></td>
<td></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAgencyPCI"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateRateType"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateScheduled"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateCampaignCode"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateAdCaption"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAdColor"/></td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateTotalInches"/>"</td>
<td width="100" align="center"><xsl:value-of select="QuoteDetailDateAdColumns"/>C x <xsl:value-of select="QuoteDetailDateAdDepth"/>"</td>
<td width="100" align="center">$<xsl:value-of select="MRCost"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAgencyColor"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateAgencyPickup"/></td>
<td width="100" align="center">$<xsl:value-of select="QuoteDetailDateTotalAdCost"/></td>
</tr>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>
</xsl:for-each>