Passing Parameters to Report Server or Report Server Web Part SharePoint 2019

Question

I'm moving from a SharePoint Integrated environment in SP 2013 to using either a Report Viewer Web Part in SP 2019 or running the report directly from the SQL Report Server 2019. In my SP 2013 environment I would pass parameters in the URL like this:

https://apps1.xyz.com/sites/abc/_vti_bin/reportServer?https://apps1.xyz.com/sites/abc/Reports/The_Reports/2.1.1 Chart.rdl&rs:Command=Render&RC:ToolBar=true&RC:Parameters=true&Scope_Group_ID=0&ID=161&Contract=ABCDEFG&PROJECT=Rollercoaster&collectdate=3/31/2020

How would I do this for:

1. A report residing in a report server web part on a SharePoint 2019 page.
2. Directly calling the report deployed to the SQL Report Server 2019.

Answer 1

Hi @Lee Polikoff
Do you mean you want to pass report parameters within the URL to SQL Report Server 2019 or Report Server Web Part SharePoint 2019? Then you can refer to this link: pass-a-report-parameter-within-a-url.
Best regards,
Aniya

Answer 2

I found the following post which answered my question: passing-parameters-to-the-report-url-not-working.html

I had to format the url like this:
https://reports-qas.abc.com/ReportServer_SSRS30A?/ABC/Reports/THE FOLDER/Main Landing Page&Contract=123-456