Access SSRS report using outsystems

Access SSRS report using outsystems

  


Hi,


i am planning to create a report in SSRS and access the report using outsystems.  I would like to know whether this is possible.  

Regards

Ryoto

Hi,

Not that it's easy to find out, but not everyone knows what SSRS stands for.

Regarding your question, what do you mean by if it's possible?


First of all, if you want to integrate with external services I suggest to use Google and look for "SSRS REST API" for example...


 https://www.codeproject.com/Tips/986958/SSRS-Report-Integration-With-Web-Api

so you need to expose Rest-webservices for the report, so that is possible.


or do you mean, trigger to generate a report with a button in Outsystems, 

https://msdn.microsoft.com/en-us/library/ms154052(v=sql.90).aspx


so either way it's possible.


Hope it helps

Hi Ryoto,

You might also want to check this old thread.

OutSystems can show the SSRS report if you give it the right link. I've worked with SSRS and did a few things with iframes that used that link. (sorry, don't have it anymore, but I'll ask).

Maybe you also want to use SSRS to read OS database. That part can be trickier as the name change when you deploy changes. The ideal would be to do an external DB for the data, SSRS would read it directly with dataset and OS through integration studio.