Thanks so much for the article. We are constantly looking for ways to handle json data especially as some of the xml api are getting depreicated. Thanks!

SSRS can allow users to create reports from multiple data sources. You just have to set them up and publish them to the report server. Not sure if that is...