Home      FAQ      Idea Exchange      Ask a Question      My Stuff      Help   
  
Report on Last Detail
It would be extremely handy for reporting purposes if there was some way of reporting on the last comment in the detail section. Often Manager's simply want to see what the latest is on various defects but we're restricted by having to report on the ENTIRE detail text which can get very large!
ID
283
Category
User Interface
  Stats & Reports
Author
NESDALE, Tim (HAM)
Date Created
7/7/2010 4:44:54 PM
Date Updated
8/20/2010 12:32:34 AM
Status
Implemented
Score
10
Promoted By
NESDALE, Tim (HAM)
Comments
Slava Shinderov  Staff  7/12/2010 3:33:51 AM
You can use "Advanced Reports" to build such report.

Please create new advanced report and replace following string in generated XSL:

<xsl:if test="detail"><td valign="top"><xsl:apply-templates select="detail"/></td></xsl:if>

with following:

<xsl:if test="detail"><td valign="top">
<xsl:apply-templates select="detail/head[last()]"/>
<xsl:apply-templates select="detail/body[last()]"/>
</td></xsl:if>

NESDALE, Tim (HAM) 8/18/2010 10:50:22 PM
Hi,

Whereabouts do I update the XML?

Thanks,
Tim

Slava Shinderov  Staff  8/19/2010 12:44:18 AM
Tim,

please edit the XSL template used to transform the raw XML data.
Learn more here:
http://www.bugtrack.net/help/3.5.2.aspx

Slava
NESDALE, Tim (HAM) 8/19/2010 5:06:40 PM
Hi,

Yes I can see how to do that when editing an Advanced Report but I'm trying to do this as a Web Query extract into an Excel Sheet so that every time I refresh the data in the spreadsheet it automatically updates to display the Last Comment in the detail record. Is this possible?

Thanks,
Tim

Slava Shinderov  Staff  8/20/2010 12:32:34 AM
No
Feedback
 
Back to Search Results