How to add summary to top of report

Friday, March 23, 2018
Avatar

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)"/>

1 Replies
Monday, April 2, 2018
Avatar
inflectra.jimx
re: tdobbelaere Friday, March 23, 2018

Hi Trudy,

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.

Regards

Jim

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Friday, March 23, 2018
  • Last Reply: Monday, April 2, 2018
  • Replies: 1
  • Views: 2802