Search code examples
sql-serverbidskendo-uisql-server-data-tools

Accessing SSDT data for programmatic manipulation

I have an MSSQL 2012 Reporting server set up, and many, many reports made in Sequel Server Data Tools. I would like to have access to the data returned in those reports through C#/ASP.NET.

The end result is to display the data in the KendoUI DataViz suite, but first I need to convert the reports into JSON on the server side.

Is this possible?

Edit: To be clear, I need to know how to access the report data from the web server. Converting data into JSON format is not what I need assistance with.

Solution

  • Since I asked the question, I've learned I can use the atom feed button on the reports to download a .atom file, which contains a URL that provides report data in XML.

    You'll need to replace the & in the URL with '&', and then you have a working URL.