REPORTING - ability to update fields etc to create more relevant reports

Set reports are currently hugely limited, outside of what the product team think we wants to see. I would love the ability to create, and retrieve, my own reports albeit I appreciate PCS would only be able to supply certain fields,. A very simply eg the occupancy report is ok but ideally I'd like to see all occupants in a given period .. a simply table showing the existing occupancy report with additional reports would allow me to create timelines (not available today) + a whole host of other views. This is an incredibly simple example and there are many others I can give, but essentially give me a reporting tool that allows me to pull fields into a table and it's likely I can take care of the rest from there.