Excellent, that is the pointer I needed.
Thank you Jan, I will download and start experimenting.

I'm looking for an alternative to a hugely cumbersome BI tool that requires considerable hardware resource and technical management, which has been imposed upon my team. What we actually need is a relatively lightweight reporting tool with flexible graphic representations that can do everything from heavily text based listings to presenting live dashboards with drill-able subsets. jsreport looks like a likely candidate but before downloading, experimenting and going into battle with management, I would like to establish one thing.

Our data is accessed through a series of API endpoints, which can be formatted as xml or json. The output is dynamic depending on the user requesting it and the permissions applied in the main applications. My question here is how easy is it to consume this kind of endpoint and where do I look for examples if similar techniques are already handled?

(I have developer experience but am a little ring rusty. I will be happy to download and test once I know I am not heading down a dead end street, so I will be grateful for pointers to save me time getting started before handing over to the dev team.)

Many thanks
Neill