Opening Report in New Window when using Action >> "Go to Report"

Question

Hey everyone,

I've been spinning my wheels on this for a while now and not able to find any solutions on here.

I have a report that has a drillable Text Field (link) to another report.  The drillable Text Field is set up with the following:  Text Field Properties >> Action >> "Go to Report". 

I am using the "Go to Report" option because I have a lot of parameters and long value names that cause the 2nd report to error out if I use "Go to URL" because  "The full path must be less than 260 characters long; other restrictions apply. (rsInvalidItemPath)"

So the only way to drill into the 2nd report is by setting the parameters to run the report through the "Go to Report" option. This avoids the 260 characters long restriction.

However,  I Need this report to open in a New Window.  I've been usuccessful in my many many attempts in getting this to work.

Again, trying to find out how to use the Go To Report option while having the 2nd report open in a new window.

Any help would be GREATLY appreciated!

Thanks

Answer 1

Have you tried the javscript approach :-

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/7d8b2b9c-4589-4204-8a07-26454fb0751c

---

Josh Ash

Answer 2

Hello,

Thanks for your post.

In Reporting Services, if we add a drill through action by using "go to report" function, the drill through report will be opened in current browser by default.

Just as Josh post above, we can use “Go to URL” function with javascript to work around this issue. Supposing there is a parameter named “Product” in the eport, and you add a drill through URL in the filed named “Productname”. Please refer to the following expression :
="javascript:void(window.open('http://servername/reportserver?/pathto/reportname&rs:Command=Render&Product="+Fields!Productname.Value+"'))"

For more details, please see:
http://www.mssqltips.com/sqlservertip/1283/display-reporting-services-drill-through-reports-in-new-browser/

Regards,
Fanny Liu

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Fanny Liu
TechNet Community Support

Answer 3

Thank you for your responses.  I appreciate it.

However, I mentioned that "Go to URL" is not an option for me because of the following.

If I use "Go to URL" this message is displayed when accsesing the 2nd report: "The full path must be less than 260 characters long; other restrictions apply. (rsInvalidItemPath)"

So the only way to drill into the 2nd report is by setting the parameters to run the report through the "Go to Report" option. This avoids the 260 characters long restriction.

This report has about 12 parameters, most of them contain IIF statemetns, Calculations, and other formulas that causes the 260 character long restriction.

I believe is this just a limitation issue on this tool?