This question comes up a lot when folks are first learning Deltek Cobra so I figured a blog on the subject might be appreciated. How do you create a Time-phased report that only shows hours? The default time-phased report only shows dollars. And unfortunately it’s not obvious how one should change it to show only hours when you’re running through the report wizard.
This article shows you the steps to creating a Deltek Cobra Time-phased report that shows only hours.
The Steps
Let’s say you want to run a Time-phased report in hours only, by resource assignment, then by work package.
The first step is to run the Time-phased report from the Report Wizard. To do this you can either double-click on the Time-phased report near the bottom of the All Reports view, or you can run the wizard from the Reports menu and choose Time-phased from there.
Select the project to report in the File: field at the bottom of the wizard and then click Next> until you arrive at the Sub-totals dialog.
In the Sub-totals dialog, move the Resource Assignment and Work Package items into the Selected Sub-totals list. The secret to reporting Hours is to also add the Results sub-total to the bottom of your list as shown below.
By adding the Results item, you cause the Wizard to offer the Results dialog when you click Next>. In this Results dialog you can choose HOURS from the available results list. This dialog doesn’t appear unless you choose the Results sub-total, which is probably why most folks have trouble figuring out how to report on just hours when they are new to Cobra.
From here on, you can click Next> and select the desired cost set. In this example we are choosing the Budget Cost Set.
Now finish out the wizard and the final report will output only hours in the time-phased table, sub-totaled by Resource Assignment, Work Package and then Result.
Summary
All of the sub-total options such as WBS, Control Account, Work Package etc. default to displaying total currency values in the Time-phased columns. To report HOURS or any other alternative result, you simply need to choose the Results sub-total to gain access to the Results dialog.
We’ve saved a couple of Report configuration (*.CRP) files for you to download and try out. These can be restored into your system using the same Restore feature in Cobra that you use for recovering Project file backups. Just be sure to look for *.crp files. You may need system administrator privileges to restore these files.
Time-phased report sub-totaled by Resource Assignment, by Work Package, by Result (HOURS) – T-PHASED HOURS RA-WP.zip
Time-phased report sub-totaled by Work Package, by Resource Assignment, by Result (HOURS) – T-PHASED HOURS WP-RA.zip