The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Resource Capacity Reporting

Highlighted
Jason Duryea
Occasional Advisor

Resource Capacity Reporting

I'm trying to locate total monthly capacity for each resource in the PPM 7.5 database tables.

Does anyone know which tables contain this information?

I currently have a Crystal report showing planned time per project for each resource, and would to do a comparison of their utilization. We're having to shift around projects, and need to know which resources are maxed out, and which ones have available planned time.
5 REPLIES
Celil
Esteemed Contributor

Re: Resource Capacity Reporting

Hi Jason,

I have a function for you. Please try this.
Could you inform me it it helpful for you?

Celil
Celil

IT Governance Professional
& PPM Solution Architect
Jason Duryea
Occasional Advisor

Re: Resource Capacity Reporting

How do I use this with Crystal Reports? I tried to copy it into a SQL Command within Database Expert, however it doesn't allow me access any database fields within Field Explorer.
Celil
Esteemed Contributor

Re: Resource Capacity Reporting

I'm sorry Duryea but I don't knoe Crystal Report.

Celil
Celil

IT Governance Professional
& PPM Solution Architect
ferl
Acclaimed Contributor

Re: Resource Capacity Reporting

Kudos to you, Celil !

This function works perfectly Version 9.12.

My problem was, that our development sprints start on 15th on a given month and last unitl the next months 15th.

This is of course not get out of the standard reports.

regards

ferdinand 

 

kintanadan
Regular Collector

Re: Resource Capacity Reporting

Kudos Celil,

 

Very helpfull!

 

Regards

//Add this to "OnDomLoad" event