April 9, 2023 at 9:03 pm
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(window.open('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)
April 10, 2023 at 9:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 19, 2023 at 4:38 pm
I can help you with the new window. You just need _blank:
="javascript:void(window.open('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..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply