Issue Report - Data Fields

In Projector a data field represents the information that you are interested in. For Excel Pivot Tables this information can be cross-referenced by the row and column fields to compile the data. In this image you see project profit organized by project name and month. Project Profit is the data field. Project Name is the row field. Month is the column field. If this sounds confusing, read our introductory article on pivot tables.

If your Projector installation is making use of User Defined Fields those data elements will be available for use in this report type. Client, Engagement, Project and Resource level based user defined fields will be found in each corresponding Field Category. For example, if you have defined a resource-level user defined field called Utilization Target you will find it in the Resource Fields called Resource Utilization Target.

Based on the number of Client levels defined in your installation you will have available fields under the Client Fields for each named level. For example, if your installation has two Client levels, Division and Department, you will have Division Name and Department Name as available fields.

Data Fields

Field	Field Category	Description
Category	Issue Fields	Category as defined in project workspace
Client	Client Fields
Client Inactive (Yes/No)	Client Fields
Closed (Yes/No)	Workflow Fields
Closed By	Workflow Fields
Closed On	Workflow Fields
Comments	Issue Fields
Description	Issue Fields
Due Date	Issue Fields
Engagement	Engagement Fields
Engagement Billable (Yes/No)	Engagement Fields	Yes if the engagement is a billable type
Engagement Busy (Yes/No)	Engagement Fields	Yes if the engagement is a busy type (which includes all billable types)
Engagement Code	Engagement Fields
Engagement Company	Engagement Fields	The name of the company associated with the engagement's cost center
Engagement Manager	Engagement Fields
Engagement Manager Display Name	Engagement Fields
Engagement Manager Email Address	Engagement Fields
Engagement Name	Engagement Fields
Engagement Type	Engagement Fields
Last Updated By	Workflow Fields
Last Updated On	Workflow Fields
Number	Issue Fields
Opened By	Workflow Fields
Opened On	Workflow Fields
Owner	Workflow Fields
Priority	Issue Fields	High, medium or low as set in project workspace
Project	Project Fields
Project Code	Project Fields
Project Description	Project Fields	Limited to 255 characters to support Excel 2003. Please use the Report Web Services if you require the full description.
Project Location	Project Fields
Project Manager	Project Fields
Project Manager Display Name	Project Fields
Project Manager Email Address	Project Fields
Project Name	Project Fields
Status	Workflow Fields	Status as defined in project workspace