Embed SSRS Report in Salesforce

Question

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.

Answer 1

Hi @Pradeep Yadav ,
URL access of the report server in SQL Server Reporting Services (SSRS) enables you to send commands to a report server through a URL request.
You may have viewed the report using a specific set of report parameter values, or you may have been viewing a particular page of interest in the report. You can encapsulate this information in the URL using predefined URL access parameters. You can further customize how the report server processes the report by embedding parameters for rendering formats or for the look and feel of the report viewer. You can then paste this URL directly into an email or Web page to let others to access your report in the same manner in the browser.

Other actions you can perform through URL access are:

• Send commands to the HTML viewer, such as adjusting its look and feel
• List the children of a catalog folder
• Retrieve the XML definition of a catalog item
• Render a specific report history snapshot
• Manage report sessions

For the complete list of commands and settings available through URL access, see URL Access Parameter Reference.
For more information,please refer to: Access Report Server Items Using URL Access.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks, @Joyzhao-MSFT for the prompt reply.

I understand your point but, the issue I am having is with authentication to the SSRS server. How we can pass sessionId/Username&Password as parameter in the URL?