Matt, Yes I mean API. I've got a client with an internal system I'll be integrating with and they want to display some of the reports from that internal system on their public facing website. We've come up with a plan to run an import process once per day to put compiled data into a custom table.

Seems pretty straight forward really but what I need to do is generate queries for that compiled data (which will be provided) and automatically create the reports from a definition I'll create as there is the potential of being hundreds of them. For instance one location could have 15 reports and if you have 30 locations we're talking 450 reports. So need the reports to be dynamic and if the client decides to import a new report, I can automatically set up the report based on some values specified in a custom definition I'll create.

This is one item I'm working on. The second would be the ability to create one report with a location parameter, then in the Content Tree, pass the document name as a location parameter. I then need each of the reports have a drill down ability as well that cannot be hard coded in the report or the page in the Content Tree. Its a dashboard of sorts.

Creating them via the UI is pretty simple, just want to reduce the amount of work the client has to do on a daily basis. Ideally, I'd like to use the internal systems API and simply place an i-frame or other custom viewer on a page and dynamically display the reports that way but that's an option at the moment.

Brenden