Hello,
We want to embed SSRS report in Salesforce page. I tried to work with REST API and Access URL.
REST API - Only returns metadata of report from SSRS. whereas we want to display report same as SSRS in Salesforce.
Access URL - It seems to work for us because we can render report using below URL in HTML page.
http://MYSERVER/ReportServer/Pages/ReportViewer.aspx?/Person&rs:Command=Render&rs:Embed=true"
But the problem is SSRS authentication prompt, Can you please suggest how we can authenticate our Access URL request. Are there any parameters we can pass or any coding part we can use?
Or any other suggestions.