I think I might have solved the third problem, at least partially. I can make
the date needed by modifying the options of the data type from the structure
table. Only problem is that I can't change the option, because not all old
reports have dates. I guess I have to manually either delete the dateless
reports or add dates to them, before I can make the date compulsory and start
sorting the reports by date.

I still have no idea how to solve the first two problems, or will my sorting
idea even work.