I am trying to create a report and need to combine 2 variables together to get a final result for uptime. Example, %FolderAverage_AliveTime% + %FolderAverage_UnknownTime% . I am new at creating reports and am trying to do this in Custom HTML, But am totally lost. Trying for a report with following fields
Folder - Alive+Unknown - Dead - PassedTest+UnknownTest - Dead
Do you have more detailed examples on how I can do this? Thank you
Adding Variables for reports
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
Re: Adding Variables for reports
It is posible to add variables using Java script and document.writefunction. For example, to calculate PassedTest+UnknownTest value you place the following code somewhere in "Folder Title" tab of "HTML Report tepmplate" window :RRing wrote:I am trying to create a report and need to combine 2 variables together to get a final result for uptime. Example, %FolderAverage_AliveTime% + %FolderAverage_UnknownTime%.
Code: Select all
<SCRIPT type="text/javascript">
var passed_tests = %FolderTotal_PassedTests% + %FolderTotal_UnknownTests%;
document.write("<TR><TD>Total Passed tests : </TD><TD>"+passed_tests+"</TD></TR>");
</script>
However, it is almost impossible to add %FolderAverage_AliveTime% and %FolderAverage_UnknownTime%. These variables represent time, so to add two time variables you should convert them to date using Date object of Javascript. You may try if you want.
You may try to add the following code into in "Folder Title" tab of "HTML Report tepmplate" window of certain "Custom HTML" report:RRing wrote:I am new at creating reports and am trying to do this in Custom HTML, But am totally lost. Trying for a report with following fields
Folder - Alive+Unknown - Dead - PassedTest+UnknownTest - Dead
Code: Select all
<SCRIPT type="text/javascript">
alive_var = %FolderAverage_AliveRatio% + %FolderAverage_UnknownRatio%;
passed_var = %FolderTotal_PassedTests% + %FolderTotal_UnknownTests%;
document.write("<tr><td><b>%Folder% 126</td><td>"+alive_var+"</td><td>%FolderAverage_DeadRatio%</td><td>"+passed_var+"</td><td>%FolderTotal_FailedTests%</td></tr>");
</script>
Max