Hello All,
I'm new to XSLT and XML, so please excuse the basic question. I'm trying to apply a number of conditional xsl:if statements to xsl:for-each-group, but it does not filter out the results. I'm assuming this is because the xsl:for-each-group is defining my group and not allowing the ifs to break it apart?
--------------------
Here's a sample of my XML, there are about 1200 entries of Student's, so here's one:
- <Census>
-
<Student Id="100000" ProgramType="Freshman FX" AdmitTerm="N/A">
-
<Gender>Female</Gender>
-
<Ethnicity>Unknown</Ethnicity>
-
<BirthDate>31900</BirthDate>
-
<Citizenship>N/A</Citizenship>
-
<Degree>Bachelor of Arts</Degree>
-
<Major>Business, Marketing</Major>
-
<DegreeTWO>N/A</DegreeTWO>
-
<MajorTWO>N/A</MajorTWO>
-
<Advisor>Tom</Advisor>
-
<FinHSGPA>N/A</FinHSGPA>
-
<TotCredits UG="2" Grad="3" Load="18" TransferCredits="N/A"/>
-
<PermAddress State="CA">
-
<City>Fremont</City>
-
</PermAddress>
-
<SAT1 type="N/A">
-
<Score>N/A</Score>
-
</SAT1>
-
<SAT2 type="N/A">
-
<Score>N/A</Score>
-
</SAT2>
-
<Classification>trad undergrad</Classification>
-
</Student>
-
</Census>
Here's my XSL that I'm trying to apply:
- <h3>Students by Gender</h3>
-
<xsl:for-each-group select="Census/Student" group-by="Gender">
-
<xsl:sort select="current-grouping-key()"/>
-
<xsl:if test="(Gender='Female') and
-
(Advisor='Tom')">
-
<p>Number of Students Who Are:
-
<b>
-
<xsl:value-of select="current-grouping-key()"/>
-
</b> is
-
<xsl:value-of select="count(current-group())"/>
-
</p>
-
</xsl:if>
-
-
</xsl:for-each-group>
My Desired Output will give me the count of all females, who have Tom as an advisor, as grouped by their Gender. Currently, it's not applying any of the "if" statements so it's giving me a result of 852 females, rather than the expected value of 8.
