O.k., well after much searching and trial and error, I now have an xsl for my report. My report uses a stored proceedure named "MeteorlogixReportSupport" by having "Execute MeteorlogixReportSupport" in the query box. This stored proceedure is for pulling in data from a user defined table. If you wanted to use it for your own user defined table, you just need to change all of the C7.UserDefinedFieldId = 247 to the number of your id's. In this case I am using 7 columns.

The sp is :

SELECT
C5.FieldValue as 'Server Name',
C7.FieldValue as 'Server Location',
C19.FieldValue as 'System Vendor',
C20.FieldValue as 'System Type',
C21.FieldValue as 'Service Tag',
C22.FieldValue as 'Express Tag',
C23.FieldValue as 'Support'

FROM UserDefinedData
AS C5
LEFT JOIN UserDefinedData AS C7 on C5.UserDefinedRowId = C7.UserDefinedRowId and C7.UserDefinedFieldId = 247
LEFT JOIN UserDefinedData AS C19 on C5.UserDefinedRowId = C19.UserDefinedRowId and C19.UserDefinedFieldId = 258
LEFT JOIN UserDefinedData AS C20 on C5.UserDefinedRowId = C20.UserDefinedRowId and C20.UserDefinedFieldId = 259
LEFT JOIN UserDefinedData AS C21 on C5.UserDefinedRowId = C21.UserDefinedRowId and C21.UserDefinedFieldId = 260
LEFT JOIN UserDefinedData AS C22 on C5.UserDefinedRowId = C22.UserDefinedRowId and C22.UserDefinedFieldId = 261
LEFT JOIN UserDefinedData AS C23 on C5.UserDefinedRowId = C23.UserDefinedRowId and C23.UserDefinedFieldId = 262

WHERE C5.UserDefinedFieldId = 246

my xsl file looks like this :

<xsl:stylesheet version="1.0"></xsl:stylesheet> xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:user="urn:my-scripts" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:fo="http://www.w3.org/1999/XSL/format" > <xsl:template match="/*"> <table bordercolor="#000000" cellspacing="0" cellpadding="4" width="100%" border="1"> <tr class="bold"> <th> <xsl:text>Server Name</xsl:text> </th> <th> <xsl:text>Server Location</xsl:text> </th> <th> <xsl:text>System Vendor</xsl:text> </th> <th> <xsl:text>System Type</xsl:text> </th> <th> <xsl:text>Service Tag</xsl:text> </th> <th> <xsl:text>Express Tag</xsl:text> </th> <th> <xsl:text>Support</xsl:text> </th> </tr> <tr class="bold"> <td align="center" colspan="7">Total Record Count: <xsl:value-of select="count(/*/*)"></xsl:value-of> </td> </tr> </table> </xsl:template> <xsl:template match="QueryResults"> <tr class="normal"> </tr> <xsl:choose> <xsl:when test="(position() mod 2 = 1)"> <xsl:attribute name="bgcolor">#F6F6EE</xsl:attribute> <td align="center"> </td> <xsl:variable name="SN" select="Server_x0020_Name"></xsl:variable> <xsl:choose> <xsl:when test="$SN !=''"> <font color="#ff0000"> <xsl:value-of select="Server_x0020_Name" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="SL" select="Server_x0020_Location"></xsl:variable> <xsl:choose> <xsl:when test="$SL !=''"> <font color="#ff0000"> <xsl:value-of select="Server_x0020_Location" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="SV" select="System_x0020_Vendor"></xsl:variable> <xsl:choose> <xsl:when test="$SV !=''"> <font color="#ff0000"> <xsl:value-of select="System_x0020_Vendor" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="STP" select="System_x0020_Type"></xsl:variable> <xsl:choose> <xsl:when test="$STP !=''"> <font color="#ff0000"> <xsl:value-of select="System_x0020_Type" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="STG" select="Service_x0020_Tag"></xsl:variable> <xsl:choose> <xsl:when test="$STG !=''"> <font color="#ff0000"> <xsl:value-of select="Service_x0020_Tag" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="ET" select="Express_x0020_Tag"></xsl:variable> <xsl:choose> <xsl:when test="$ET !=''"> <font color="#ff0000"> <xsl:value-of select="Express_x0020_Tag" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="SP" select="Support"></xsl:variable> <xsl:choose> <xsl:when test="$SP !=''"> <font color="#ff0000"> <xsl:value-of select="Support" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise> <xsl:attribute name="bgcolor">#D3D3D3</xsl:attribute> <td align="center"> </td> <xsl:variable name="SN" select="Server_x0020_Name"></xsl:variable> <xsl:choose> <xsl:when test="$SN !=''"> <font color="#0000ff"> <xsl:value-of select="Server_x0020_Name" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="SL" select="Server_x0020_Location"></xsl:variable> <xsl:choose> <xsl:when test="$SL !=''"> <font color="#0000ff"> <xsl:value-of select="Server_x0020_Location" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="SV" select="System_x0020_Vendor"></xsl:variable> <xsl:choose> <xsl:when test="$SV !=''"> <font color="#0000ff"> <xsl:value-of select="System_x0020_Vendor" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="STP" select="System_x0020_Type"></xsl:variable> <xsl:choose> <xsl:when test="$STP !=''"> <font color="#0000ff"> <xsl:value-of select="System_x0020_Type" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="STG" select="Service_x0020_Tag"></xsl:variable> <xsl:choose> <xsl:when test="$STG !=''"> <font color="#0000ff"> <xsl:value-of select="Service_x0020_Tag" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="ET" select="Express_x0020_Tag"></xsl:variable> <xsl:choose> <xsl:when test="$ET !=''"> <font color="#0000ff"> <xsl:value-of select="Express_x0020_Tag" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> <td align="center"> </td> <xsl:variable name="SP" select="Support"></xsl:variable> <xsl:choose> <xsl:when test="$SP !=''"> <font color="#0000ff"> <xsl:value-of select="Support" disable-output-escaping="yes"></xsl:value-of> </font> </xsl:when> <xsl:otherwise> <xsl:text> </xsl:text> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:template>




What this does is creates a table with the column heads and then fills in the table with alternating text red and blue and background gray and white. It also puts a space in for nulls. It also has the count at the bottom. Any questions, please let me know.

P.S. - if anyone can help me take this and change it to an excel spread sheet, that is my next step on my learning journey.

[edited to fix formatting]