Hi all,

hoping someone can help me out here as I am a definite NOOB here. I am trying to get my reports module to run a XSLT  on output from the UDT( form and List)  datasource. The issue I face is that it shows no data in the table when I run the report. My aim here is to show a report that shows "Driver Name" and "Total" (which is a calculated column in UDT of R1+R2+...+R10)

When I click the "Show XML Source" link I get this :-

<DocumentElement xmlns="DotNetNuke/UserDefinedTable">
  <QueryResults>
    <Driver_x0020_Name>XXX AAA</Driver_x0020_Name>
    <R1>24</R1>
    <R2>0</R2>
    <R3>0</R3>
    <R4>0</R4>
    <R5>0</R5>
    <R6>0</R6>
    <R7>0</R7>
    <R8>0</R8>
    <R9>0</R9>
    <R10>0</R10>
    <CC>0</CC>
    <Total>24</Total>
  </QueryResults>
  <QueryResults>
    <Driver_x0020_Name>YYY BBB</Driver_x0020_Name>
    <R1>20</R1>
    <R2>0</R2>
    <R3>0</R3>
    <R4>0</R4>
    <R5>0</R5>
    <R6>0</R6>
    <R7>0</R7>
    <R8>0</R8>
    <R9>0</R9>
    <R10>0</R10>
    <CC>0</CC>
    <Total>20</Total>
  </QueryResults>
 

The XSL template I am using is this :-

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="utf-8"/>

<xsl:template match="/">
  <h2>Enduro Driver Standings</h2>
    <table border="1">
      <tr class="Subhead DNN_Reports_Grid_Header" align="left">
        <th width="200">Driver</th>
        <th width="200">Points</th>
      </tr>
      <tr class="Normal DNN_Reports_Grid_Row" align="left"> 
  <xsl:for-each select="/QueryResults">
   <tr class="Normal DNN_Reports_Grid_Row" align="left">
   <td><xsl:value-of select="Driver Name" disable-output-escaping="yes" /></td>
   <td><xsl:value-of select="Total" disable-output-escaping="yes" /></td>

   </tr>
  </xsl:for-each>
      </tr>
    </table>
</xsl:template>
</xsl:stylesheet>

All I get  on the output is the table heading and nothing else. What am I missing????????????? This is driving me nuts.

I am running Reports 5.1 with form and List 5.0.3 and DNN 5.1.04....

If I only select Driver Name and Total, I get an error saying that other columns are required to calculate. I have also tried just showing one column, and also all columns to no avail. I have tried also changing "Driver Name' to " Driver_x0020_Name" but this has made no difference either.

If I use the HTML Visulizer, I can get the data to display, but this shows no headers so XSLT seems to be the only option for me. Is there any other troubleshooting techniques I can use or have I made a mistake in my XSL template.

Out of Breath Now, Sorry,

Thanks in advance