Open linked report in new tab with multiple parameters (javascript)

  • I have a report that links to another report on the server, while the way I have it currently works the users are requesting that it opens in a new window.

    The report being linked to has two multi select parameters

    ="javascript:void('http://east-rpdb01/reports/report/Testing/Profitability%20Report%20All%20Clients&FiscalYear=" & Fields!FiscalYear.Value &"'))"


    I am close to getting this but not sure the syntax for the second parameter. I am also getting an error

    Reporting Services Error

    The path of the item '/Testing/Profitability Report All Clients&FiscalYear=2022' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

    • This topic was modified 1 year ago by  marty.seed.
  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • I can help you with the new window.  You just need _blank:

    ="javascript:void('http://east-rpdb01/reports/report/Testing/Profitability%20Report%20All%20Clients&FiscalYear=" & Fields!FiscalYear.Value & "','_blank'))"

    Per this link:

    They show this format for multiple parameters:

    https://myrshost/ReportServer?/AdventureWorks 2008R2/Employee_Sales_Summary_2008R2&ReportMonth=3&ReportYear=2008

    But based on this error: "the full path must be less than 260 characters long" .... you might be between a rock and a hard place..


    • This reply was modified 1 year ago by  SoCal_DBD.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply