Hi SNOW Community!
I was wondering if anyone could help me or knows a workaround to an issue I have been facing. In Xanadu, I am using the Export to Powerpoint functionality and creating a project status report using the "Export Project" and project report functionalities.
Our goal is to use the "Project Report" template to create a project status report - using elements from the project (RIDAC, Costs, Budgets, approvals) and elements from the status report (executive summary, RAG on cost, schedule, scope) - so, simply using the 'project status report' template will not quite meet our needs.
I would like to add some formatting so that RAG statuses from a the latest Project Status Report -Schedule (project_status.schedule), Cost (project_status.cost), Scope (project_status.scope), etc.- show up as a word with the text colour of the that colour - Like Red, Amber, Green.
I seem to have got the format matter to work on other tables (cost & benefits) when using the project report template, but will not work for RAG status on project_status table. I configured a format mapping to work for the pm_project.status field, but not for any fields coming from the project_status field.
I was wondering if anyone has any experience with getting project_status RAGs conditional formatting to work when using the Project Report template?
Thanks!
Kay
