Searching and reporting for Freedom of Information Requests

Question

Is there an easy way of searching and reporting for Freedom of Information requests? 
 I have been ask to supply a spread sheet of all works on a road between one date and another. I ran the report in Query Works, but of course you cant export from there. I have tried using TMA>Reports>Coordination Planning but this does not show everything. I have then tried Locator, but for some reason this is showing no results, and even if it did I would then have to drag and drop loads of fields because a carriage return is treated as a comma in .CSV format. 
 There must be an easy way to do this and get an accurate report. Can someone please point me in the right direction. 
 Thanks

Lee Jackson · Accepted Answer

Hi Allan, 
 
The works extract via the Query Works form is a good idea and I will raise an enhancement request for you. 
 
However in the meantime, I logged into your database via Discoverer Plus and found that someone has already created a works report for you. Please could you have a look at this and see if it fulfils your requirement? 
 
The report was created in the 22nd February 2013 by the ATLAS user and is titled 'Works by date, street, tm and who'. 
 
I also noticed that your end user layer in Discoverer has already been configured to use the Information Manager Foundation layer views. The IMF views pull together related data which is normally held in separate tables, while using more intuitive column descriptions that are reliably maintained between upgrades. 
 
Please have a look at this and let us know if you have any further questions. 
 
Thanks,

Lee Jackson · Answer

Hi Allan, You can use almost any form in the exor product to query records and use the query count button to give a count of the records that would be returned for your query. If you need to produce an extract of data, then you could look at using an Information Manager 4 report, or create your own report using Oracle Discoverer. Please let us know if you have any further questions. Thanks,