Hi everyone,
For reporting purposes, I need to display — at project level — two specific fields:
- One showing only open risks
- One showing only open issues
By “open” I mean those in status: Submitted, Opened, or In Work.
Currently, I’m using the standard Risks and Issues fields from the project entity, but these include all related items, regardless of status, and they are not editable.
I tried modifying the report by including Cases as related data, applying filters on status. This works in terms of filtering, but it breaks the structure of the report: I end up with one row per open case, while I need one row per project.
Has anyone found a way to:
- Filter risks and issues by status at the project level?
- Or aggregate open risks/issues into a single field or count per project?
Any suggestions or workarounds would be greatly appreciated!
Thanks in advance,
Fabrizio