Project ID linked to Request

Project ID linked to Request

I need to be able to generate a report where I can link Requests that have a Project Assigned and visa versa


Project Report should include the following fields from the Project Module

Project ID

Request ID (of Associated request)

Title

Project Type

Project Code

Status

Priority

Owner

Schedule Start

Schedule End

Actual End

Projected End

Estimated Hours

Actual Hrs

Estimate Cost

Actual Cost


Also, the Request Report would need to return the following and include the Project Information that is Associated with the Request

Request ID

Request Status

Customer (which is a custom request field I created)

Requestor

Subject

Created Time

Billable (which is a custom request field I created)

MT Job# (which is a custom request field I created)

Project ID

Project Status

Project Type

Owner

Schedule Start

Schedule End

Actual End

Projected End

Estimated Hours

Actual Hrs

Estimate Cost

Actual Cost


Thanks in advance

                  New to ADSelfService Plus?