Answered by:
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
Thursday, April 17, 2014 8:23 PM
Answers
-
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=2008So, 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 XiongKatherine Xiong
TechNet Community Support- Proposed as answer by Visakh16MVP Monday, April 21, 2014 9:47 AM
- Marked as answer by Katherine Xiong Tuesday, April 22, 2014 1:33 AM
Monday, April 21, 2014 9:41 AM -
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
- Marked as answer by Katherine Xiong Tuesday, April 22, 2014 1:33 AM
Monday, April 21, 2014 7:20 PM
All replies
-
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.Thursday, April 17, 2014 9:34 PM -
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=2008So, 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 XiongKatherine Xiong
TechNet Community Support- Proposed as answer by Visakh16MVP Monday, April 21, 2014 9:47 AM
- Marked as answer by Katherine Xiong Tuesday, April 22, 2014 1:33 AM
Monday, April 21, 2014 9:41 AM -
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
- Marked as answer by Katherine Xiong Tuesday, April 22, 2014 1:33 AM
Monday, April 21, 2014 7:20 PM