none
hyperlink to render a report

    Question

  • I have a hyper link formatted something like this to bring up a certain ssrs report on the browser.

    http://myserver/ReportServer?/ReportFolder/ReportName/&rs:Command=Render:Format=HTML4.0&ReportParam=paramVal

    I hope I have the syntax of what I'm trying to convey typed out correctly. This works and I get a page on my browser that renders the report with the correct param value. But I am missing the parameter section that normally comes up when I browse to the report page. Is there more stuff I need to specify in the hyperlink to instruct SSRS to display the parameter section so that users can change the parameter value and re-run the report?

    Tuesday, January 14, 2014 6:17 PM

All replies

  • The URL should be without the parameter for the users to put in something.

    http://myserver/ReportServer?/ReportFolder/ReportName/&rs:Command=Render:Format=HTML4.0


    Ione

    Tuesday, January 14, 2014 6:48 PM
  • Or would this more be a function of the page that is putting together that hyperlink so that it is constructed with the desired paramVal?
    Tuesday, January 14, 2014 6:48 PM
  • The URL should be without the parameter for the users to put in something.

    http://myserver/ReportServer?/ReportFolder/ReportName/&rs:Command=Render:Format=HTML4.0


    Ione


    Not true. If I have a default value set up for the param, then it will run with the default value and on the rendered page, I get no option to change and refresh. If the param does not have a default value set up, then you get an error on the browser saying you need to provide a parameter.
    Tuesday, January 14, 2014 7:05 PM
  • No, But I would use this URL http://myserver/Reports/Pages/Folder.aspx to navigate to the ReportManager which is an ASP.NET web application that provides report management/viewing capabilities for a Reporting Services instance configured in native mode.

    The URL you were using was for ReportServer.


    Ione

    Tuesday, January 14, 2014 7:05 PM
  • No, But I would use this URL http://myserver/Reports/Pages/Folder.aspx to navigate to the ReportManager which is an ASP.NET web application that provides report management/viewing capabilities for a Reporting Services instance configured in native mode.

    The URL you were using was for ReportServer.


    Ione


    I don't want to do this because I am trying to eventually build a custom web site that renders reports from SSRS. And to do that I am trying to understand the construction of the hyperlink and what I can control with it. I'm not a web developer so I don't know too much about this. I've just started to discover hyperlink capability of SSRS so I am exploring.
    Tuesday, January 14, 2014 7:17 PM
  • You could still use this URL http://myserver/Reports/Pages/Folder.aspx to build your hyperlinks, your custom website can call the SSRS via web services to render reports.


    Ione

    Tuesday, January 14, 2014 7:49 PM
  • Hi GoodOldFashionedLoverBoy,

    From the description, I understand that you want to pass report parameters within the report URL.

    The syntax that use javascript to open a URL in a new window is =”Javascript:void(window.open(‘<URL>’))” or =”Javascript:void(window.open(‘<URL>’,‘_blank’))”. To form the URL we can either point to Report Manager or to the Report Server directly. Pointing to Report Manager will display the report with the report manager wrapper, which is in most cases not required. To pass report parameters to a report by including them in a report URL, we should specify the Report Server URL. Its basic format is as shown: http://msdn.microsoft.com/en-us/library/ms155391.aspx.

    In addition, you can refer to the link: Advanced javascript in Reporting Services

    If I have any misunderstanding, please feel free to let me know.
     
    Regards,
    Heidi Duan


    Heidi Duan
    TechNet Community Support

    Wednesday, January 15, 2014 6:05 AM
  • Hi GoodOldFashionedLoverBoy,

    From the description, I understand that you want to pass report parameters within the report URL.

    The syntax that use javascript to open a URL in a new window is =”Javascript:void(window.open(‘<URL>’))” or =”Javascript:void(window.open(‘<URL>’,‘_blank’))”. To form the URL we can either point to Report Manager or to the Report Server directly. Pointing to Report Manager will display the report with the report manager wrapper, which is in most cases not required. To pass report parameters to a report by including them in a report URL, we should specify the Report Server URL. Its basic format is as shown: http://msdn.microsoft.com/en-us/library/ms155391.aspx.

    In addition, you can refer to the link: Advanced javascript in Reporting Services

    If I have any misunderstanding, please feel free to let me know.
     
    Regards,
    Heidi Duan


    Heidi Duan
    TechNet Community Support

    Yes, after much research, I see that this is possible.

    So I did something like, javascript:void(window.open('http://myServer/ReportServer?/reportFolder/ReportName&rs:Command=Render'))

    in the Action -> Go to URL setting.

    When I click on the object that has this, indeed, I get a new tab for the report I specified. Is there a way to make the report come up as a new window, not a new tab? Is this a setting in some option in my browser, rather than a javascript option? I happen to be using IE (not sure how I can look up the version, but it's a recent version, if that matters)

    Thursday, January 16, 2014 1:43 AM
  • Hi GoodOldFashionedLoverBoy,

    Thanks for your posting.

    According to your requirement, you can follow the steps:

    1.Click the Internet options and switch the General
    2.Select Tabs
    3.In Internet Explorer, please don't set the "When a pop-up is encountered" item to "Let Internet Explorer decide how pop-ups should open" or "Always open pop-ups in a new tab".

    Regards,
    Heidi Duan


    Heidi Duan
    TechNet Community Support

    Monday, January 20, 2014 6:13 AM