Resources custom report

[SarahK]

I've looking to make a resources custom report which would look like the below:  

Resource                 Task (Activity box)                     Time

Project Manager       Provide.........                       1 hour
                                Assist with ......                0.5 hours
                                Manage ..........             0.2 hours

Business Analyst      Assist with......               2 hours
                                 ................                   .4 hours

And so on....  This information comes from the Project Management => Resource Allocation tab.  The current reports that I've been able to write doesn't key off from the resource, it only keys from the task.  The resource report would allow each resource to see all their tasks in one glance.  

Can anyone help me?

Thanks
Sarah

[Bruno.Cossi]

Hi Sarah,

look into table t_objectresource in the EAP file or your repository.

Hope this helps!
Bruno

I've looking to make a resources custom report which would look like the below:  

Resource                 Task (Activity box)                     Time

Project Manager       Provide.........                       1 hour
                                 Assist with ......                0.5 hours
                                 Manage ..........             0.2 hours

Business Analyst      Assist with......               2 hours
                                  ................                   .4 hours

And so on....  This information comes from the Project Management => Resource Allocation tab.  The current reports that I've been able to write doesn't key off from the resource, it only keys from the task.  The resource report would allow each resource to see all their tasks in one glance.  

Can anyone help me?

Thanks
Sarah

[SarahK]

Thanks for the input.  I'm a new user to EA and am not sure how to access the tables or specifically "table t_objectresource".  Can anyone tell me how to access this?

Thanks!
Sarah

[thomaskilian]

Create an ODBC source with an MS Access driver. Then import external data via Excel. Select above table for the import. Alternatively (if you have Access) you can directly open any EAP file as if it's an Access DB.

[SarahK]

Thanks for your help, Bruno and Thomas!