| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 18/03/2010 07:56:39
|
MPaulB
Super SysAider
Joined: 24/09/2009
Messages: 59
Offline
|
One of the most important CR stats for us is to compare the estimated costs with actual costs.
I planned to do this by creating a CR view that displays the column Internal Manpower in Hours along with the custom field I created called Actual Manpower In Hours. I can then export all my CRs to Excel and I have an instant review of my costs.
However neither of these fields are selectable columns when I try to create this view. Is it because they are sub-type values?
I can't see any other way if viewing this info which to me is vital to the CR managment.
|
|
|
18/03/2010 18:30:35
|
andykeppel
Elite SysAider
Joined: 24/06/2009
Messages: 177
Location: Chanhassen, MN USA
Offline
|
yeah, wow, that's going to be a toughie. All of the Action Items and their data are stored as XML in the sr_sub_tabs table.
|
Andrew Keppel
"if it's stupid but it works, it isn't stupid" |
|
|
19/03/2010 15:21:45
|
Oded M
VP Product
Joined: 28/05/2008
Messages: 891
Offline
|
Using a new feature available in 6.6 you can populate fields in the action item from other action items,
that way you can create a summary action item tab that is automatically populated with data from fields from various other action items.
Once you get all te data to one action item you can easly access what you need.
You can also create a filter under SR action item list to show you all these summary action items
hope this piece of info helped ......
Oded
|
|
|
19/03/2010 18:46:01
|
andykeppel
Elite SysAider
Joined: 24/06/2009
Messages: 177
Location: Chanhassen, MN USA
Offline
|
Sorry, just realized I posted a pretty glib response there...
You can also just write a report to pull the information out of the sr_sub_tab table. Most of those fields you're looking for actually are individual fields in the sr_sub_tab table, it's just a matter of linking the sub-tab entries to the change request entries.
A query like this would get the fields you're looking for. You could also expand the query to total the prices of the individual sub_tab action item budget / cost field as well.
The st.status and sr.sr_type values would have to change to correspond to the type of SRs you're looking to get. In my setup, this gets SRs that are "change completed" and are sub-type 4 (standard change request)
You can get all change request types by using an IN statement, and the date filter is sloppy, it was for an example....
|
Andrew Keppel
"if it's stupid but it works, it isn't stupid" |
|
|
22/03/2010 07:39:49
|
MPaulB
Super SysAider
Joined: 24/09/2009
Messages: 59
Offline
|
Oded - When is 6.6 likely to be released?
Andy - thanks for the tip. I will give it a try.
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
