Opening a SSRS report in PDF format on an image click

Question

I am new to SSRS and having hard time rendering a report in PDF format.

I have a master report which within has a PDF icon. My requirement is to get a report that uses the parameters from SSRS master report and open the report in PDF format in new tab.

I tried applying the below logic from a post from Stack overflow (https://stackoverflow.com/questions/ask?title=I%20am%20new%20to%20SSRS%20and%20having%20hard%20time%20rendering%20a%20report%20in%20PDF%20format.) For example, to specify two parameters, “ReportMonth” and “ReportYear”, defined in a report, use the following URL for a native mode report server: http://myrshost/ReportServer?/AdventureWorks 2008R2/Employee_Sales_Summary_2008R2&ReportMonth=3&ReportYear=2008

but the same did not work.

**I need to pass the parameters from master report.

I am building my report using SSDT version 2017 and using HANA as DS.

Thanks in advance.

Answer 1

You will have to use the Action property with the Go to URL action of the icon. Use an expression to build the URL:

=String.Format(“http://myrshost/ReportServer/?/MyReportName&ReportMonth={0}&ReportYear={1}&rs:Format=PDF", Fields!ReportMonth.Value, Fields!ReportYear.Value)

This will replace the placeholders {0} and {1} in the string with values from your master (current) report and pass them as parameters to the MyReportName report which will be rendered as PDF.