locked
Parameters in URL RRS feed

  • 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=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

    • 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

    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=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

    • 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

    Monday, April 21, 2014 7:20 PM