Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > Spira Custom Reports > How to add summary to top...
I would like to include a summary section at the top of the task report. While I can manually update the values in the spreadsheet after I run the report. I would prefer this is dynamically done when the report is generated. I want it to look something like:
Tasks Not Started: 25
% Not Started: 25%
Tasks In Progress :20
% In Progress: 15%
Tasks Completed: 10
% Completed: 5%
I found a reference to a test status report that did something similar. The formatting of that report is listed below. I am not sure where the path references come from and I can't seem to update it to reference tasks instead of test sets. Any ideas?
<xsl:template match="/TestSetData"><xsl:variable name="totalPassed" select="sum(/TestSetData/TestSetFolder/TestSets/TestSet/CountPassed)"/><xsl:variable name="totalFailed" select="sum(/TestSetData/TestSetFolder/TestSets/TestSet/CountFailed)"/><xsl:variable name="totalBlocked" select="sum(/TestSetData/TestSetFolder/TestSets/TestSet/CountBlocked)"/><xsl:variable name="totalNotRun" select="sum(/TestSetData/TestSetFolder/TestSets/TestSet/CountNotRun)"/><xsl:variable name="totalExecuted" select="number($totalPassed + $totalFailed + $totalBlocked)"/><xsl:variable name="grandTotal" select="number($totalExecuted + $totalNotRun)"/>
If you look at this blog - Writing Custom Reports - Part 2
It explains where those paths come from, they are selectors into the XML format report data that you could use in a new section you add at the top of the report.