Parameters in URL

Question

I have a main report which has a details sub-report...

In the sub-report I have placed a text-box with a URL which I want it to export the sub-report in PDF

I have deployed this report on the report server

The main report has 5 parameters based on which it filters on the main report and also on the sub-report...

Now What is happening is that it is showing me the main report on the server and when i enter the parameters and "View Report" it shows me the report with all the relevant entries...

Now after i drill through, it shows me the sub-report with the relevant details too (filtered using the parameters used in the main report)

When I hit the textbox in the subreport to export it to pdf, it takes me to another browser page and I have to hit "ViewReport" again for it to show me the result...

and it shows the result without filtering over the parameters...

My URL is as follows>>

http://ssrsbedit100/Reports/Pages/Report.aspx?ItemPath=%2fIIT%2fInformatics_FirstEpisodePsychosis%2fTest16%2fTestDetail&rs:Command=Render&rs:Format=PDF

> what am I getting wrong?

---

Dhananjay Rele

Answer 1

Change the syntax from:

http://ssrsbedit100/Reports

to:

http://ssrsbedit100/ReportServer

The querystring parameter are only recognized from the latter.

---

"You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
Please Mark posts as answers or helpful so that others may find the fortune they seek.

Answer 2

Hi DJ,

Based on my research, the issue is caused by using the "normal" Report Manager URL for the WebRequest. From the document, we can know that the URL should look more like
http://myrshost/ReportServer?/AdventureWorks 2008R2/Employee_Sales_Summary_2008R2&ReportMonth=3&ReportYear=2008

So, we should browse to the report using the report server path instead report manager ("reports" is the report manager). You can try to refer to the following URL:
http://ssrsbedit100/Reportserver?/IIT/Informatics_FirstEpisodePsychosis/Test16/TestDetail&rs:Command=Render&rs:Format=PDF

If there are any other questions, please feel free to ask.

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support

Answer 3

I tried the following and it worked...

placed a Text-Box "Print to PDF"

>> right-click to Text-Box Properties

>> go to Action tab

>> select "Go to URL"

>> in the expression I wrote the following...

="http://Server_Name/ReportServer/Pages/ReportViewer.aspx?%2fpath&Param1=" & Fields!Col1.Value & "&Param2=" & Fields!Col2.Value & "&rs:Format=PDF"

simply replace bold words with appropriate/relevant pieces of information...

--Worked like a charm...

---

Dhananjay Rele