status field in report

[Mike G.]

In MS Project, it's easy to add a status field that displays values of
"complete", "late", "future task", etc. Is this field available in the
reporting database, or do we just have to reproduce the calculation?

Thanks,

Mike G.

 

[Jonathan Sofer [MVP]]

I could not find a reference to this field in the reporting database so you
will most likely have to reproduce the calculation by creating a custom
enterprise task text field with the formula:
=IIf([Status]=0,"Completed",IIf([Status]=1,"On
Schedule",IIf([Status]=2,"Late","Future Task")))

Jonathan Sofer

 

[Mike G.]

That worked, thanks!

I could not find a reference to this field in the reporting database so you
will most likely have to reproduce the calculation by creating a custom
enterprise task text field with the formula:
=IIf([Status]=0,"Completed",IIf([Status]=1,"On
Schedule",IIf([Status]=2,"Late","Future Task")))

Jonathan Sofer

In MS Project, it's easy to add a status field that displays values of
"complete", "late", "future task", etc. Is this field available in the
reporting database, or do we just have to reproduce the calculation?

Thanks,

Mike G.

.