Date of PR changing states, Report Manager

[KarlWennerholm]

Hi all,

I'm having trouble creating the following report in the Report Manager.

Preferable output:

PR Number	Under Review	Accepted	In Work	Resolved
PR-001	2013-06-01 08:00:00	2013-06-01 09:00:00	2013-06-02 08:00:00	-
PR-002	2013-07-01 08:00:00	-	-	2013-07-02 09:00:00
PR-003	and so on..
PR-004
and so on...

I would like to present the timestamps for state changed of problem reports.

Not been able to solve this, don't think it's impossible though.

Any ideas on this one, please let me know if more info is required...

[LoriSood · Accepted solution]

I have something similar for Change Notices, and modified it to work with Problem Reports. It's not formatted exactly the way you want, but it may give you an idea.