Possibility to add colum with detail of

[Kundanism]

Hi,

I have created a project report. Looking for possibility to add column to list the job role title with budgeted cost and one column with budgeted hours. Is there any additional criteria to add as column.

Please refer the attachment.

Best regards,

Kundan.

[KatherineLa]

Hi Kundan,

That sounds like a job for text mode, assuming that data is available in the API. When I look at the API Explorer, I see projectUserRoles, Rates and Hours as available collections, which suggests your idea should be possible.

My sample below isn't quite what you're asking, but demonstrates a way to iterate through a related collection to aggregate the Task Name and Planned Completion Date in a Project report, with the addition that I wanted only child tasks of a particular parent task.

The valueexpression portion would be where you tell it what information you want visible in the cell out of the collection.

Hopefully this gives you enough to get started.

displayname=Deployment Schedule

listdelimiter=<div>

listmethod=nested(tasks).lists

shortview=true

textmode=true

type=iterate

valueexpression=IF({parent}.{name}="Deployment Schedule" , CONCAT({name}," | ",{plannedCompletionDate},""))

valueformat=HTML

width=200