This report gives you a full oversight of every job in your projects: when each job moved through each status, who it was assigned to, who declined it, and when those suppliers last logged in. It produces one row per job and covers both Standard and Codyt projects.
Report content
When creating the report you select a date range and the system selects all projects that were created within this date range. The report produces one row per job and covers both Standard and Codyt projects.
Report option: choose Canceled projects excluded (the default) or Canceled projects included. Cancelled jobs are always excluded.
Also read Languages, Dates and Currencies for important information.
Template
Screenshot of the default template:
Global placeholders
Placeholders can be placed in any location in the Excel file and their properties apply to the whole report.
|
Placeholder name |
Description |
|---|---|
|
<#GeneratedDate> |
The date when the report was generated. |
|
<#GeneratedBy> |
The name of the user who generated the report. |
|
<#DateRangeFrom> |
The start date selected when creating the report. |
|
<#DateRangeTo> |
The end date selected when creating the report. |
|
<#IncludeCancelled> |
Whether cancelled projects are included in the report. Prints Yes or No. |
Data rows and placeholders
Each row of the report corresponds to a single job. The placeholders of the row must be placed within the Excel table range named "___Lines___" (3 leading and trailing underscore characters). Click here for more details on table ranges.
A report prints the raw data in rows. Each row, you can use any of the following placeholders:
|
Placeholder name |
Description |
|---|---|
|
Project |
The project the job belongs to. |
|
<#Lines.ProjectReference> |
The project reference. |
|
<#Lines.ProjectClient> |
The client company name. |
|
<#Lines.ProjectStatus> |
The project status title. |
|
<#Lines.ProjectType> |
The type of project. Prints either "Standard" or "Codyt". |
|
<#Lines.ProjectCreationDate> |
The date when the project was created. |
|
<#Lines.ProjectCreationDateYM> |
The project creation date formatted as "year-month", such as 2026-03. |
|
<#Lines.ProjectInProgressDate> |
The date when the project entered In progress. |
|
<#Lines.ProjectCompletionDate> |
The date when the project was completed. |
|
<#Lines.ProjectManager> |
The first and last name of the project manager. |
|
<#Lines.ProjectDeadline> |
The project deadline, if any. |
|
|
|
|
Job |
The job described by this row. |
|
<#Lines.JobId> |
The unique job ID. |
|
<#Lines.JobStatus> |
The status title of the job. |
|
<#Lines.JobTaskCode> |
The task code, such as TR for translation or PROOF for proofreading. |
|
<#Lines.JobTaskName> |
The task name, such as Translation or Revision. |
|
<#Lines.JobSourceLocale>
|
The source language ISO code and name, respectively. |
|
<#Lines.JobTargetLocale>
|
The target language ISO code and name, respectively. |
|
<#Lines.JobCreationDate> |
The date when the job was created. |
|
<#Lines.JobStartDate> |
The date when the job moved to In progress. |
|
<#Lines.JobEndDate> |
The date when the job moved to Completed. |
|
<#Lines.JobTotalTimeSpent> |
The elapsed time from when the job moved to In progress to when it was Completed, formatted as dd hh:mm so the column can be sorted and filtered in Excel. This is the same elapsed time the job page shows as Work duration, written as a sortable value instead of in words and without seconds. Blank while a job is still in progress or has not started. |
|
<#Lines.JobDeadline> |
The job deadline, if any. |
|
<#Lines.JobAllocMode> |
The allocation mode of the job: Fixed assignment, Job opening or Crowd. |
|
<#Lines.JobRatingsAvg> |
The average supplier rating for the job. |
|
<#Lines.JobRatingsDate> |
The date the rating was given. |
|
|
|
|
Assigned supplier |
The supplier currently assigned to the job. |
|
<#Lines.JobCompany> |
The assigned supplier company, if any. |
|
<#Lines.JobCompanyAssignDate> |
The date the company was assigned. |
|
<#Lines.JobPerson> |
The assigned supplier contact, if any. |
|
<#Lines.JobPersonAssignDate> |
The date the contact was assigned. |
|
<#Lines.JobAssignedSupplierLastLogin> |
The last login of the assigned supplier contact. |
|
<#Lines.JobAssignedCompanyLastLogin> |
The most recent login across all contacts of the assigned company. |
|
|
|
|
Status history |
The first and last time the job was in each status. Codyt jobs leave the Draft, Proposal and Last approved columns blank. |
|
<#Lines.JobDraftInitialDate>
|
First and last time the job was in Draft. |
|
<#Lines.JobProposalInitialDate>
|
First and last time the job was in Proposal. |
|
<#Lines.JobInProgressInitialDate>
|
First and last time the job was In progress. |
|
<#Lines.JobCompletedInitialDate>
|
First and last time the job was Completed. |
|
<#Lines.JobLastApprovedDate> |
The date the job was last Approved, taken from the status history shown on the job page. Approval is a separate step from completion: a supplier marks the job Completed, then a manager approves the result, so this date is later than the Completed date. If a job was approved more than once, the most recent approval is shown. Blank when the job was never approved, and always blank for Codyt jobs, which have no Approved status. Jobs approved automatically by a workflow step record no approval entry and are also blank. |
|
|
|
|
Suppliers who declined |
Suppliers who declined the job. |
|
<#Lines.JobDeclinedSuppliers> |
The suppliers who declined the job, each shown as company (and contact) with the decline date, most recent first. |
|
|
|
|
Custom fields |
You can include any of your job and project custom fields in your report. |
|
<#Lines.JobCF1> ... <#Lines.JobCF20> |
Job custom fields 1 to 20. |
|
<#Lines.ProjectCF1> ... <#Lines.ProjectCF50> |
Project custom fields 1 to 50. |