Workflow Manager 2014 | Report Center
Edition: This feature is available in Workflow Manager only.
You may want to customize the Projects SLA Report or Workflow Requests SLA Report. For example, you may want to rearrange columns of data, add new columns, hide columns, etc.
| • | If you want to add a new column, you need to edit the report’s associated .aspx page, as well as one of its associated stored procedures. |
| • | If you just want to rearrange columns or hide a column, you only need to edit the report’s associated .aspx page. |
SLA Reports Associated .aspx Pages and Stored Procedures
The following table lists the associated .aspx page and stored procedures for the Projects SLA Report and the Workflow Requests SLA Report.
|
Report Name |
Associated .aspx File |
Stored Procedures |
|
Projects SLA Report |
ReportCenter/CompletedTemplateSLA.aspx |
ams_template_avg_deliverytime ams_phase_avg_deliverytime ams_step_avg_deliverytime ams_StepWF_deliverytime |
|
Workflow Requests SLA Report |
ReportCenter/RequestDetailStatus.aspx |
ams_wf_status ams_wf_phase_status ams_wf_Step_status |
Modifying the Workflow Requests SLA Report
The Workflow Requests SLA Report is generated using the RequestDetailStatus.aspx file. The following table lists the input elements in that file along with each input element’s associated stored procedure.
|
Report Level |
Stored Procedure |
|
Workflow Request |
ams_wf_status |
|
Workflow Phase |
ams_wf_phase_status |
|
Workflow Step |
ams_wf_Step_status |
Name and Arrangement of Columns for Drill Down Sections
The following input elements control the name and arrangement of the columns in each drill down section. The columns will be shown in the order they are specified. The column names need to match the column returned by stored procedure mentioned above.
<input type="hidden" runat="server" id="hidWFSLAFields" value ="Request Name,Project,Template,Created Date,SLA Days,Risk Period,Actual Days,Due Date,Created By,Request Status,ApplicationID"/>
<input type="hidden" runat="server" id="hidWFPhaseDetailsFields" value ="Phase,Sort Order,Steps Count,SLA Days,Actual Days,Completed On,Completed By,PhaseID"/>
<input type="hidden" runat="server" id="hidWFStepDetailsFields" value ="Step,Sort Order,Track SLA,SLA Days,Risk Period,Actual Days,Completed On,Completed By,StepID,PhaseID"/>
Modifying the Projects SLA Report
The Projects SLA Report is generated using the CompletedTemplateSLA.aspx file. The following table lists the input elements in that file along with each input element’s associated stored procedure.
|
Report Level |
Stored Procedure |
|
Project |
ams_template_avg_deliverytime |
|
Workflow Phase |
ams_phase_avg_deliverytime |
|
Workflow Step |
ams_step_avg_deliverytime |
|
workflow Request |
ams_StepWF_deliverytime |
Name and Arrangement of Columns for Drill Down Sections
The following input elements control the name and arrangement of the columns in each drill down section. The columns will be shown in the order they are specified. The column names need to match the column returned by stored procedure mentioned above.
<input type="hidden" runat="server" id="hidTemplateAvgSLAFields" value ="Project,Template,Include Weekened for SLA,Request Count,SLA Days,Average Actual Days,Start Date,End Date,ProjectID"/>
<input type="hidden" runat="server" id="hidProjectAvgSLAFields" value ="Phase,Sort Order,Steps Count,Request Count,SLA Days,Average Actual Days,ProjectID,PhaseID"/>
<input type="hidden" runat="server" id="hidStepsAvgSLAFields" value ="Step,Sort Order,Track SLA,Request Count,SLA Days,Risk Period,Average Actual Days,CompanyID,StepID,ProjectID,PhaseID"/>
<input type="hidden" runat="server" id="hidWFSLAFields" value ="Request Name,Created Date,Due Date,Completed Date,SLA Days,Risk Period,Actual Days,TemplateID,ProjectID,RequestID"/>
See Also
Generating a Projects SLA Report
Generating a Workflow Requests SLA Report
Workflow Manager 2014 Help LibrarySeptember 23, 2014 |
Copyright Information | Contact Us |