Page History

...

1. open JobSchedulerReporting.xlsx 
   • 
     
     
2. open Execution Summary tab from the workbook
   
   • 
     
     
3. click on the cell B5 "Mandator" to select the Pivot table
   
   • 
     
     
4. click on the Data --> Connection  
   • 
     
     
     
5. double click on ODC file "JobScheduler Reporting Interface - Execution Summary"
   • 
     
     
6. select "Definition" tab and browse for the updated ODC file ( shared directory location)
   • 
     
     
7. click "Browse" , select the directory where ODC files are stored
   • 
     
     
8. select "JobScheduler Reporting Interface - Execution Summary.odc"  and click Open
   • 
     
     
     
9. next check "Always use connection file" 
10. also check "Save password" and click OK
    • 
      
      
11. click on the cell B5 "Mandator" to select the Pivot table , do a right click --> Refresh
    • 
      
      

Configure -  Execution Execution Summary Report: Monthly Executions

...