See as a mega admin when i receive a request I do something quick and write a script that print html and do simple formating and send the report
For reqular use i put the following script in a macro of a report and give user access to the report and they can create it.
For more out of the box approach put he following queries in Report headers and use a method to calculate output, whichever is your preference.
for example:
Set attrs = getSelection("Select MetaAttribute where metaclass ='Application'")
Set apps = getCollection("Application")
print "<table><tr>"
for each a in attrs
print "<th>" & a.Name & "</th>"
Next
print "</tr>"
for each app in apps
print "<tr>"
for each a in attrs
print "<td>" & app.getProp(a.ShortName) & "</td>"
Next
print "</tr>"
next
print "</table>"
