I cannot find a report on the standard EXOR TMA package, which allows me to search for works that were in progress during a particular period. The 'Co-ordination Planning' report does this for in progress or upcoming works, but the results for historic works do not seem correct.
We receive many FOI enquiries relating to works that were in progress over a period and a report would be incredibly useful, exportable to Excel as the Co-ordination Planning report is.
Does such a report exist? Can one be added to our standard list? Is this not something that EXOR can provide?
I'd be surprised if this isn't standard, as this must be a common enquiry that HA's receive.
I would recommend using the Review Notices form(TMA1030), select date range and then put form in query mode. Then in Notice Type drop down choose Actual Start Date. This will bring up any when an actual start notice has been sent between chosen date.
You could look to build the report in Discoverer which can be exported.