There is a lot of good canned SQL in the current reports, but one of the challenges I see is getting it all into one report. I wish there was the equivalent of a page break so we could easily join a lot of the SQL code into one report, since differing levels of management want certain information that's already there, but not in 7 different reports.
Is there a way to do this?
You can create new Summary View (e.g. "Management Reports") and add multiple instances of 'Report From Orion Report Writer' resource. This will allow you to put several reports on one page and you can then create new Report Scheduler task to send this view to your management on regular basis or you can add this view to Orion menu if you want access it from Orion web console.
Hope this helps.