Subject: RE: [xsl] Adding subtotals to a report From: "Michael Kay" <michael.h.kay@xxxxxxxxxxxx> Date: Fri, 19 Apr 2002 10:31:17 +0100 |
> When I try summing the totals directly I get 0. > > I can do this > <xsl:value-of select="sum(/*/*/*/@Total)" /> > to get an overall total for the document. > > When I try to do this: > <xsl:value-of select="sum(/*/Project[ProjectName = > @ProjectName]/*/@Total)" /> > > I get 0 again. I know the data is there, I just need a > little help getting to it. I haven't kept your XML file and it was pretty impenetrable anyway, but the above is looking for a <Project> element that has a child ProjectName and an attribute ProjectName, both of which are equal to each other - which would seem an unlikely condition. I suspect one of these (either the child or the attribute) should be prefixed as "current()/", but I don't understand your data well enough to be sure. Send us a simplified version. Michael Kay Software AG home: Michael.H.Kay@xxxxxxxxxxxx work: Michael.Kay@xxxxxxxxxxxxxx > > -----Original Message----- > From: J.Pietschmann [mailto:j3322ptm@xxxxxxxx] > Sent: Thursday, April 18, 2002 4:51 PM > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: Re: [xsl] Adding subtotals to a report > > > David Messing 477-1289 wrote: > > <xsl:template match="ScheduleVariance"> > ... > > <td><font color="gold"><b>Total</b></font></td> > > <xsl:for-each select="Employee"> > > <xsl:variable name="subtotals"> > > <subtotal><xsl:value-of select="Total" > /></subtotal> > > </xsl:variable> > > <tr> > > <xsl:call-template name="Employee" /> > > </tr> > > </xsl:for-each> > ... > > I get the report formatted the way they want it, but when I > try to add > > this to it to get subtotals, I get variable is not defined > or in scope. > > That's because the variable is not in scope. The scope > of variables is the enclosing element, in this case > the for-each statement working on your Employee elements. > > Why don't you access the totals directly? > > <tr> > <td></td> > <td><b>Totals</b></td> > <td></td> > <td></td> > <td></td> > <td></td> > <td></td> > <td><xsl:value-of select="sum(Employee/Total)" /></td> > </tr> > > J.Pietschmann > > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list > > > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list > XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Adding subtotals to a rep, David Messing 477-1 | Thread | RE: [xsl] Adding subtotals to a rep, David Messing 477-1 |
RE: [xsl] Selecting/matching based , Michael Kay | Date | Re: [xsl] Selecting/matching based , Jeni Tennison |
Month |