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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy